Ms Excel

(a) Find the total sale for the six months.
To calculate the total sale, use the SUM formula in Excel: This formula adds all the sales figures from January to June, giving the total sale for the six months.
(b) Find the average sale of the six months.
To calculate the average sale, use the AVERAGE formula in Excel: This formula calculates the average of the sales for the six months.
(c) Find the lowest sale of the six months.
To find the lowest sale, use the MIN formula in Excel: This formula returns the lowest sale figure from the list.
(d) Find the highest sale of the six months.
To find the highest sale, use the MAX formula in Excel: This formula returns the highest sale figure from the list.

Step 1: Formula for Total Marks.
To calculate the total marks for each student, we need to sum the marks scored in all three months (July 2022, December 2022, and March 2023). Therefore, for each student, the formula in Column E is: Similarly for other students, replace the row numbers accordingly.
Step 2: Formula for Total Marks for All Students.
To calculate the total marks for each month (Column B, C, and D), use the SUM formula for each column. For example, for Column B (July 2022): Similarly for the other months (Columns C and D), use the SUM formula for each column.

Step 1: Understanding SLN Depreciation Formula.
In MS Excel, the SLN function calculates depreciation using the straight-line method. The formula is: Where:
- cost is the initial cost of the asset.
- salvage is the value of the asset at the end of its useful life (salvage value). - \texttt{life} is the useful life of the asset in years.
Step 2: Applying the Formula to the Given Table.
In the table, the given values are:
- Cost = ₹5000
- Salvage = ₹10000
- Useful life = 5 years
The formula to calculate depreciation in this case will be: Step 3: Conclusion.
The SLN function in Excel provides the annual depreciation amount of an asset based on its initial cost, salvage value, and useful life.

The Round function in Excel rounds a number to a specified number of digits. The first example rounds the number 1765.4321 to two decimal places, resulting in 1765.43. The second example rounds the number to the nearest integer, resulting in 1765.