Test Yourself 1. You can copy and paste a formula. a. True b. False Tip: Beginning Excel, page 84 2. You can rename sheets in an Excel workbook. a. True b. False Tip: Beginning Excel, page 85 3. Changing the decimal place using the Decrease Decimal command does NOT change the number, only how it is formatted. a. True b. False Tip: Beginning Excel, page. 87 4. Where is the AutoSum command? (Select all correct answers.) a. Formulas-> Function Library-> AutoSum b. Home->Editing-> AutoSum Tip: Beginning Excel, page 57, 89

5. The Sum and Average commands suggest a range of cells that may or may not be what you want. a. True b. False Tip: Beginning Excel, page 91 6. Which of the following commands are in the AutoSum menu? (Select all correct answers.) a. Sum b. Average c. Count Numbers d. Max e. Min Tip: Beginning Excel, page 90 7. Which of the following is true? (Select all correct answers.) a. COUNTA counts all cells with text or numbers b. COUNT counts all cells with numbers c. Neither COUNT or COUNTA counts empty cells Tip: Beginning Excel, page 95 8. A logical function asks a question, then determines if your data matches. a. True b. False Tip: Beginning Excel, page 97 9. Which is a logical function? a. COUNTA b. Average c. IF d. Sum Tip: Beginning Excel, page 97 10. Which of the following is a way to enter a formula? (Select all correct answers.) a. Type the formula b. Insert the formula using the Formula Ribbon c. Copy and paste the formula Tip: Beginning Excel, page 84, 89