Excel Module 1
Which of the following is the Ribbon path to the Cell Styles button?
(HOME tab | Styles group)
Excel remembers the last ____ actions you have completed.
100
How many chart types does Excel offer?
15
The____area on status bar includes 6 commands & the result of the associated calculation on the right side of the menu.
Autocalculate
The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Autocorrect
To enter data in a cell, you must first select the ____.
Cell
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
Colon ( : )
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
Exploded
2use AutoCalculate area select range containing #s for calculation &press& hold AutoCalculate area 2display Customize St
False
A thin red border indicates the active cell.
False
Excel can display characters in only three font colors: black, red, and blue.
False
Given range contains data that determines size of slices in a corresponding pie chart; they R called category names.
False
Worksheet titles and subtitles should be as wordy as possible.
False
You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).
False
You should press the SPACEBAR to clear a cell.
False
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Format
Combining two or more selected cells into one cell is called ____ cells.
Merging
A ____ reference is an adjusted cell reference in a copied and pasted formula.
Relative
Pressing the ____ key to complete an entry activates the adjacent cell to the right.
Right arrow
____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
2 add pie chart, 1st select data 2B charted & then tap/click the Insert Pie or Doughnut Chart (INSERT tab | Charts group
True
Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.
True
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.
True
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cell.
True
The AutoCorrect feature can automatically capitalize the first letter in the names of days.
True
When text is longer than width of column, Excel displays overflow characters in adjacent cells 2right bc contain no data
True
With Excel in Edit mode, you can edit cell contents directly in the cell.
True
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
True
The ____ button allows you to erase recent cell entries.
Undo
An Excel ____ allows data to be summarized and charted easily.
Worksheet