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