New Perspectives on Microsoft Excel Module 3 Latest 2025-2026 Solved Correctly Latest Update 2025
The ____ category of Excel functions returns (true-false) values . - Answers Logical
Which of the following is a Statistical function? - Answers AVERAGE
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function. - Answers nested
The numbers, text, or cell references used by the function to return a value are called ____ . - Answers
arguments
Which of the following is not a comparison operator? - Answers <<
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? - Answers The
formula returns the text "RESTART".
Which of the following is not a date function? - Answers AND
One of the great advantages of ____ references is that you can quickly generate row and column totals
without having to worry about revising the formulas as you copy them to new locations . - Answers
relative
Absolute references are marked with a ____. - Answers $
When you copy a formula that contains an absolute reference to a new location, the reference ____ . -
Answers does not change
Which of the following is not an Excel function category? - Answers Algebra
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or
____ . - Answers cell references
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the
formatting . - Answers content
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. - Answers A does not equal B
_____ functions find values in tables of data and insert them in another location in the worksheet such
as cells or in formulas . - Answers Lookup
Write general syntax of all Excel functions. - Answers FUNCTION(argument1, argument2,...)
Name any 5 Error values in Excel 2016. - Answers #DIV/0!
#NAME?
#N/A
#NULL!
The ____ category of Excel functions returns (true-false) values . - Answers Logical
Which of the following is a Statistical function? - Answers AVERAGE
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function. - Answers nested
The numbers, text, or cell references used by the function to return a value are called ____ . - Answers
arguments
Which of the following is not a comparison operator? - Answers <<
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"? - Answers The
formula returns the text "RESTART".
Which of the following is not a date function? - Answers AND
One of the great advantages of ____ references is that you can quickly generate row and column totals
without having to worry about revising the formulas as you copy them to new locations . - Answers
relative
Absolute references are marked with a ____. - Answers $
When you copy a formula that contains an absolute reference to a new location, the reference ____ . -
Answers does not change
Which of the following is not an Excel function category? - Answers Algebra
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or
____ . - Answers cell references
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the
formatting . - Answers content
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. - Answers A does not equal B
_____ functions find values in tables of data and insert them in another location in the worksheet such
as cells or in formulas . - Answers Lookup
Write general syntax of all Excel functions. - Answers FUNCTION(argument1, argument2,...)
Name any 5 Error values in Excel 2016. - Answers #DIV/0!
#NAME?
#N/A
#NULL!
