Excel Tables Query Quiz 12

by
Post Views: 235

Think you know Excel tables inside out? Put your knowledge to the test with this interactive Excel Tables Query Quiz! This quiz challenges you on key concepts like structured references, table formatting, sorting/filtering, and data manipulation. Whether you are a beginner or an Excel pro, see how well you can navigate and query tables efficiently. Let us start with the Online MS Excel Tables Query Quiz now.

MS Excel Tables Query Quiz with Answers

Online Excel Tables Query Quiz with Answers

1. Selecting all the data (apart from column headings) in a Table, and clicking delete on the ribbon will:

 
 
 
 
 

2. Tables created through Excel’s table feature allow users to filter ———– by different values.

 
 
 
 

3. Structured references do not allow for automation with tables as we add new records to our database.

 
 

4. The fastest way to sort a table according to more than one criterion is to use one of the drop-down menus at the top of each column heading.

 
 

5. Creating tables is as easy as highlighting cells that have already been filled in appropriately and then clicking on the Insert tab and then clicking on the table button.

 
 
 
 

6. One key automation that tables combined with named ranges allow is that:

 
 
 
 

7. Not all data lends itself to be converted to a Table, usually, it is data organised by columns to represent fields, and rows to represent records.

 
 

8. Only structured referencing can be used within a Table.

 
 

9. The fastest way to sort a table according to a single criterion is to use one of the drop-down menus at the top of each column heading.

 
 

10. When updating a Table with a new record, any created Slicers will update.

 
 

11. If you want to access the sorting and filtering tools for tables, you could:

 
 
 
 

12. If a chart is constructed using data from a Table, this will automatically update when data is added/removed from the Table.

 
 

13. What is the key difference when using structured references within a Table and structured references outside a Table?

 
 
 
 

14. What are the keyboard shortcut keys to insert a table?

 
 
 
 

15. Excel automatically recognises that some columns contain a certain kind of format and provides useful filters in light of this, such as text filters for text data.

 
 

16. For a table to work properly, the top row should have column headings. Yes or no?

 
 
 
 

17. Which of the following does a Table automatically update when creating a new record?

 
 
 
 
 

18. A course has two tables: Table 1 (on the left), which contains all the students who enrolled in the course at the beginning of the school year, and includes students who have dropped out since January. Table 2 (on the right) contains all currently enrolled students in this course who sat for an exam.

What type of join do we need to figure out which students have dropped out of the course?

 
 
 
 
 
 

19. Structured references have the following properties:

 
 
 
 

20. Once data in a table gets filtered, you cannot unfilter the table nor get the table back to the original settings. Is this statement correct?

 
 
 
 

Online Excel Tables Query Quiz with Answers

  • Not all data lends itself to be converted to a Table, usually, it is data organised by columns to represent fields, and rows to represent records.
  • If you want to access the sorting and filtering tools for tables, you could:
  • Excel automatically recognises that some columns contain a certain kind of format and provides useful filters in light of this, such as text filters for text data.
  • The fastest way to sort a table according to a single criterion is to use one of the drop-down menus at the top of each column heading.
  • The fastest way to sort a table according to more than one criterion is to use one of the drop-down menus at the top of each column heading.
  • Structured references have the following properties:
  • Only structured referencing can be used within a Table.
  • If a chart is constructed using data from a Table, this will automatically update when data is added/removed from the Table.
  • What is the key difference when using structured references within a Table and structured references outside a Table?
  • One key automation that tables combined with named ranges allow is that:
  • Which of the following does a Table automatically update when creating a new record?
  • When updating a Table with a new record, any created Slicers will update.
  • Selecting all the data (apart from column headings) in a Table, and clicking delete on the ribbon will:
  • Structured references do not allow for automation with tables as we add new records to our database.
  • A course has two tables: Table 1 (on the left), which contains all the students who enrolled in the course at the beginning of the school year, and includes students who have dropped out since January. Table 2 (on the right) contains all currently enrolled students in this course who sat for an exam. What type of join do we need to figure out which students have dropped out of the course?
  • Tables created through Excel’s table feature allow users to filter ———– by different values.
  • Creating tables is as easy as highlighting cells that have already been filled in appropriately and then clicking on the Insert tab and then clicking on the table button.
  • Once data in a table gets filtered, you cannot unfilter the table nor get the table back to the original settings. Is this statement correct?
  • For a table to work properly, the top row should have column headings. Yes or no?
  • What are the keyboard shortcut keys to insert a table?

Take ggplot2 Data Visualization Quiz

Leave a Comment

Discover more from Statistics for Data Science & Analytics

Subscribe now to keep reading and get access to the full archive.

Continue reading