Microsoft Excel (Core) Lesson 7

Banding a table means to:

Apply a light and dark shade of a color to alternating rows or columns of a table

A range name cannot contain a(n):

Blank space

Which of the following comparison operators can be used for filtering text, numbers, and dates:

Equals and Does not equal

The Remove Duplicates feature will reliably delete all rows that contain duplicate data even though the data may have minor variations such as extra blanks, commas, or different spellings

False

Which dialog box can be used to add, modify or delete names ranges in a worksheet?

Name Manager dialog box

Where will you find the options you need to export Excel data to a Comma Separated Values (CSV) file?

The Save As dialog box

To create a table, the following conditions must be met:

The date in the range of cells must be contiguous, and be arranged in row (not column) order

When converting a range of data to a table, why do you need to tell Excel whether or not the data has headers?

To ensure that the first row of data is treated as the column headers and not included with the data

Multiple levels of sorting are useful whenever the column you are using for sorting has multiple rows with the same value

True

Once you have added a set of subtotals (for example, SUM) for a column of numeric data in a range of cells, you can also add more subtotals for the same column such as AVERAGE and MAX

True