Multiple Choice Questions

Pressing the ____ keyboard shortcut key(s) selects cell A1.
  • exploded
  • False
  • CTRL+HOME
  • worksheet
A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.
  • True
  • False
The person or persons requesting the worksheet should supply their requirements in a ____ document
  • colon (:)
  • destination area
  • Auto Fill Options
  • requirements
Which of the following keys toggles between Insert mode and Overtype mode?
  • INSERT
  • enter
  • paste
  • END
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).
  • True
  • False
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart
  • False
  • CTRL+B
  • exploded
  • relative
To enter data in a cell, you must first select the
  • False
  • Cell
  • True
  • Undo
The opposite of merging cells is splitting a merged cell.
  • True
  • False
You use ____ to view an XPS file.
  • XPS Viewer
  • colon (:)
  • worksheet
  • CTRL+A
What effect does the Accounting Number Format have on the selected cells
  • Displays cell contents with two decimal places and commas as the thousands separators
  • understand what is required
  • INSERT
  • Displays cell contents with two decimal places that align vertically
The ____ button allows you to erase recent cell entries.
  • Cell
  • True
  • Undo
  • Auto Fill Options
Combining two or more selected cells into one cell is called ____ cells.
  • END
  • format
  • merging
  • CTRL+B
You should press the SPACEBAR to clear a cell
  • True
  • False
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand
  • format
  • Auto Correct
  • False
  • CTRL+B
The date you change a file is an example of a(n) ____ property
  • AutoCalculate
  • understand what is required
  • automatically updated
  • Auto Fill Options
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.
  • True
  • False
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.
  • True
  • False
is/are used to place worksheet, column, and row titles on a worksheet.
  • True
  • text
  • paste
  • HOME
Excel remembers the last ____ actions you have completed.
  • True
  • Undo
  • 100
  • ESC
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
  • True
  • False
Which of the following keys moves the insertion point to the beginning of data in a cell
  • INSERT
  • True
  • CTRL+HOME
  • HOME
Excel can display characters in only three font colors: black, red, and blue.
  • True
  • False
The range of cells receiving copied content is called the ____ area
  • True
  • False
  • paste
  • destination area
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column
  • True
  • False
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.
  • AutoCalculate
  • format
  • Auto Correct
  • relative
The range of cells receiving the content of copied cells is called the
  • right arrow
  • automatically updated
  • destination area
  • CTRL+HOME
A single point is about 1/32 of one inch in height
  • True
  • False
Press ____ to select the entire worksheet
  • True
  • Cell
  • False
  • CTRL+A
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
  • Auto Correct
  • colon (:)
  • format
  • AutoCalculate
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
  • destination area
  • merging
  • right arrow
  • INSERT
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key
  • True
  • False
  • ESC
  • Cell
Clicking the ____ box completes an entry.
  • INSERT
  • paste
  • enter
  • END
You can enter the correct range in a function by typing the beginning and ending cell references separated by a
  • CTRL+B
  • colon (:)
  • exploded
  • AutoCalculate
0 h : 0 m : 1 s

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