Excel Domain 4 Review

Front

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

Back

Insert

Front

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

Back

filter

Front

Which option represents a unique combination of borders and shading to alter the table's appearance? Options: Fonts, Effects, Styles, Colors

Back

Styles

Front

In which of the following formats can a table be transformed? Chart, PivotTable, SmartArt, Data Range

Back

Data Range

Front

Which command allows you to create a table and apply a style to it at the same time? Options: Insert Table, Data Table, Format as Table, From Table/Range

Back

Format as Table

Front

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

Back

Design

Front

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

Back

header

Front

How can you enable or disable the Filter button in a spreadsheet? Options: 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.

Back

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

Front

In a table, which row is specifically designed to perform calculations using functions on numeric data? Options: Header Row, Total Row, Banded Row, Footer Row

Back

Total Row

Front

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

Back

Banded