Excel Tables Quiz

What is the main topic of Lesson 10?

• Working with charts

• Working with tables

• Working with formulas

• Working with spreadsheets

Bonus

• Unknown

• Unknown

What is the first step in working with tables in Excel?

• Formatting the table

• Modifying the table data

• Preparing the data

• Inserting the table

What is the main purpose of the 'Create Table' dialog box?

• To format the table

• To delete the table

• To define the data range for the table

• To modify table data

What does '$A$3:$H$9' represent in the context of creating a table in Excel?

• A single cell

• A data range

• A formula

• A chart

What does the checkbox 'My table has headers' do in the 'Create Table' dialog box?

• It adds a total row

• It formats the table

• It indicates that the first row contains column headings

• It makes the table wider

Which tab in Excel allows for inserting a table?

• Home

• Formulas

• Insert

• Data

What are two things you can add to an Excel table?

• Charts and graphs

• Rows and columns

• Formulas and functions

• Worksheets and workbooks

What is one thing you can delete from an Excel table?

• Worksheets

• Entire workbooks

• Rows

• External links

What is a data range in Excel?

• A single cell

• A group of contiguous cells

• A formula

• A chart