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