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