Excel 4 exam

This is the code that Excel enters in a header or footer when the Sheet Name button is clicked.

&[Tab]

A formula is said to contain a(n) _____ reference when it references a cell spanning two or more worksheets.

3-D

After you have filtered a table, what is one way to get Excel to once again display all the records?

Click the Select All check box on the filtered column's drop-down list.

Pressing and holding down this key while dragging a worksheet tab will create a copy of the worksheet in the new position.

Ctrl

The Sort & Filter button is located in the _____ group on the Home tab.

Editing

Save files in a different format with options at this backstage area.

Export

This keyboard shortcut displays the Save As dialog box to save an Excel file in a different file format.

F12

How does Excel place comments in a worksheet?

It anchors them to the active cell.

A new Excel workbook initially contains

One worksheet named Sheet1

Which of the following is an example of a formula with a 3-D reference?

SUM('Qtr1:Qtr4'!E4)

Use options in the Page Setup dialog box with this tab selected to specify printing comments in a worksheet.

Sheet

This keyboard shortcut inserts a new worksheet.

Shift + F11

What happens when you click and drag a worksheet tab in Excel?

The worksheet is moved to a different position in the workbook.

The options for choosing a template are available

at the New backstage area.

When you click the New sheet button, where is the new worksheet placed?

at the end of the existing worksheets

In Page Break Preview, a dashed line indicates this type of page break.

automatic

When you type data in a row immediately below an existing table, Excel

automatically expands the table and applies the same formatting.

A _____ is a pop-up box containing text that can be attached to a cell and that displays when the cell pointer is positioned over that cell.

comment

In Page Break Preview, page breaks are shown as _____ lines.

dashed or solid blue

To copy a format from the active cell and paste it multiple times to other cells, begin by _____ the Format Painter button.

double-clicking

A _____ is used to display only certain records within a table that meet the specified criteria.

filter

When you format a range of cells as a table, Excel displays _____ in the first row of the table.

filter arrows

By default, Excel sorts data alphanumerically, which means entries are sorted in this order:

symbols first, then numbers, then letters.

Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called

templates

When you save a workbook in an Excel 97-2003 format, the _____ extension is applied.

xls