A А
BC
What's More
Direction: Read the statements carefully and identify the correct answer inside the
box Write the answer on your answer sheet.
*FORMULA & FUNCTION
*QUOTIENT
*ROUND
*MOD
*SUMPRODUCT
*POWER
*AVERAGE
*SUM
*PRODUCT
*MS Excel
1. Gives the sum of the products of corresponding ranges or arrays.
2. Calculates average of a series of numbers
3. Multiplies all numbers
4. Adds all the numbers in a range of cells
5. Rounds a number to a specified number of digits.
6. Gives the remainder after a number is divided by a divisor
7. Gives the integer portion of a division
8. Gives the result of a number raised to a power
9. Most commonly used computerized worksheets
10. Helps increase the accuracy of calculations while decreasing
the amount of time spent in Excel
Answers & Comments
Answer:
1. Sumproduct
2. Average
3. Product
4. Sum
5. Round
6. Mod
7. Quotient
8. Power
9. MS Excel
10. Formula and Function