Learning Task 5: Choose the letter of the correct answer and write your answers in your notebook
1. It adds all the numbers in a range of cells. a SUM c. QUOTIENT b. PRODUCT d. POWER
2. It returns the remainder after a number is divided by a divisor a. PRODUCT c. MOD b. SUM d. ROUND 3. It multiplies all the numbers given as arguments. a. MOD c. SUM b. PRODUCT d. ROUND
4. It returns the result of a number raised to a power a ROUND c. PRODUCT b. SUM d. POWER
5. It returns the integer portion of a division a QUOTIENT c. POWER b. SUMPRODUCT d. ROUND
6. It rounds off a number to a specified number of digits. a SUMPRODUCT C QUOTIENT b. ROUND d. SUMIF
7. It returns the sum of the squares of the arguments SUMSO C. SUMIT b. SUMSPRODUCT d. SUMIFS
8 It adds the cells specified by a given set of conditions or criteria a SUMSO C. SUMIT b. SUMSPRODUCT d. SUMIFS
9.Adds the Cells specified by a given condition or criteria. A. SUMSQ C. SUMIF
B. SUMSPRODUCT D. SUMIFS
10.It returns the sum of the product of corresponding ranges or arrays.
A. SUMSQ C. SUMIF B. SUMSPRODUCT D. SUMIFS​