With the indicated table cell selected, tap [Enter] to add a new row at the bottom of the table.

Table shows a list of students and grades. The bottom-right table cell is selected.

True

False

Correct!

Review the section "Insert and Delete Table Rows and Columns."

Editing a formula in one table cell will update the formula for the entire column.

True

False

Correct!

Review the section "Calculated Columns."

Creating a unique table name is necessary when creating formulas with structured references.

True

False

Correct!

Review the section "Table Name."

This structured reference refers to the Quizzes column in the Grades table: =Quizzes[Grades]

True

False

Correct!

Review the section "Understanding Structured References."

You can use the data in the range A5:B20 to insert a single sparkline.

True

False

Correct!

Review the section "Creating Sparklines."

Adding a total row to a table will automatically insert the _____ function in the last column.

Count

Sum

Average

Max

Correct!

Review the section "Total Row."

Which command do you use to remove a record from a table without affecting surrounding worksheet data?

Delete Sheet Rows

Delete Sheet Columns

Insert Table Rows

Delete Table Rows

Correct!

Review the section "Insert and Delete Table Rows and Columns."

How can you alter the display of this table to show only employees in the Western region while retaining the data for the other employees to use later?

A table with seven employees listed (rows) and six columns with various data for names, etc. The far-right column has the heading Region, and three different regions are listed.

Sort the table by region.

Filter the table by region.

Delete the table rows that contain employees in the Central or Eastern regions.

Hide the Region column.

Correct!

Review the section "Apply a Sort or Filter."

Which option applies alternating light and dark shading to table rows?

Header Row

Banded Columns

Banded Rows

First Column

Correct!

Review the section "Special Table Features."

In the structured reference Sales[January], what does each part refer to?

Sales is the table name and January is the column header.

January is the table name and Sales is the column header.

Sales is the row and January is the column header.

None of these options

Correct!

Review the section "Understanding Structured References."

Your table includes the header name Annual Sales. Which of these shows the format for the structured reference to that column?

[@[Annual Sales]]

[@Annual Sales]

@Annual Sales

[@]Annual Sales]

Correct!

Review the section "Understanding Structured References."

Which statement about sparklines is NOT accurate?

Formatting one sparkline will update all sparklines in the same group automatically.

A sparkline contains the data for one column or row at a time.

Sparklines are updated when the data associated with them changes.

You cannot change the sparkline type, so be sure to use the correct one.

Correct!

Review the section "Creating Sparklines."