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 file from Sheet1 to Checkbook. 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 AutoSum and AutoSum: 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 Number d. Max e. Min Tip: Beginning Excel, page 92 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 logic function asks a question, then determines if your data matches. a. True b. False Tip: Beginning Excel, page 97 9. Which is a logic function? a. COUNTA b. Average c. IF d. Sum Tip: Beginning Excel, page 98 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