Practice exercises on payroll in Excel

The following article gives detailed instructions to you practice exercises on payroll in Excel 2013.

The example has the following data table:

Practice exercises on payroll in Excel Picture 1

Calculate employee's gross salary, calculate the maximum value of salary, advance and remaining, average and minimum value.

Step 1: In the cell to calculate the salary enter the formula: = E5 * F5 -> press Enter -> salary of the employee is:

Practice exercises on payroll in Excel Picture 2

Step 2: Similarly copy the remaining values ​​to result:

Practice exercises on payroll in Excel Picture 3

Step 3: To calculate the remaining salary, the employee enters the formula: = G5 - H5 -> press Enter -> the remaining salary is:

Practice exercises on payroll in Excel Picture 4

Step 4: Similarly copying the formula to the remaining values ​​results:

Practice exercises on payroll in Excel Picture 5

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

Practice exercises on payroll in Excel Picture 6

Step 6: Similarly, enter the formula for the total advance salary and the total remaining salary:

Practice exercises on payroll in Excel Picture 7

Step 7: Calculate the largest salary value in the company -> enter the formula: = MAX (G5: G9) -> press Enter -> the return value is:

Practice exercises on payroll in Excel Picture 8

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

Practice exercises on payroll in Excel Picture 9

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

Practice exercises on payroll in Excel Picture 10

- After calculating, there is a complete salary table. In this data sheet you can easily read and find the most frequently searched information:

Practice exercises on payroll in Excel Picture 11

Above is a detailed guide of practical exercises on payroll in Excel 2013.

Good luck!