HomeApplicationOffice information

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!

4.4 ★ | 7 Vote

You should read it

May be interested

  • How to Practice ProgrammingHow to Practice Programming
    programming is kind of like playing an instrument; you have to practice constantly to keep your skills sharp and improve your techniques. if you want to practice programming on your own time, use the internet to find coding exercises and...
  • Basic errors to avoid when doing gymBasic errors to avoid when doing gym
    everyone knows the benefits of the gym, but not everyone knows how to practice correctly even with basic movements. actions such as pushing, squatting, lifting weights, sagging, ... seem simple but very easy to make mistakes while practicing.
  • 9 practice exercises to become a professional network administrator9 practice exercises to become a professional network administrator
    the series of 9 exercises allotted to the 3 basic, intermediate and advanced levels mentioned below will cover different network topics, from basic to advanced.
  • What is payroll? What does payroll mean?What is payroll? What does payroll mean?
    crane salary is a loan term of chinese and also often appears on facebook. so what does payroll mean?
  • Please download VnDoc's Exercises app to make learning easierPlease download VnDoc's Exercises app to make learning easier
    solving exercises with vndoc is an application that helps students learn good subjects. download this application to your phone, parents and students from grade 1 - 12 will have more instructions to solve the textbook exercises, homework exercises in mathematics, vietnamese, language arts, english .
  • Practice practicing hotel expense index in ExcelPractice practicing hotel expense index in Excel
    the following article provides detailed instructions for you to practice on how to calculate the values ​​in the hotel cost list in excel 2013. for example, the following data table: calculating the amount of tenants to pay according to the exchange rate current dollars.
  • Yoga exercises help increase height effectivelyYoga exercises help increase height effectively
    not only relying on nutrition, exercising properly also increases effective height. here are 12 yoga exercises to help develop height if persistent practice every day.
  • 6 Effective Exercises to Build Your Photography Skills6 Effective Exercises to Build Your Photography Skills
    practice makes perfect in photography, but knowing what to focus on when you're just starting out can be difficult. trying different skill-building exercises will take the guesswork out of it and help you refine your technique.
  • Yoga exercises to treat insomniaYoga exercises to treat insomnia
    yoga can provide many health benefits, including better sleep. because yoga can be relaxing and restorative, it's a great way to beat insomnia after a busy day.
  • Maintain memory and cognitive ability when you get old with 4 simple exercisesMaintain memory and cognitive ability when you get old with 4 simple exercises
    practice writing two hands at the same time, trying to reflect on colorful texts or numerical tables are helpful exercises for the brain. join us in 4 simple exercises that help maintain memory and cognitive abilities when you get old!

Office information