Excel Exam

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

A ____ is a prewritten formula that is built into Excel.

A ____ is text and graphics that print at the bottom of every page.

A ____ is text and graphics that print at the top of each page.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Clicking the ____ opens the Insert Function dialog box.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

Point mode allows you to ____, as shown in the accompanying figure.

The adjusted cell references in a copied and pasted formula are called ____ cell references.

The default view in Excel is called ____ view.

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

The ____ function determines the lowest number in a range.

The ____ function displays the highest value in a range.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

To copy cell contents, you can select the cell and then press the ____ keys.

To paste copied cell contents, you can press the ____ keys.

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

To start a new line in a cell, press the ____ keys.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Which of the following calculations multiplies 23 by 0.01?

Which of the following happens when you enter the formula =G15 into a cell?

Which of the following is the path to the Comma Style button?

Which of the following is the path to the Conditional Formatting button?

Which of the following is the path to the Copy and Paste buttons?

Which of the following is the path to the Spelling button?

Which of the following is the path to the Sum arrow?

Which of the following Option buttons gives options for filling cells following a fill operation?

You can click the ____ button to undo an automatic correction.

You can open the Format Cells dialog box by pressing the ____ keys.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

You should ____ a function name in the Formula AutoComplete list to select the function.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.

Cell references in a formula are called ____.

Charts can either be embedded in a worksheet or placed in a separate ____.

Error messages begin with the ____ symbol.

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

In a clustered column chart, the names of each column are part of the ____ series.

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory.

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

The path to the Format Painter button is ____.

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____.

Using the mouse to move or copy cells is called ____.

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

When working with a large worksheet, you can split the window into ____ panes.

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Which comparison operator means "not equal to"?

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

Which of the following formulas contains an absolute cell reference?

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Which of the following is not a valid format symbol?

Which of the following is the path to the Goal Seek button?

Which of the following is the path to the Increase or Decrease Indent button?

Which of the following is the path to the Insert Cells arrow?

Which of the following is the path to the Zoom button?

Which of the following patterns extends the fill series to 575, 550, 525?

You can press the ____ keys to open the Format Cells dialog box.

You should use a ____ chart to compare values side by side, broken down by category.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

____ refers to cells not wide enough to display the entire entry.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

____ text often provides a strong visual appeal.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.