1. This is a tool designed with functions and formulas that can perform advanced
numerical calculations.
A. Data base B. Power Point Slide
C. Spreadsheet D. Word Document
2. These are calculations that return a result.
A. Feedback
B. Figure
C. Formulas
D. Function
3. These combinations of functions, operands, and operators are?
A. Feedback B. Figure
C. Formulas
D. Function
4. Syntax used for AVERAGE function.
A. AVERAGE(logical 1, logical 2, …)
C.
AVERAGE(range,criteria,average_range)
B. AVERAGE(number 1, number 2, …) D. AVERAGE(value1, value2, …)
5. Syntax used for SUM function.
A. SUM(logical 1, logical 2, …)
C. SUM(range,criteria,average_range)
B. SUM(number 1, number 2, …)
D. SUM(value1, value2, …)
6. Syntax used for AND function.
A. AND(logical 1, logical 2, …)
C. AND(range,criteria,average_range)
B. AND(number 1, number 2, …)
D. AND(value1, value2, …)
7. Syntax used for IF function.
A. IF(logical_test, value_if_true, value_if_false)
B. IF(number 1, number 2, …)
C. IF(range,criteria,average_range)
D. IF(value1, value2, …)
8. Syntax used for OR function.
A. OR(logical 1, logical 2, …)
C. OR(range,criteria,average_range)
B. OR(number 1, number 2, …)
D. OR(value1, value2, …)
9. Syntax used for COUNT function.
A. COUNT(logical 1, logical 2, …)
B. COUNT(number 1, number 2, …)
C. COUNT(range,criteria,average_range)
D. COUNT(value1, value2, …)
10. Syntax used for LEN function.
A. LEN(logical 1, logical 2, …)
C. LEN(range,criteria)
B. LEN(number 1, number 2, …)
D. LEN(text)
Answers & Comments
Answer:
1. C
2. D
3. C
4. B
5. B
6. A
7. A
8. A
9. D
10. D
Explanation: