CAP131 Test 1 Review

Edit Answers
123456789101112131415161718192021222324252627
Across
  1. 2. What command moves data away from the cell's edge for better readability of values and labels? from ch 4
  2. 4. Which cell alignment is assigned to most values by default? from ch 2
  3. 5. Which function automatically totals a column or row of values? from ch 2
  4. 6. Which command allows a long label to appear on multiple lines in the cell? from ch 4 2 words
  5. 9. What is unique for each cell on a worksheet? from ch 1 2 words
  6. 13. After a table is created, what arrows appear with the header row labels? from ch 3
  7. 14. Which command reverses the last action performed in the worksheet? from ch 1
  8. 15. What key when pressed starts Edit mode? from ch 1
  9. 16. Which group on the Page Layout tab includes commands to print the row and column headings? from ch 3 2 words
  10. 17. Where does data appear as it is keyed? from ch 2 2 words
  11. 21. What term describes the Header/Footer Tools Design tab? from ch 3
  12. 23. Which button is used to move the insertion point to the next cell in a left-to-right sequence? from ch 1
  13. 24. How does Excel identify an entry that begins with a letter? from ch 2
  14. 25. Which Excel feature changes "hte" to "the" automatically? from ch 3
  15. 26. What term describes a built-in formula? from ch 2
  16. 27. What term describes rows of data with a header row? from ch 3
Down
  1. 1. What dialog box includes an option to print a selection? from ch 3
  2. 3. In Excel, what identifies a formula? from ch 2
  3. 7. Which key can be used to move the current view down one screen? from ch 1 2 words
  4. 8. How are font sizes specified? from ch 2
  5. 10. What does the thick white cross pointer shape represent? from ch 2 2 words
  6. 11. Which command allows you to reverse an Undo command? from ch 1
  7. 12. Which alignment choice spreads the data across the width of the cell? from ch 4
  8. 15. Which button on the View tab freezes rows in a worksheet? from ch 4 2 words
  9. 18. Which option in the Find/Replace dialog box makes a search task case-sensitive? from ch 3 2 words
  10. 19. Which mathematical operator is represented by an asterisk (*)? from ch 2
  11. 20. Which group includes the Conditional Formatting button? from ch 4
  12. 22. Which command sets the angle of a label in the cell? from ch 4
  13. 25. The formula bar displays the contents of which cell? from ch 1