Using tables – Excel MCQs

  1. What is one advantage of using tables in Excel?
    a) Tables cannot be filtered
    b) Tables automatically expand as new data is added
    c) Tables cannot be sorted
    d) Tables disable formula use
    Answer: b) Tables automatically expand as new data is added
  2. How can you create a table in Excel?
    a) Insert tab -> Table
    b) Data tab -> Sort
    c) Home tab -> Format
    d) View tab -> Tables
    Answer: a) Insert tab -> Table
  3. Which feature allows you to quickly format a table with a predefined style?
    a) Filter
    b) Conditional Formatting
    c) Table Styles
    d) Sort
    Answer: c) Table Styles
  4. What does the Total Row option in a table allow you to do?
    a) Sort data
    b) Filter data
    c) Add summary functions like SUM, AVERAGE
    d) Change cell color
    Answer: c) Add summary functions like SUM, AVERAGE
  5. How can you convert a range of data back to a normal range from a table?
    a) Data tab -> Convert to Range
    b) Home tab -> Clear Formatting
    c) Insert tab -> Remove Table
    d) Design tab -> Convert to Range
    Answer: d) Design tab -> Convert to Range
  6. Which symbol is used in table formulas to reference table columns?
    a) #
    b) $
    c) [ ]
    d) &
    Answer: c) [ ]
  7. What happens when you use the Filter button in a table header?
    a) Data in the table is sorted
    b) Data in the table is filtered based on criteria
    c) Data in the table is deleted
    d) Data in the table is highlighted
    Answer: b) Data in the table is filtered based on criteria
  8. Which of the following options can be used to add a new row to an Excel table?
    a) Press Enter at the last cell of the table
    b) Right-click and select “Insert Row”
    c) Use the Tab key in the last cell of the table
    d) All of the above
    Answer: d) All of the above
  9. How can you rename a table in Excel?
    a) Right-click the table and select Rename
    b) Design tab -> Table Name box
    c) Data tab -> Table Name box
    d) Home tab -> Format Table
    Answer: b) Design tab -> Table Name box
  10. What feature of tables allows you to automatically apply alternating row colors?
    a) Conditional Formatting
    b) Table Styles
    c) Data Bars
    d) Cell Styles
    Answer: b) Table Styles
  11. Which feature is NOT available when using tables in Excel?
    a) Automatic column sorting
    b) Automatic column filtering
    c) PivotTables
    d) Macros
    Answer: d) Macros
  12. What happens to formulas when you convert a range to a table?
    a) Formulas are deleted
    b) Formulas are converted to structured references
    c) Formulas become static
    d) Formulas are hidden
    Answer: b) Formulas are converted to structured references
  13. Which tab appears when you select a table in Excel?
    a) Table Tools
    b) Design
    c) Format
    d) Data
    Answer: b) Design
  14. What does the “Remove Duplicates” option in a table do?
    a) Deletes duplicate rows in the table
    b) Highlights duplicate rows in the table
    c) Hides duplicate rows in the table
    d) Merges duplicate rows in the table
    Answer: a) Deletes duplicate rows in the table
  15. How can you add a slicer to a table in Excel?
    a) Data tab -> Insert Slicer
    b) Home tab -> Insert Slicer
    c) Insert tab -> Slicer
    d) Design tab -> Insert Slicer
    Answer: d) Design tab -> Insert Slicer

Related Posts: