Exam 8: Excel : Datasets and Tables

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

Which of the following is not a way to bring up the Go To dialog box?

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?

Locking is the process of making sure that certain rows or columns are visible at all times.

It is impossible to create a data table from random, unorganized data.

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

Filter arrows are always displayed in data tables.

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

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

What data does Excel print by default?

In the formula =SUBTOTAL(102,[PAID]), what does the 102 represent?

After a table has been named, that name can be used in functions instead of cell references.

On which tab will you find options if you have to print a large dataset?

Match the following terms with their description: I. Color scale II. Icon set III. Filtering IV. Sorting V. Data bars A. Colors are based on the relative values in the cell. B. Arranging records C. Symbols or signs that classify data D. Various widths represent the cell's value. E. Using conditions to limit the visible data

When would you not need to use a fully qualified structured reference?

Which wildcard character only replaces one character with one other character?

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

What is not true about tables in Excel?