Module #3
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns. Answers: True False
False
You can click the Logical button (FORMULAS tab | Function Library group) and click IFERROR to insert the IF function. _________________________ Answers: True False
False
You can select nonadjacent ranges using the SHIFT key. Answers: True False
False
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. Answers: True False
True
You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. _________________________ Answers: True False
True
Modified Multiple Choice 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: a. 15 b. 90 c. 145 d. 180
a. 15 b. 90
Modified Multiple Choice If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series? Answers: a. Monday b. Wednesday c. Thursday d. Saturday
a. Monday c. Thursday d. Saturday
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. Answers: a. NOW b. CURRENT c. DATETIME d. SYSDATE
a. NOW
Modified Multiple Choice Which of the following are formatting symbols? Answers: a. Percent sign (%) b. Pound sign (#) c. Dollar sign ($) d. Comma (,)
a. Percent sign (%) c. Dollar sign ($) d. Comma (,)
Modified Multiple Choice The arguments in an IF function are ____. Answers: a. logical_test b. value_if_false c. value_if_true_false d. value_if_true
a. logical_test b. value_if_false d. value_if_true
Which of the following is not a valid format symbol? Answers: a. percent sign (%) b. dollar sign ($) c. semi-colon (;) d. comma (,)
c. semi-colon (;)
To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____. Answers: a. option button b. button c. Dialog Box Launcher d. check box
c. Dialog Box Launcher
_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges. Answers: a. Click b. Press or long-press c. Double-click d. Triple-click
c. Double-click
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: a. File b. Ribbon c. Folder d. Clipboard
d. Clipboard
The ____ function is useful when you want to assign a value to a cell based on a logical test. Answers: a. OR b. NOW c. AND d. IF
d. IF
Charts can either be embedded in a worksheet or placed in a separate ____. Answers: a. dialog box b. worksheet c. range d. chart sheet
d. chart sheet
When working with a large worksheet, you can split the window into ____ panes. Answers: a. three or four b. four or five c. two or six d. two or four
d. two or four
_____ refers to cells not wide enough to display the entire entry. Answers: a. +++++ b. &&&&& c. $$$$$ d. #####
d. #####
Cell references in a formula are called ____. Answers: a. numbers b. comments c. assumptions d. content
c. assumptions
Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window. _________________________ Answers: True False
False
Panes created using the vertical split bar scroll together horizontally. ________________________ Answers: True False
False
A cell reference with only one dollar sign before either the column or the row is called an absolute reference. Answers: True False
False
Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees. Answers: True False
False
Excel includes four types of sparkline charts: line, column, win/loss, and stock. Answers: True False
False
The path to the Logical button is (FORMULAS tab | Function Library group). Answers: True False
True
A date stamp shows the date a workbook, report, or other document was created or the time period it represents. Answers: True False
Selected Answer: 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
Selected Answer: True
You can press the ____ keys to open the Format Cells dialog box. Answers: a. CTRL+1 b. CTRL+2 c. CTRL+3 d. CTRL+4
Selected Answer: a. CTRL+1
Which of the following patterns extends the fill series to 525, 475, 425? Answers: a. 625, 575 b. 560, 580 c. 650, 600 d. 500, 475
Selected Answer: a. 625, 575
Which of the following formulas contains an absolute cell reference? Answers: a. =B4 b. =$B$4 c. =B$4 d. =$B4
Selected Answer: b. =$B$4
Which of the following is the path to the Zoom button? Answers: a. (HOME tab | Zoom group) b. (ZOOM tab | View group) c. (VIEW tab | Zoom group) d. (INSERT tab | Zoom group)
Selected Answer: c. (VIEW tab | Zoom group)
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. Answers: a. included b. duplicate c. nested d. other
Selected Answer: c. nested
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. Answers: a. sparkle b. section c. sparkline d. special
Selected Answer: c. sparkline
You use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example. Answers: a. Left and Right b. Center c. Alignment d. Position
Selected Answer: c. Alignment
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
True
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. Answers: True False
True
The <= comparison operator means less than or equal to. Answers: True False
True
The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it. Answers: a. two b. three c. four d. five
a. two
Error messages begin with the _____ symbol. Answers: a. # b. ! c. = d. ?
a. #
You should use a ____ chart to compare values side by side, broken down by category. Answers: a. Line b. Clustered Column c. Bar d. Column
b. Clustered Column
Modified Multiple Choice Following the insertion of a row, the Insert Options button lets you select from which of the following options? Answers: a. Undo Formatting b. Format Same As Below c. Format Same As Above d. Clear Formatting
b. Format Same As Below c. Format Same As Above d. Clear Formatting
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? Answers: a. Quarter 1 b. Qtr2 c. Quarter4 d. Qtr1
b. Qtr2
Which of the following is an extension of the fill pattern Sunday, Tuesday? Answers: a. Wednesday, Thursday, Saturday b. Thursday, Saturday, Monday c. Saturday, Sunday, Monday d. Monday, Wednesday, Friday
b. Thursday, Saturday, Monday
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. Answers: a. calculated b. constant c. consistent d. logical
b. constant
Using the mouse to move or copy cells is called ____. Answers: a. drop and drag b. drag and drop c. drag and copy d. drag and paste
b. drag and drop
_____ text often provides a strong visual appeal. Answers: a. Tiny b. Rotated c. Launched d. Logical
b. Rotated
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: a. #DIV/0! b. #N/A c. #REF! d. #NULL!
c. #REF!
The path to the Format Painter button is ____. Answers: a. (HOME tab | Font group) b. (HOME tab | Number group) c. (HOME tab | Clipboard group) d. (HOME tab | Painting group)
c. (HOME tab | Clipboard group)
Which of the following Auto Fill Options menu options is the same as the Fill Series option? Answers: a. Fill Formatting Only b. Fill Without Formatting c. Fill Months d. Copy Cells
c. Fill Months
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. Answers: a. Option b. Function c. Goal d. Formula
c. Goal