Excel Tables

What is an Excel table?

• A) A place to store data

• A range of cells with formatting

• A chart in Excel

• A mathematical formula in Excel

Which of the following is not a feature of an Excel table?

• Automatic sorting and filtering

• Automatic totals row

• Data validation

• Automatic cell formatting

What is the primary advantage of using Excel tables?

• They make your data look pretty

• They can perform complex calculations

• They automatically expand when you add new data

• They can create macros

How do you create a table in Excel?

• By clicking on a cell

• By typing "table" in a cell

• by selecting a range of data and clicking "Insert Table"

What is the purpose of the "Total Row" in an Excel table?

• It adds up all the numbers in the table

• It displays the total number of rows in the table

• It provides a summary of calculations for the selected column

• It highlights the last row of the table

Which of the following is not a valid data type for a column in an Excel table?

• Text

• Number

• Date

• mage

What is the shortcut key to create a table in Excel?

• Ctrl + T

• Alt + T

• Shift + T

• Ctrl + Shift + T

True or false you can convert a table back to a range?

• True

• False

How can you convert an Excel table back to a range?

• Press Ctrl + T to toggle between a table and a range.

• Right-click the table, then select "Convert to Range" from the context menu.

• Select the entire table and press the Delete key.

• Use the "Convert" option from the Table Design ribbon.