Tally Module 4 Notes
SPEADSHEET APPLICATION IN FINANCIAL ANALYSIS 🔽BASICS TO INTERMEDIATE FUNCTIONS 1.SUM The SUM function in Microsoft Excel adds numerical values, cell references, or entire ranges together. Basic Syntax=SUM(number1, [number2], ...) A range uses a colon, like =SUM(A2:A10) Separate individual cells or distinct ranges with commas, like =SUM(A2:A5, C2:C5) 2.AVERAGE AVERAGE function in Excel calculates the arithmetic mean of a range of numbers by adding them together and dividing by the count of numeric entries. Syntax The basic syntax for the function is:=AVERAGE(number1, [number2], ...) Common Uses 1.Find a Mean Value: Quickly compute the average score, temperature, or sales figure across a row, column, or custom cell range. 2.Analyze Financial Data: Determine average monthly expenses, mean quarterly revenues, or average unit pricing. 3.Track Performance Metrics: Calculate average employee hours, student test scores, or sports statistics.