Question 1
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
Question 2
How many chart types does Excel offer?
Question 3
In Excel, a number can contain the characters _____.
Question 4
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or
you can type _____.
Question 5
What effect does the Comma Style format have on the selected cells?
Question 6
To enter data in a cell, you must first select or activate the _____.
Question 7
Pressing the _____ key to complete an entry activates the adjacent cell to the right.
Question 8
Clicking the _____ box completes an entry.
Question 9
By default, text is _____ in a cell.
Question 10
The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
Question 11
nar005-1.jpg
In the accompanying figure, the _____ identifies the colors assigned to each bar in the chart on a worksheet.
Question 12
To cancel an entire entry before entering it into the cell, press the _____ key.
Question 13
nar004-1.jpg
A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.
Question 14
What effect does the Accounting Number Format have on the selected cells?
Question 15
The first step in creating an effective worksheet is to make sure you _____.
Question 16
Which of the following calculations multiplies 23 by 0.01?
Question 17
Which of the following happens when you enter the formula =G15 into a cell?
Question 18
To start a new line in a cell, press the _____ keys.
Question 19
To copy cell contents, you can select the cell and then press the _____ keys.
Question 20
When you enter a two-digit year that is less than 30, Excel changes the year to _____.