Microsoft Excel Unit 5

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

• parentheses

You want to calculate the number of nonblank cells in your worksheet. Which function

do you use?

• SUM

• COUNT

• COUNTA

• MAX

The COUNT and MIN functions are examples of which category of functions?

• text

• statistical

• financial

• logical

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

• AutoSum

• SUBTOTAL

• MAX

• MIN

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?

• =YEAR(TODAY())-1991

• =YEAR(TODAY())+1991

• =YEAR(COUNT())-1991

• =YEAR(COUNT())+1991

In the PMT function, the Nper argument is the total number of payments for the loan.

• True

• False

You can use a range in the SUBTOTAL function, but you cannot modify the range once it’s in use.

• True

• False

To evaluate the error in the formula, select the Edit in Formula Bar option from the pop-up menu that appears after you click the warning icon.

• True

• False

When functions take more than one argument, you should enter them in multiple sets of nested parentheses, separated by commas.

• True

• False