MS-EXCEL SHORTCUTS
|

MS-EXCEL SHORTCUTS

SUM FUNCTION Description: Adds all the numbers in a range of cells. Formula: =SUM(number1, [number2], …) Example: =SUM(A1:A5) adds all the numbers from cell A1 to A5. AVERAGE FUNCTION Description: Calculates the average of the numbers in a range of cells. Formula: =AVERAGE(number1, [number2], …) Example: =AVERAGE(B1:B10) calculates the average of numbers in cells B1…