Microsoft Office Specialist: Excel Exam Preparation: Manage data cells and ranges

1. Pytanie 1 z 20

   You need to copy the formatting of cell A1 to three different ranges, one after another. What is the best way?

   • ASingle-click Format Painter and click all three ranges
   • BCopy A1 and press Ctrl+V on each range
   • CDouble-click Format Painter, then click each range
   • DUse Merge & Center on each range
   Pokaż odpowiedź

   Odpowiedź: C. Double-click Format Painter, then click each range

   Double-clicking Format Painter keeps it on until you press Esc. A single click applies it only once. Ctrl+V would paste the contents too.

2. Pytanie 2 z 20

   A long comment in B4 runs into the next cells. Which option shows it on several lines inside B4?

   • AOrientation
   • BIncrease Indent
   • CMerge & Center
   • DWrap Text
   Pokaż odpowiedź

   Odpowiedź: D. Wrap Text

   Wrap Text breaks long text onto more lines inside the same cell and makes the row taller.

3. Pytanie 3 z 20

   A1 contains "Report" and B1 contains "2026". You select A1:B1 and choose Merge & Center. What does the merged cell show?

   • A2026
   • BNothing; both values are deleted
   • CReport
   • DReport 2026
   Pokaż odpowiedź

   Odpowiedź: C. Report

   When you merge cells, Excel keeps only the value in the upper-left cell and discards the others.

4. Pytanie 4 z 20

   Column C has formulas. You want to paste only their current results into column F, with no formulas. Which Paste Special option do you use?

   • AValues
   • BFormats
   • CPaste Link
   • DFormulas
   Pokaż odpowiedź

   Odpowiedź: A. Values

   Paste Special > Values pastes the displayed results without formulas or formatting.

5. Pytanie 5 z 20

   Your data runs down A1:A12 and you want the same data across a row instead. Which Paste Special option does this?

   • ASkip blanks
   • BColumn widths
   • CTranspose
   • DValues
   Pokaż odpowiedź

   Odpowiedź: C. Transpose

   Transpose swaps rows and columns, so data in a column is pasted across a row.

6. Pytanie 6 z 20

   You copy D2, select B2:B5 and choose Paste Special > Multiply. What does B4 show afterwards?

   	A	B	C	D
   1	Item	Price		Increase
   2	Gloves	12.40		1.05
   3	Vests	38.00
   4	Radios	145.00
   5	Lights	22.60

   • A7.25
   • B152.25
   • C138.10
   • D146.05
   Pokaż odpowiedź

   Odpowiedź: B. 152.25

   Multiply multiplies each destination value by the copied value: 145.00 × 1.05 = 152.25.

7. Pytanie 7 z 20

   You type Mon in A2 and drag the fill handle down to A6. What appears in A6?

   • AThu
   • BSat
   • CFri
   • DMon
   Pokaż odpowiedź

   Odpowiedź: C. Fri

   Auto Fill continues a known list such as weekdays. A2 to A6 is five cells: Mon, Tue, Wed, Thu, Fri.

8. Pytanie 8 z 20

   You select A2:A3 and drag the fill handle down to A7. What does A7 show?

   	A
   1	Week
   2	5
   3	10
   4
   5
   6
   7

   • A35
   • B25
   • C30
   • D10
   Pokaż odpowiedź

   Odpowiedź: C. 30

   With two numbers selected, Auto Fill continues the step (+5): 5, 10, 15, 20, 25, 30.

9. Pytanie 9 z 20

   Which values can =RANDBETWEEN(1,6) return?

   • AAny whole number from 1 to 6
   • BAny whole number from 2 to 5
   • CAny decimal number between 1 and 6
   • DOnly 1 or 6
   Pokaż odpowiedź

   Odpowiedź: A. Any whole number from 1 to 6

   RANDBETWEEN returns a random whole number between bottom and top, and both limits are included.

10. Pytanie 10 z 20

    You fill 20 cells with =RANDBETWEEN(100,999) for test ID numbers. You do not want them to change again. What should you do?

    • AFormat them as Number with no decimal places
    • BPress F9
    • CApply Wrap Text
    • DCopy them and paste back as Values
    Pokaż odpowiedź

    Odpowiedź: D. Copy them and paste back as Values

    RANDBETWEEN gives a new number every time the sheet recalculates (for example when you press F9). Pasting as Values keeps the numbers fixed.

