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
