Exam 4: Datasets and Tables

To what does the @ symbol refer in a structured reference?

In a data table you can use ________ references in place of cell references inside the formulas.

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

The print ________ is the range of cells that will be printed.

In a structured reference what do you use to indicate a column heading or field name?

Which table style option shows the field names when it is checked?

When you use the Freeze Panes option you freezing both columns and rows.

The Table Styles ________ shows you all the table styles which are available.

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

In conditional formatting what happens if the cell value does not pass the logical test?

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?

What is not true about creating a data table?

Using the Print ________ can help you save paper.

Which of the following is not a conditional formatting option?

Use the Sort by ________ Color if you want to sort records by the color of the text.

Which of the following is not a characteristic of a table?

Where does Excel display the Total row in a table?

Which one of the following filter options is not found on the date filter submenu?