Practical Exercises on Excel Salary Spreadsheets

Step 5: To calculate total salary to be paid to employees input formula: =SUM(G5:G9) -> press Enter -> total salary to be paid is:

Step 6: Similarly, input formula for total advanced salary and total remaining salary:

Step 7: Find the maximum salary value in the company -> input formula: =MAX(G5:G9) -> press Enter -> returned value is:

Step 8: Similarly, calculate the average value: =AVERAGE(G5:G9)

Step 9: Calculate the minimum value: =MIN(G5:G9)

Once the calculations are completed, there is a complete salary spreadsheet. In this dataset, you can easily read and find the most commonly sought-after information:

Above is a detailed guide for practical exercises on salary spreadsheets in Excel 2013.

Wishing you all success!