Performing Advance Calculations Using ElectronicSpreadsheets

• SUM Adds all the numbers in a range of cell
• PRODUCT Multiplies all the numbers given as arguments
• QUOTIENT Return the integer portion of a division
• POWER Returns the result of a number raised to a power
• MOD Returns the remainder after a number is divided by a divisor
• SUMPRODUCT Returns the sum of the products of corresponding ranges or arrays
• SUMSQ Returns the sum of the squares of the arguments
• SUMIF Adds the cells specified by a given condition or criteria
• SUMIFS Adds the cells specified by a given set of condition or criteria
• ROUND Rounds a number to a specified number of digit