You have been hired as an intern to help Ingrid Theobald, the owner of Ingrid’s Instrument Rentals, evaluate how her business is going by using an Excel workbook. Ingrid has created a simple workbook with four worksheets, one for each school to which she rents instruments. She wants to know how much she is making from each school, as well as summary data for all four schools. Each worksheet lists the type of instruments she is renting to the school, the number of students, and the rate per student. Ingrid would like to see on each worksheet total charges for each instrument and a total number of students and total charges for the school. The Rate per Student comes from the RentalRates worksheet, but she would like it to come from a separate workbook. She would also like to be able to share the workbook with the music directors at each school so they can update their number of students each semester.
Grader – Instructions Excel 2022 Project
YO22_Excel_Ch07_Assessment_Music
Project Description:
You have been hired as an intern to help Ingrid Theobald, the owner of Ingrid’s Instrument Rentals, evaluate how her business is going by using an Excel workbook. Ingrid has created a simple workbook with four worksheets, one for each school to which she rents instruments. She wants to know how much she is making from each school, as well as summary data for all four schools. Each worksheet lists the type of instruments she is renting to the school, the number of students, and the rate per student. Ingrid would like to see on each worksheet total charges for each instrument and a total number of students and total charges for the school. The Rate per Student comes from the RentalRates worksheet, but she would like it to come from a separate workbook. She would also like to be able to share the workbook with the music directors at each school so they can update their number of students each semester.
You have been hired as an intern to help Ingrid Theobald, the owner of Ingrid’s Instrument Rentals, evaluate how her business is going by using an Excel workbook. Ingrid has created a simp first appeared on Aca Homework.
Need help with your own assignment?
Our expert writers can help you apply everything you've just read — to your actual assignment.
Get Expert Help Now →