Excel Ch. 1
enter
Clicking the _______ box completes an entry.
100
Excel remembers the last ________ actions you have completed.
RIGHT ARROW
Pressing the ________ key to complete an entry activates the adjacent cell to the right.
CTRL+HOME
Pressing the ________ keyboard shortcut key(s) selects the cell A1.
understand what is required
The first step in creating an effective worksheet is the make sure you ________.
requirements
The person or persons requesting the worksheet should supply their requirements in a ________ document.
ESC
To cancel an entire entry before entering it into the cell, press the ________ key.
apostrophe
To enter a number as a text, precede it with a(n) ________.
6E15
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 you can type ________.
cell
To enter data in a cell, you must first select or activate the ________.
click
To remove an embedded chart, you should ________ it and press the DELETE key.
colon
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________.
format
You ________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
CTRL+B
You can apply the Bold font style by pressing the ________ keyboard shortcut keys.
range
A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
relative
A ________ reference is an adjusted cell reference in a copied and pasted formula.
embedded
A(n) ________ chart is drawn on the same worksheets as the data.
worksheet
An Excel ________ allows data easily to be summarized and charted.
left-aligned
By default, text is ________ in a cell.
merging
Combining two or more selected cells is called ________ cells.
11
How many chart types does Excel offer?
0 1 2 3 4 5 6 7 8 9 . $ % E e + - ( ) , /
In Excel, a number can contain the characters ________.
two
In general, use no more than ________ font types in a worksheet.
legend
In the accompanying figure, the ________ identifies the colors assigned to each bar in the chart on a worksheet.
Auto Fill Options
The ________ allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Calculate
The ________ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected number in the worksheet.
Undo
The ________ button is located on the Quick Access Toolbar.
AutoCorrect
The ________ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
insertion point
The ________ is a blinking vertical line that indicates where the next typed character will appear.
fill handle
The ________ is the small black square located in the lower right corner of the heavy border around the active cell.
destination area (or paste area)
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________.
Displays cell contents with two decimal places that align vertically.
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators.
What effect does the Comma Style format have on the selected cells?
(Home tab | Styles group)
What is the Ribbon path to the Cell Styles button?
F2
Which key is an alternative to double-clicking the cell to edit it?
HOME
Which key moves the insertion point to the beginning of data in a cell?
END
Which key moves the insertion point to the end of data in a cell?
INSERT
Which key toggles between Insert mode and Overtype mode?
Text
________ is/are used to add worksheet, column, and row titles on a worksheet.
Standard
________ properties are associated with all Microsoft Office documents and include author, title, and subject.