Module 6

Question 1

1. It multiplies all the numbers given as argument.

Accepted Answer

c. Product

Question 2

10.It is an application program designed to perform basic mathematical and arithmetic operations.

Accepted Answer

a. Electronic spreadsheet

Question 3

6. What is the most popular electronic spreadsheet programthat we usedtoday?

Accepted Answer

c. Microsoft Excel

Question 4

9. This function returns the sum of the products of corresponding ranges or arrays.

Accepted Answer

c. SUMPRODUCT

Question 5

5. This function returns the remainder after a numberisdivided by a divisor.

Accepted Answer

b. MOD

Question 6

7. To begin with an Excel function, what sign should be used when you are manually calculating?

Accepted Answer

c. equal (=), a. Plus (+)

Question 7

3. What function should be used when adding the cells specified by the condition or criteria?

Accepted Answer

b. SUMIF

Question 8

4. It returns the integer portion of a division.

Accepted Answer

a. Quotient

Question 9

2. What functions should be used when adding all thenumbers in a range of cell?

Accepted Answer

a. Sum

Question 10

8. What function that returns the sum of the squares of the arguments?

Accepted Answer

d. SUMSQ

Questions 10