CIS 146- Excel

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.

#REF!

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

(VIEW tab | Zoom group)

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

26

Which of the following formulas contains an absolute cell reference?

=$B$4

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

CTRL+1

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

CTRL+B

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

Clipboard

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

False

Excel can display characters in only three font colors: black, red, and blue.

False

Live preview is available on a touch screen.

False

The Accounting number format assigns a floating dollar sign.

False

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

False

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

Goal

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

IF

The _____ function determines the lowest number in a range.

MIN

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.

Orientation

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.

Orientation

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

Print Selection

A character with a point size of 10 is about 10/72 of one inch height.

True

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

True

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

True

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

True

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

True

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

True

The group of adjacent cells beginning with B4 and ending with B8, written as B4: B8, is called a(n) range.

True

The most common error when entering a formula is to reference the wrong cell in the formula.

True

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

True

With Excel in Edit mode, you can edit cell contents directly in the cell.

True

You can press the CTRL+ACCENT+MARK(') keys to display the formulas in a worksheet.

True

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

True

You use ____ to view an XPS file.

XPS Viewer

A _____ is a pre-written formula that is built into Excel.

function

Combining two or more selected cells into one cell is called ____ cells.

merging

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

nested

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

right parenthesis

_____ text often provides a strong visual appeal.

rotated

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

theme

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

two