HomeApplicationOffice information

Practical exercise on computer rental list in Excel

The following article gives detailed instructions for you to practice on how to calculate the values ​​in the computer rent list in Excel 2013.

The example has the following data table:

Practical exercise on computer rental list in Excel Picture 1

Calculate the amount payable by computer tenants, calculate the total number of rental hours and the total proceeds.

Step 1: To calculate the amount the tenant must pay, it is necessary to calculate the number of hours the customer has rented. In the column of the total hours enter the formula: = F7-E7:

Practical exercise on computer rental list in Excel Picture 2

Step 2: Press Enter -> the total number of hours guests have rented is:

Practical exercise on computer rental list in Excel Picture 3

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

Practical exercise on computer rental list in Excel Picture 4

Step 4: Calculate the total amount you have to pay -> enter the formula : = $ H $ 4 * G7 * 24, here the unit price is the fixed value you should enter in the absolute address form (by blackening the cell address -> press F4):

Practical exercise on computer rental list in Excel Picture 5

Step 5: Press Enter -> return value is:

Practical exercise on computer rental list in Excel Picture 6

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

Practical exercise on computer rental list in Excel Picture 7

Step 7: Calculate the total number of hours the customer has hired -> enter the formula: = SUM (G7: G16) -> press Enter -> the total number of hours the customer has hired is:

Practical exercise on computer rental list in Excel Picture 8

Step 8: Similarly, calculate the total rent collected by the customer:

Practical exercise on computer rental list in Excel Picture 9

The above is a detailed guide on how to declare computer rentals in Excel 2013.

Good luck!

4 ★ | 1 Vote

You should read it

May be interested

  • How does different exercise affect the brain?How does different exercise affect the brain?
    physical activities help your body become healthier, more supple. besides, each different exercise has different positive effects on the functioning of the human brain. they help us increase intelligence, reduce stress, increase cognitive ability, and fight depression ...
  • The best way to exercise by ageThe best way to exercise by age
    strength and ability to exercise at each age is different. dr. mickey mehta, india's leading health expert, advises people to exercise slowly, appropriate for their age and below the maximum to help release energy, not the body to the point of exhaustion.
  • How to create drop down list to select in excelHow to create drop down list to select in excel
    this article will guide you how to create a drop down list - a drop down list to select data in excel extremely useful and handy.
  • Guide to GrabCar rental by hourGuide to GrabCar rental by hour
    if you need to move continuously, many locations and need to save time, do not want to have to wait or wait for the car continuously, grabcar option by hour is a very reasonable plan.
  • 21 miraculous benefits of exercise have been scientifically proven21 miraculous benefits of exercise have been scientifically proven
    everyone knows how to exercise well but don't have the motivation to do it. here are 21 great benefits of scientifically proven daily exercise. hopefully, after reading the article, you will exercise regularly.
  • Exercise weight loss within 3 weeks with 5 simple movementsExercise weight loss within 3 weeks with 5 simple movements
    a healthy body will help you be more confident in wearing swimwear. if you are planning to go to the sun on a beach this summer, the following simple exercise is all you need.
  • How to use the SUBTOTAL function in ExcelHow to use the SUBTOTAL function in Excel
    the subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values ​​in excel
  • List of common shortcuts for Google Sheets on computers (Part 1)List of common shortcuts for Google Sheets on computers (Part 1)
    using google sheets shortcuts helps you enter data faster and more efficiently, especially saving time. below is a list of common shortcuts for google sheets on your computer.
  • 6 tips for exercise for lazy people6 tips for exercise for lazy people
    when you feel tired, stressed, busy, you often have no interest in putting your shoes on and step outside to participate in sports activities. don't worry, follow these tips, you will eliminate boredom, laziness and continue healthy activities.
  • GPU rental service - The preeminent solution for professional 3d artistsGPU rental service - The preeminent solution for professional 3d artists
    the birth & development of cloud computing technology (cloud computing) has opened up many development directions for the fields of science and technology, programming, computer graphics. thanks to that, today a home-sitting artist can also access a powerful configuration computer, through reliable, user-friendly protocols.

Office information