Question

Explain how to use basic formulas for addition and average in MS Excel.

Hint:

\textbf{Remember:} Addition → =SUM(A1:A5) Average → =AVERAGE(A1:A5)

Answer 1

Concept: MS Excel is a spreadsheet software used for calculations, data analysis, and record keeping. Formulas in Excel help perform calculations automatically using cell references. Addition Formula in MS Excel: Addition is used to find the sum of numbers stored in different cells. Method 1: Using the PLUS (+) operator

Enter numbers in cells (e.g., A1 = 10, A2 = 20, A3 = 30).
Click on the cell where you want the result (e.g., A4).
Type the formula: \[ =A1 + A2 + A3 \]
Press Enter to get the total.
Method 2: Using the SUM Function

Select the result cell.
Type: \[ =SUM(A1:A3) \]
Press Enter.
Average Formula in MS Excel: The average formula calculates the mean value of a set of numbers. Steps to Calculate Average:

Enter values in cells (e.g., B1 = 40, B2 = 60, B3 = 80).
Click on the result cell (e.g., B4).
Type the formula: \[ =AVERAGE(B1:B3) \]
Press Enter to display the average.
Important Points:

All formulas in Excel begin with an equals sign (=).
Cell ranges are written using a colon (e.g., A1:A5).
Functions like SUM and AVERAGE save time and reduce errors.
Conclusion: Basic formulas like addition and average in MS Excel help perform quick and accurate calculations using simple operators or built-in functions.