6. You want to calculate the number of non-blank cells in your worksheet. Which function do you use? a. SUM b. COUNT c. COUNTA d. MAX Monday March 2, 2015 7. You want to create a formula that calculates the number of years you have lived. You were born in 1991. Which of the following formulas is correct? a. =YEAR(TODAY())-1991 b.=YEAR(TODAY())+1991 c. =YEAR(COUNT())-1991 d.=YEAR(COUNT())+1991 8. of the following statements accurately describes the default selection for AutoSum? a. You must make the selection before clicking AutoSum. b. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content. c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell. d. AutoSum does not have a default selection. 9. You want to sum multiple non-contiguous cell ranges that are named. Which of the following is best to use? a. AutoSum b. SUBTOTAL c. MAX d. MIN 10. The COUNT and SUM functions are examples of which functions? a. text b. statistical c. financial d. logical Thursday March 5, 2015 1. You want to insert a cell into your worksheet. Which command so you use? a. The Insert command in the Cells group on the HOME tab
6. You want to calculate the number of non-blank cells in your worksheet. Which function do you use? a. SUM b. COUNT c. COUNTA d. MAX Monday March 2, 2015 7. You want to create a formula that calculates the number of years you have lived. You were born in 1991. Which of the following formulas is correct? a. =YEAR(TODAY())-1991 b.=YEAR(TODAY())+1991 c. =YEAR(COUNT())-1991 d.=YEAR(COUNT())+1991 8. of the following statements accurately describes the default selection for AutoSum? a. You must make the selection before clicking AutoSum. b. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content. c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell. d. AutoSum does not have a default selection. 9. You want to sum multiple non-contiguous cell ranges that are named. Which of the following is best to use? a. AutoSum b. SUBTOTAL c. MAX d. MIN 10. The COUNT and SUM functions are examples of which functions? a. text b. statistical c. financial d. logical Thursday March 5, 2015 1. You want to insert a cell into your worksheet. Which command so you use? a. The Insert command in the Cells group on the HOME tab