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

1. السؤال 1 من 15

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

   • ACtrl+K
   • BF11
   • CCtrl+T
   • DCtrl+1
   أظهر الإجابة

   الإجابة: 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. السؤال 2 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 3 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 4 من 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
   أظهر الإجابة

   الإجابة: C. Banded Rows

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

5. السؤال 5 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 6 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 7 من 15

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

   • AAGGREGATE
   • BSUBTOTAL
   • CSUM
   • DTOTAL
   أظهر الإجابة

   الإجابة: B. SUBTOTAL

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

8. السؤال 8 من 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
   أظهر الإجابة

   الإجابة: A. 33.875

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

9. السؤال 9 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 10 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 11 من 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
    أظهر الإجابة

    الإجابة: A. Gus

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

12. السؤال 12 من 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
    أظهر الإجابة

    الإجابة: B. 3

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

13. السؤال 13 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 14 من 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
    أظهر الإجابة

    الإجابة: C. Data > Sort & Filter > Clear

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

15. السؤال 15 من 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
    أظهر الإجابة

    الإجابة: B. 66

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

لوحة المفاتيح: 1–4 للإجابة، وEnter للسؤال التالي.