Multiple Choice Questions

Which of the following formulas contains an absolute cell reference?
  • =$B$4
  • Qtr2
  • Thursday, Saturday, Monday
  • ​#####
Excel includes four types of sparkline charts: line, column, win/loss, and stock.
  • True
  • False
Using the mouse to move or copy cells is called ____.
  • assumptions
  • rotated
  • drag and drop
  • Double-click
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
  • constant
  • sparkline
  • ENTER
  • Nested
You should use a ____ chart to compare values side by side, broken down by category.
  • two or four
  • Thursday, Saturday, Monday
  • Clustered Column
  • CTRL+1
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
  • Nested
  • ​Alignment
  • constant
  • False
You can click the Logical button (FORMULAS tab | Function Library group) and click IFERROR to insert the IF function. _________________________
  • False
  • True
  • ENTER
  • CTRL+1
_____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.​
  • Double-click
  • ​Alignment
  • sparkline
  • drag and drop
You use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.​
  • Double-click
  • sparkline
  • constant
  • ​Alignment
_____ text often provides a strong visual appeal.​
  • ​#####
  • Nested
  • rotated
  • drag and drop
The <= comparison operator means less than or equal to
  • True
  • False
Which of the following is an extension of the fill pattern Sunday, Tuesday?
  • --dollar sign ($)--comma (,)--percent sign (%)
  • two or four
  • Thursday, Saturday, Monday
  • =$B$4
A cell reference with only one dollar sign before either the column or the row is called an absolute reference.
  • True
  • False
You can replace a formula with its function so it remains constant.​__________
  • True
  • ​Alignment
  • False
  • =$B$4
Error messages begin with the _____ symbol.​
  • ​#
  • assumptions
  • False
  • ​#####
Panes created using the vertical split bar scroll together horizontally. ________________________
  • sparkline
  • Nested
  • constant
  • False
You can press the ____ keys to open the Format Cells dialog box.
  • True
  • False
  • CTRL+1
  • ​#####
Following the insertion of a row, the Insert Options button lets you select from which of the following options?
  • Fill Formatting Only
  • Clear FormattingCorrectc. Format Same As AboveCorrectd. Format Same As Below
  • ​Alignment
  • sparkline
The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
  • sparkline
  • Clear FormattingCorrectc. Format Same As AboveCorrectd. Format Same As Below
  • Fill Formatting Only
  • constant
Which of the following are formatting symbols?
  • Thursday, Saturday, Monday
  • =$B$4
  • Qtr2
  • --dollar sign ($)--comma (,)--percent sign (%)
The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it.
  • True
  • False
_____ refers to cells not wide enough to display the entire entry.​
  • CTRL+1
  • ​#####
  • rotated
  • =$B$4
The path to the Logical button is (FORMULAS tab | Function Library group).
  • True
  • False
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0