Excel Lesson 5 Knowledge Assessment

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

• AVERAGE
• AutoSum
• COUNTA
• MAX

The arguments of a function are contained within which of the following?

• brackets
• asterisks
• commas
• parenthesis

When using the SUBTOTAL function, what is the function number for the SUM function?

• 1
• 4
• 9
• 11

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function do you use?

• SUBTOTAL
• AVERAGE
• COUNT
• PMT

Which of the following is not a required argument for the PMT function?

• Fv
• Rate
• Nper
• Pv

You want to calculate the number of non-blank cells in your worksheet. Which function do you use?

• SUM
• COUNT
• COUNTA
• MAX

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())-199
• b.  =YEAR(TODAY())+1991
• c.  =YEAR(COUNT())-1991
• d.  =YEAR(COUNT())+1991

Which 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.

You want to sum multiple non-contiguous cell ranges that are named. Which of the following is best to use?

• AutoSum
• SUBTOTAL
• MAX
• MIN

10.  The COUNT and SUM functions are examples of which functions?

• text
• statistical 
• financial
• logical