Excel 101

1. The intersection of a row and a column is called a ________.

• a. cell

• b. chart

• c. worksheet

• d. sum

2. Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• a. It should use quotation marks instead of parentheses

• b. It should have an equal sign (=) at the beginning

• c. There is nothing wrong with the formula

• d. It should use the COUNT function instead

3. True or False: You can view a formula by double-clicking the cell that contains the formula.

• a. True

• b. False

4. Which of the following is an absolute cell reference?

• a. #A2

• b. $A$2

• c. A:2

• d. A2

6. What value would Excel return for this formula? =(82-32)/5+8*2

• a. 36

• b. 26

• c. 7.69

• d. 91.6

6. How do you delete a column?

• a. Select the column heading you want to delete and select the Delete Row button on the standard toolbar

• b. Select the column heading you want to delete and select Insert Delete from the menu

• c. Select the row heading you want to delete and select Edit > Delete from the menu

• d. Right click the column heading you want to delete and select delete from the shortcut menu

Which of the following is not a valid data type in excel?

• a. Number

• b. Character

• c. Label

• d. Date/Time

How do you select an entire column?

• a. Select Edit > Select > Column from the menu

• b. Click the column heading letter

• c. Hold down the shift key as you click anywhere in the column

• d. Hold down the Ctrl key as you click anywhere in the column

Right clicking something in Excel:

• a. Deletes the object

• b. Nothing the right mouse button is there for left handed people

• c. Opens a shortcut menu listing everything you can do to the object

• d. Selects the object

You can use the drag and drop method to

• a. Copy cell contents

• b. Move cell contents

• c. Add cell contents

• d. Both ‘a’ and ‘b’