Microsoft Office Specialist: Excel Exam Preparation: Manage tables and table data

1. Pytanie 1 z 15

   Which shortcut turns a selected data range into an Excel table?

   • ACtrl+K
   • BF11
   • CCtrl+T
   • DCtrl+1
   Pokaż odpowiedź

   Odpowiedź: C. Ctrl+T

   Ctrl+T (or Insert > Table) creates a table. Ctrl+K inserts a link, Ctrl+1 opens Format Cells and F11 makes a chart sheet.

2. Pytanie 2 z 15

   When you create a table, what does the box "My table has headers" mean?

   • AThe table will have a total row
   • BRow 1 of the range holds column names, not data
   • CThe first column is frozen
   • DExcel will add a page header to every printed page
   Pokaż odpowiedź

   Odpowiedź: B. Row 1 of the range holds column names, not data

   Tick this box when the first row holds headings. If you clear it, Excel adds its own headings (Column1, Column2…).

3. Pytanie 3 z 15

   Excel names your new table Table1. Where can you rename it to Shifts?

   • AIn the Table Name box on the Table Design tab
   • BIn File > Info > Properties
   • CIn the sheet tab
   • DIn the Format Cells dialog, on the Protection tab
   Pokaż odpowiedź

   Odpowiedź: A. In the Table Name box on the Table Design tab

   Excel gives default names like Table1; you change the name in the Table Name box on the Table Design tab.

4. Pytanie 4 z 15

   You want every second row of a table shaded to make it easier to read. Which Table Style Option do you turn on?

   • AFilter Button
   • BFirst Column
   • CBanded Rows
   • DTotal Row
   Pokaż odpowiedź

   Odpowiedź: C. Banded Rows

   Banded Rows shades alternate rows using the colours of the table style.

5. Pytanie 5 z 15

   A table covers A1:C20. You type a new name in A21, just below it. What normally happens?

   • AA second table is created
   • BRow 21 stays outside the table until you resize it
   • CExcel shows an error
   • DThe table grows to include row 21
   Pokaż odpowiedź

   Odpowiedź: D. The table grows to include row 21

   Typing in the row directly below a table expands the table to include the new row. Pressing Tab in the last cell also adds a row.

6. Pytanie 6 z 15

   Where do you turn on a table's Total Row?

   • ATable Design > Table Style Options > Total Row
   • BHome > Cell Styles > Total
   • CData > Subtotal
   • DFormulas > AutoSum > Insert Total Row below table
   Pokaż odpowiedź

   Odpowiedź: A. Table Design > Table Style Options > Total Row

   Click in the table and tick Total Row on the Table Design tab. It adds a row at the bottom with a drop-down in each cell.

7. Pytanie 7 z 15

   Which function does a table's Total Row use by default?

   • AAGGREGATE
   • BSUBTOTAL
   • CSUM
   • DTOTAL
   Pokaż odpowiedź

   Odpowiedź: B. SUBTOTAL

   Total Row choices use SUBTOTAL, for example =SUBTOTAL(109,[Hours]) for a sum, which can ignore hidden rows.

8. Pytanie 8 z 15

   This range is a table. You turn on the Total Row and choose Average under Hours. What does the total cell show?

   	A	B	C
   1	Name	Site	Hours
   2	Arjun	North	36
   3	Bea	South	28
   4	Cole	North	40
   5	Dana	East	32
   6	Emil	South	38
   7	Fern	North	24
   8	Gus	East	40
   9	Hana	North	33

   • A33.875
   • B40
   • C8
   • D271
   Pokaż odpowiedź

   Odpowiedź: A. 33.875

   Average adds the 8 hours (271) and divides by 8, which gives 33.875.

9. Pytanie 9 z 15

   You want a table to become a normal range again but keep its colours. What do you do?

   • ADelete the header row
   • BTurn off Banded Rows
   • CTable Design > Convert to Range
   • DHome > Clear > Clear Formats on the whole table
   Pokaż odpowiedź

   Odpowiedź: C. Table Design > Convert to Range

   Convert to Range removes the table features (and changes structured references to normal ones) but keeps the formatting.

10. Pytanie 10 z 15

    You need a list sorted by Department, and then by Last Name inside each department. What do you use?

    • AData > Filter on Department
    • BConditional Formatting on both columns
    • CData > Sort, then Add Level
    • DSort A to Z on Last Name, then on Department
    Pokaż odpowiedź

    Odpowiedź: C. Data > Sort, then Add Level

    The Sort dialog lets you add levels: the first level is the main sort and the next level sorts within it.

11. Pytanie 11 z 15

    You sort this table by Site (A to Z), then by Hours (largest to smallest). Whose name is in the first data row?

    	A	B	C
    1	Name	Site	Hours
    2	Arjun	North	36
    3	Bea	South	28
    4	Cole	North	40
    5	Dana	East	32
    6	Emil	South	38
    7	Fern	North	24
    8	Gus	East	40
    9	Hana	North	33

    • AGus
    • BCole
    • CArjun
    • DDana
    Pokaż odpowiedź

    Odpowiedź: A. Gus

    East comes first alphabetically. Inside East, the larger hours come first, so Gus (40) is above Dana (32).

12. Pytanie 12 z 15

    You filter Site to show only North, and filter Hours with Greater Than 30. How many data rows are visible?

    	A	B	C
    1	Name	Site	Hours
    2	Arjun	North	36
    3	Bea	South	28
    4	Cole	North	40
    5	Dana	East	32
    6	Emil	South	38
    7	Fern	North	24
    8	Gus	East	40
    9	Hana	North	33

    • A6
    • B3
    • C4
    • D2
    Pokaż odpowiedź

    Odpowiedź: B. 3

    Filters on two columns must both be true. North rows over 30 hours: Arjun, Cole, Hana.

13. Pytanie 13 z 15

    What happens to the rows that do not match a filter?

    • AThey are copied to a new sheet
    • BThey are deleted from the sheet
    • CThey are hidden until the filter is cleared
    • DThey move to the bottom of the table, below the total row
    Pokaż odpowiedź

    Odpowiedź: C. They are hidden until the filter is cleared

    Filtering only hides rows that do not match. Clear the filter to show them again.

14. Pytanie 14 z 15

    A table has filters on three columns. How do you remove all of the filter conditions in one step?

    • AData > Sort & Filter > Advanced, then OK
    • BData > Sort A to Z
    • CData > Sort & Filter > Clear
    • DDelete the header row
    Pokaż odpowiedź

    Odpowiedź: C. Data > Sort & Filter > Clear

    Clear removes every filter condition and shows all rows; the filter buttons stay.

15. Pytanie 15 z 15

    The Total Row shows Sum under Hours (=SUBTOTAL(109,[Hours])). You filter Site to South. What does the total show now?

    	A	B	C
    1	Name	Site	Hours
    2	Arjun	North	36
    3	Bea	South	28
    4	Cole	North	40
    5	Dana	East	32
    6	Emil	South	38
    7	Fern	North	24
    8	Gus	East	40
    9	Hana	North	33

    • A2
    • B66
    • C271
    • D205
    Pokaż odpowiedź

    Odpowiedź: B. 66

    SUBTOTAL with 109 ignores hidden rows, so only the visible South rows are added: 28 + 38 = 66.

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