1. All equations in Excel begin with the equals sign =
a. True
b. False
Tip: Beginning Excel, page 56

2. Excel won’t calculate a formula until you leave the cell.
a. True
b. False
Tip: Beginning Excel, page 56

3. Which of the following is available when you right-click a selected row?

(Select all correct answers.)
a. Insert
b. Delete
c. Clear Contents
d. Hide
Tip: Beginning Excel, page 65

4. Cell Styles format which of the following? (Select all correct answers.)
a. Text
b. Cell color
c. Cell border
Tip: Beginning Excel, page 67

5. Themes can be applied to which of the following?

(Select all correct answers.)
a. Individual cells
b. Groups of cells
c. The entire spreadsheet
Tip: Beginning Excel, page 68

6. What is the default name for an unsaved Excel spreadsheet?
a. Book1
b. Document 1
c. Excel 1
d. Spreadsheet 1
Tip: Beginning Excel, page 70


7. What would you use the Save As command for?

(Select all correct answers.)
a. Save the file in the 97-2003 format
b. Save the file with a different file name
Tip: Beginning Excel, page 71, 73

8. Which one of these formulas is written correctly?

(Select all correct answers.)
a. =B3+B6
b. =B3-B6
c. B3+B6
d. =SUM(B3:B6)
Tip: Beginning Excel, page 56, 57


9. Which of the following is true?

(Select all correct answers.)
a. Font commands are on the Home Ribbon
b. Themes are on the Page Layout Ribbon
Tip: Beginning Excel, page 68

10. You can create a custom Theme.
a. True
b. False
Tip: Beginning Excel, page 69

 

Test Yourself