Excel Intro:

Title: Jan's Illustrated Computer Literacy 101

For each question, click on Radio Button 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 press _____, the cell accepts your typing as its contents but the focus stays in the cell.



 c. TAB


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. Split 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 with the Chart Wizard, you would use which button?

  a. Drawing button

  b. Chart Wizard button

  c. hyperlink

  d. Format painter button

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 Excel guesses you want to add

9. AutoCalculate will quickly add selected cells if you _____ .

  a. right-click on the status bar and select SUM

  b. click the AutoCalculate button on the toolbar

  c. use the key combo CTRL + $

 d. double-click the selection

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.