MCQ Questions
Q.1.
Pressing the ____ keyboard shortcut key(s) selects cell A1.
  • 0%
    exploded
  • 0%
    False
  • 0%
    CTRL+HOME
  • 0%
    worksheet
Q.2.
A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.
  • 0%
    True
  • 0%
    False
Q.3.
The person or persons requesting the worksheet should supply their requirements in a ____ document
  • 0%
    colon (:)
  • 0%
    destination area
  • 0%
    Auto Fill Options
  • 0%
    requirements
Q.4.
Which of the following keys toggles between Insert mode and Overtype mode?
  • 0%
    INSERT
  • 0%
    enter
  • 0%
    paste
  • 0%
    END
Q.5.
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
  • 0%
    True
  • 0%
    False
Q.6.
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart
  • 0%
    False
  • 0%
    CTRL+B
  • 0%
    exploded
  • 0%
    relative
Q.7.
To enter data in a cell, you must first select the
  • 0%
    False
  • 0%
    Cell
  • 0%
    True
  • 0%
    Undo
Q.8.
The opposite of merging cells is splitting a merged cell.
  • 0%
    True
  • 0%
    False
Q.9.
You use ____ to view an XPS file.
  • 0%
    XPS Viewer
  • 0%
    colon (:)
  • 0%
    worksheet
  • 0%
    CTRL+A
Q.10.
What effect does the Accounting Number Format have on the selected cells
  • 0%
    Displays cell contents with two decimal places and commas as the thousands separators
  • 0%
    understand what is required
  • 0%
    INSERT
  • 0%
    Displays cell contents with two decimal places that align vertically
Q.11.
The ____ button allows you to erase recent cell entries.
  • 0%
    Cell
  • 0%
    True
  • 0%
    Undo
  • 0%
    Auto Fill Options
Q.12.
Combining two or more selected cells into one cell is called ____ cells.
  • 0%
    END
  • 0%
    format
  • 0%
    merging
  • 0%
    CTRL+B
Q.13.
You should press the SPACEBAR to clear a cell
  • 0%
    True
  • 0%
    False
Q.14.
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand
  • 0%
    format
  • 0%
    Auto Correct
  • 0%
    False
  • 0%
    CTRL+B
Q.15.
The date you change a file is an example of a(n) ____ property
  • 0%
    AutoCalculate
  • 0%
    understand what is required
  • 0%
    automatically updated
  • 0%
    Auto Fill Options
Q.16.
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
  • 0%
    True
  • 0%
    False
Q.17.
To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.
  • 0%
    True
  • 0%
    False
Q.18.
is/are used to place worksheet, column, and row titles on a worksheet.
  • 0%
    True
  • 0%
    text
  • 0%
    paste
  • 0%
    HOME
Q.19.
Excel remembers the last ____ actions you have completed.
  • 0%
    True
  • 0%
    Undo
  • 0%
    100
  • 0%
    ESC
Q.20.
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
  • 0%
    True
  • 0%
    False
Q.21.
Which of the following keys moves the insertion point to the beginning of data in a cell
  • 0%
    INSERT
  • 0%
    True
  • 0%
    CTRL+HOME
  • 0%
    HOME
Q.22.
Excel can display characters in only three font colors: black, red, and blue.
  • 0%
    True
  • 0%
    False
Q.23.
The range of cells receiving copied content is called the ____ area
  • 0%
    True
  • 0%
    False
  • 0%
    paste
  • 0%
    destination area
Q.24.
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column
  • 0%
    True
  • 0%
    False
Q.25.
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
  • 0%
    AutoCalculate
  • 0%
    format
  • 0%
    Auto Correct
  • 0%
    relative
Q.26.
The range of cells receiving the content of copied cells is called the
  • 0%
    right arrow
  • 0%
    automatically updated
  • 0%
    destination area
  • 0%
    CTRL+HOME
Q.27.
A single point is about 1/32 of one inch in height
  • 0%
    True
  • 0%
    False
Q.28.
Press ____ to select the entire worksheet
  • 0%
    True
  • 0%
    Cell
  • 0%
    False
  • 0%
    CTRL+A
Q.29.
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
  • 0%
    Auto Correct
  • 0%
    colon (:)
  • 0%
    format
  • 0%
    AutoCalculate
Q.30.
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
  • 0%
    destination area
  • 0%
    merging
  • 0%
    right arrow
  • 0%
    INSERT
Q.31.
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key
  • 0%
    True
  • 0%
    False
  • 0%
    ESC
  • 0%
    Cell
Q.32.
Clicking the ____ box completes an entry.
  • 0%
    INSERT
  • 0%
    paste
  • 0%
    enter
  • 0%
    END
Q.33.
You can enter the correct range in a function by typing the beginning and ending cell references separated by a
  • 0%
    CTRL+B
  • 0%
    colon (:)
  • 0%
    exploded
  • 0%
    AutoCalculate