11. Pytanie 11 z 20

    You enter =SEQUENCE(3,1,100,10) in A2. What is in A4?

    • A30
    • B130
    • C120
    • D102
    Pokaż odpowiedź

    Odpowiedź: C. 120

    SEQUENCE(3,1,100,10) gives 3 rows starting at 100 and stepping by 10: 100, 110, 120. A4 is the third value.

12. Pytanie 12 z 20

    You enter =SEQUENCE(2,3) in A1. What is in A2?

    • A3
    • B4
    • C6
    • D2
    Pokaż odpowiedź

    Odpowiedź: B. 4

    SEQUENCE(2,3) fills 2 rows and 3 columns across each row first: row 1 is 1, 2, 3 and row 2 is 4, 5, 6. A2 starts row 2.

13. Pytanie 13 z 20

    You want to remove the bold, fill colour and borders from A1:D10 but keep the values. What do you use?

    • APress Delete
    • BHome > Clear > Clear Contents
    • CHome > Clear > Clear Formats
    • DHome > Clear > Clear All
    Pokaż odpowiedź

    Odpowiedź: C. Home > Clear > Clear Formats

    Clear Formats removes formatting only. Clear Contents and Delete remove values; Clear All removes both.

14. Pytanie 14 z 20

    You Ctrl+click the tabs Jan, Feb and Mar, then make row 1 bold in Jan. What happens?

    • ARow 1 becomes bold on all three sheets
    • BOnly Jan changes
    • CThe three sheets are merged into one
    • DExcel asks you to copy the format to the other sheets
    Pokaż odpowiedź

    Odpowiedź: A. Row 1 becomes bold on all three sheets

    Clicking tabs with Ctrl groups the sheets ([Group] shows in the title bar). Formatting you apply then changes every grouped sheet.

15. Pytanie 15 z 20

    Which of these is a valid name for a named range?

    • A1stQuarter
    • BTax_Rate
    • CTax Rate
    • DB12
    Pokaż odpowiedź

    Odpowiedź: B. Tax_Rate

    Names cannot contain spaces, cannot look like a cell reference such as B12, and must start with a letter, underscore or backslash.

16. Pytanie 16 z 20

    A1:C1 holds the headings Site, Guard and Hours, with data in rows 2–10. You select A1:C10 and use Formulas > Create from Selection with Top row checked. What range does the name Hours refer to?

    • AA2:C2
    • BA1:C10
    • CC1:C10
    • DC2:C10
    Pokaż odpowiedź

    Odpowiedź: D. C2:C10

    Create from Selection names each column's data using its label in the top row, so Hours refers to the data cells below that heading.

17. Pytanie 17 z 20

    You want Excel to highlight the 3 highest sales in B2:B30 automatically. Which built-in conditional formatting do you use?

    • ATop/Bottom Rules > Top 10 Items (set to 3)
    • BData Bars > Gradient Fill on the top three cells
    • CHighlight Cells Rules > Duplicate Values
    • DTop/Bottom Rules > Below Average
    Pokaż odpowiedź

    Odpowiedź: A. Top/Bottom Rules > Top 10 Items (set to 3)

    Top 10 Items lets you set how many top values to highlight, such as 3.

18. Pytanie 18 z 20

    A sheet has several old conditional formatting rules in different places. How do you remove all of them at once?

    • AConditional Formatting > Manage Rules > New Rule
    • BHome > Clear > Clear Contents
    • CClear Rules > Clear Rules from Entire Sheet
    • DUndo several times
    Pokaż odpowiedź

    Odpowiedź: C. Clear Rules > Clear Rules from Entire Sheet

    Clear Rules from Entire Sheet removes every conditional formatting rule on the sheet but keeps the data.

19. Pytanie 19 z 20

    Which three sparkline types does Excel offer?

    • ALine, Pie and Area
    • BColumn, Bar, Scatter and Area
    • CLine, Column and Win/Loss
    • DLine, Column and Pie
    Pokaż odpowiedź

    Odpowiedź: C. Line, Column and Win/Loss

    Excel sparklines come in three types: Line, Column and Win/Loss.

20. Pytanie 20 z 20

    You inserted a line sparkline in F2. How do you remove it?

    • AClear on the Sparkline tab
    • BDelete the data in B2:E2
    • CPress Backspace in F2
    • DUse Home > Clear > Clear Formats
    Pokaż odpowiedź

    Odpowiedź: A. Clear on the Sparkline tab

    A sparkline is a tiny chart in the cell background; you remove it with Clear on the Sparkline tab.

Klawiatura: 1–4, aby odpowiedzieć, Enter – następne pytanie.