CAP131 Test 2 Review

Edit Answers
12345678910111213141516171819
Across
  1. 4. Which function tallies all cells in a range whether the cell has a value or a label? from ch 6FALSE
  2. 5. What term describes a set of formatting specifications for labels or values? from ch 7 2 words
  3. 11. What dialog box includes the Margins tab? from ch 5 2 words
  4. 12. What group on the Home tab includes the Hide Sheet command? from ch 8FALSE
  5. 13. If a function has more than one argument, what separates the arguments? from ch 6FALSE
  6. 15. What is the default cell style for new data keyed in a new workbook? from ch 7FALSE
  7. 16. What button on the Page Layout command tab allows you to set landscape orientation for a worksheet? from ch 5 2 words
  8. 17. Which function category includes INT and ROUND? from ch 8 3 words
  9. 18. What term describes an image that fills the entire worksheet but does not print? from ch 5FALSE
Down
  1. 1. Which function removes the decimal part of a number? from ch 6FALSE
  2. 2. What Save As type should you choose to create a workbook that can be viewed on the Internet? from ch 5 2 words
  3. 3. Which arguments in a financial function indicates the interest for a period? from ch 7FALSE
  4. 5. What feature finds elements in a worksheet that may not work properly in a different format? from ch 8 2 words
  5. 6. What term describes a worksheet that prints wider than it is tall? from ch 5FALSE
  6. 7. Which cell style allows for negative values to be enclosed in parentheses? from ch 7FALSE
  7. 8. What is not included in a CSV file? from ch 8FALSE
  8. 9. Which command tab includes a button to insert a page break? from ch 7 2 words
  9. 10. Which function converts a value to a specified digit to the left or right of the decimal point? from ch 8FALSE
  10. 14. What term describes a built-in Excel formula? from ch 6FALSE
  11. 19. When a formula is copied, which type of cell reference adjusts to the new location? from ch 5FALSE