Knowledge Assessment certification GUIDE
FOR 2025/2026 TESTS|MOST COMMON
QUESTIONS WITH CORRECTLY VERIFIED ANSWERS
(LATEST QUIZZES) |ALREADY A+
GRADED|GUARANTEED PASS
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? - AutoSum
The arguments of a function are contained within which of the following? - parentheses
When using the SUBTOTAL function, what is the function number for the SUM function? -
9
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? - AVERAGE
Which of the following is not a required argument for the PMT function? - Fv
You want to calculate the number of non-blank cells in your worksheet. Which function do you
use? - COUNTA
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
Which of the following statements accurately describes the default selection for AutoSum? -
By default, AutoSum calculates the total from the adjacent cell through the first
nonnumeric cell.
You want to sum multiple non-contiguous cell ranges that are named. Which of the following is
best to use? - SUBTOTAL
The COUNT and SUM functions are examples of which functions? - statistical
All functions require arguments within parentheses - False
Using functions helps to ensure the accuracy of a formula's results - True
FOR 2025/2026 TESTS|MOST COMMON
QUESTIONS WITH CORRECTLY VERIFIED ANSWERS
(LATEST QUIZZES) |ALREADY A+
GRADED|GUARANTEED PASS
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? - AutoSum
The arguments of a function are contained within which of the following? - parentheses
When using the SUBTOTAL function, what is the function number for the SUM function? -
9
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? - AVERAGE
Which of the following is not a required argument for the PMT function? - Fv
You want to calculate the number of non-blank cells in your worksheet. Which function do you
use? - COUNTA
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
Which of the following statements accurately describes the default selection for AutoSum? -
By default, AutoSum calculates the total from the adjacent cell through the first
nonnumeric cell.
You want to sum multiple non-contiguous cell ranges that are named. Which of the following is
best to use? - SUBTOTAL
The COUNT and SUM functions are examples of which functions? - statistical
All functions require arguments within parentheses - False
Using functions helps to ensure the accuracy of a formula's results - True
