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