Excel Ch. 3 Test

False

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

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. Answers: True False

assumptions

Cell references in a formula are called ____. Answers: assumptions comments numbers content

chart sheet

Charts can either be embedded in a worksheet or placed in a separate ____. Answers: worksheet dialog box chart sheet range

False

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window. Answers: True False

Format Same as Above, Format Same As Below, and Clear Formatting

Following the insertion of a row, the Insert Options button lets you select from which of the following options? Answers: Format Same As Above Undo Formatting Format Same As Below Clear Formatting

#REF!

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. Answers: #NULL! #DIV/0! #N/A #REF!

data

In a clustered column chart, the names of each column are part of the ____ series. Answers: category data label legend

drag and drop

Using the mouse to move or copy cells is called ____. Answers: drop and drag drag and drop drag and copy drag and paste

True

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item. Answers: True False

constant

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. Answers: logical constant consistent calculated

<>

Which comparison operator means "not equal to"? Answers: <= > < <>

Qtr2

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? Answers: Quarter 1 Qtr1 Qtr2 Quarter4

Thursday, Saturday, Monday

Which of the following is an extension of the fill pattern Sunday, Tuesday? Answers: Wednesday, Thursday, Saturday Thursday, Saturday, Monday Saturday, Sunday, Monday Monday, Wednesday, Friday

(DATA tab | Data Tools group)

Which of the following is the path to the Goal Seek button? Answers: (INSERT tab | Goal Seek group) (HOME tab | Data Tools group) (DATA tab | Data Tools group) (ANALYSES tab | Goal Seeking group)

(HOME tab I Alignment group)

Which of the following is the path to the Increase or Decrease Indent button? Answers: (HOME tab | Clipboard group) (HOME tab | Editing group) (HOME tab | Alignment group) (HOME tab | Number group)

(VIEW tab | Zoom group)

Which of the following is the path to the Zoom button? Answers: (VIEW tab | Zoom group) (HOME tab | Zoom group) (INSERT tab | Zoom group) (ZOOM tab | View group)

625, 600

Which of the following patterns extends the fill series to 575, 550, 525? Answers: 650, 600 625, 600 560, 580 500, 475

True

With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet. Answers: True False

False

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function. Answers: True False

CTRL+1

You can press the ____ keys to open the Format Cells dialog box. Answers: CTRL+1 CTRL+2 CTRL+3 CTRL+4

False

You can replace a formula with its function so it remains constant. Answers: True False

Clustered Column

You should use a ____ chart to compare values side by side, broken down by category. Answers: Column Bar Line Clustered Column

Goal

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

Rotated

____ text often provides a strong visual appeal. Answers: Launched Tiny Logical Rotated

Double-click or double-tap

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges. Answers: Click or tap Press or long-press Double-click or double-tap Triple-click or tap

#

Error messages begin with the ____ symbol. Answers: ? = ! #

False

Excel includes four types of sparkline charts: line, column, win/loss, and stock. Answers: True False

is the result of moving the mouse pointer to the boundary between column heading A and column heading B

In the accompanying figure, the split double arrow mouse pointer ____. Answers: indicates a hidden column allows text to be entered at that location is the result of moving the mouse pointer to the boundary between column heading A and column heading B indicates the proposed width of column A

True

Many ribbon commands, galleries, and shortcut keys function as toggles or switches. Answers: True False

15 and 90

Text in a cell can be rotated counterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number? Answers: 15 90 145 180

True

The <= comparison operator means less than or equal to. Answers: True False

Clipboard

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

False

The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it. Answers: True False

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. Answers: True False

logical_test, value_if_true, and value_if_false

The arguments in an IF function are ____. Answers: logical_test value_if_true value_if_true_false value_if_false

True

The incorrect use of copying, deleting, inserting, and moving ranges of cells has the potential to render a worksheet useless. Answers: True False

(HOME tab | Clipboard group)

The path to the Format Painter button is ____. Answers: (HOME tab | Number group) (HOME tab | Clipboard group) (HOME tab | Painting group) (HOME tab | Font group)

False

The underline format underlines the entire cell, not just the characters in the cell. Answers: True False

Dialog Box Launcher

To open the Format Cells dialog box with the Alignment sheet active, tap or click the Alignment Settings ____. Answers: button check box option button Dialog Box Launcher