For each question, click on the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.
Choose the BEST answer.
1. On an Excel sheet the active cell is indicated by ____.
a. a dark wide border
b. a dotted border
c. a blinking border
d. none of the above
2. To select a column the easiest method is to _____.
a. double-click any cell in the column
b. drag from the top cell in the column to the last cell in the column
c. click the column heading
d. click the column label
3. If you _____, the cell accepts your typing as its contents but the focus stays in the cell.
a. press ENTER
b. click the check mark button
c. press TAB
d. press INSERT
4. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
a. B1-G10
b. B1.G10
c. B1;G10
d. B1:G10
5. The view that puts a blue line around each page that would be printed is the _____.
a. Print Preview
b. Normal
c. Page Break Preview
d. Page Layout View
6. To select several cells or ranges that are not touching each other, you would _____ while selecting.
a. hold down the CTRL key
b. hold down the SHIFT key
c. hold down the ALT key
d. hold down CTRL + SHIFT
7. To create a chart which ribbon tab?
a. Home
b. Insert
c. Data
d. Chart Tools
8. Using the AutoSum button will place in the selected cell _____.
a. the sum of values in the cell's column
b. nothing until you select a range of cells
c. the sum of the cell's row unless you change the range
d. a formula which will add values in the range that Excel guesses you want to add
9. AutoCalculate will show the sum of selected cells on the Status bar if you ____ .
a. previously right clicked the Status bar and selected SUM
b. click the AutoCalculate button on the Home tab
c. use the key combo CTRL + $
d. double-click the selection
e. none of the above
10. A certain spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button, _____.
a. nothing will print because some cells with data have been omitted
b. only the cells with gray background will print
c. the whole sheet will print
d. only the cells with white background will print.