Excel Domain 4 Review

Which ribbon tab should you select to insert a table in a document?

• View

• Design

• Insert

• Formulas

Which button allows you to select the arrow in the column header to filter and narrow down the data?

• calculate

• effects

• filter

• styles

Which option represents a unique combination of borders and shading to alter the table's appearance?

• Fonts

• Effects

• Styles

• Colors

In which of the following formats can a table be transformed?

• Chart

• PivotTable

• SmartArt

• Data Range

Which command allows you to create a table and apply a style to it at the same time?

• Insert Table

• Data Table

• Format as Table

• From Table/Range

When selecting a cell within a table, which ribbon tab is specifically displayed for additional formatting options?

• Format

• Analyze

• Design

• View

By default, which type of row is automatically included when a new table is created?

• header

• footer

• chart

• numbered

How can you enable or disable the Filter button in a spreadsheet?

• Select a cell within the table, right-click or open the context menu, choose Filter, and then select either Clear Filter from or Reapply.

• Navigate to the Home tab, find the Editing group, click on Sort & Filter, and then select Filter.

• Go to the Design tab, locate the Tools group, and choose Summarize with PivotTable.

• Access the Data tab, go to the Queries and Connections group, and select Refresh All.

In a table, which row is specifically designed to perform calculations using functions on numeric data?

• Header Row

• Total Row

• Banded Row

• Footer Row

_________ rows are those even-numbered rows in a table that are visually distinguished from odd-numbered rows for better readability.

• Banded

• Bolded

• Styled

• Total