Ingrids Instrument Rental;

Ingrids Instrument Rental;

You have been hired as an intern to help Ingrid, the owner of Ingrids Instrument Rentals, evaluate how her business is going by using an Excel workbook. She has

created a simple workbook with 4 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. She

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.
a.Open e04ws07Music and save it as e04ws07Music_LastFirst, replacing LastFirst with your actual name.
b.Group the Valley through Mills worksheets. Create a formula in cells D5:D15 to calculate the total charges for each instrument. Format cells C5:D16 with the

Accounting Number Format. In cells B16 and D16, calculate the total number of students and total charges for the school. Ungroup the worksheets and save the workbook.
c.On the Summary worksheet, enter a 3-D SUM function in cells B5:B15 to calculate the total students for all four schools. Use Fill Across Worksheets to copy the

contents and formatting of cells D5:D15 and cell B16 from the Mills worksheet to the Summary worksheet. Use Fill Across Worksheets to copy the formatting for cells

B5:C15 from the Mills worksheet to the Summary worksheet. Save the workbook.
d.On the LinkedSummary worksheet, in cell A4, create a linked consolidation using cells A4:D15 from each of the school worksheets. Be sure and select Top Row, Left

Column, and Create links to source data in the Consolidate dialog box. Change the column width of column A to 13, hide column B, and AutoFit columns C:E. Save the

workbook.
e.Save e04ws07Music_LastFirst as e04ws07MusicLink_LastFirst, replacing LastFirst with your actual name, and delete the RentalRates worksheet. Open e04ws07MusicRates

and arrange the workbooks side by side.
f.On e04ws07MusicLink_LastFirst, group the Valley through Summary worksheets. Click cell C5 and in the formula bar replace RentalRates in the VLOOKUP (which is no

longer a valid range name) with a link to the range InstrumentRates (cells A4:B14) on the e04ws07MusicRates workbook. Copy the formula to cells C6:C15. Ungroup the

sheets. Save the workbooks. Close e04ws07MusicRates.
g.On e04ws07MusicLink_LastFirst, if necessary, add the Compare & Merge Workbooks button to the Quick Access Toolbar.
h.Share e04ws07MusicLink_LastFirst and allow changes to be made. Save e04ws07MusicLink_LastFirst as e04ws07Music2_LastFirst, replacing LastFirst with your actual name.
i.Change the Valley Day Schools #Students for violin to 22 and for tuba to 2. Save the changes and close the workbook.
j.Open e04ws07MusicLink_LastFirst, click Enable Content, and compare and merge the workbook with e04ws07Music2_LastFirst. Save the changes to a new sheet but do not

stop sharing. Save and close the workbook.
k.Create a template from e04ws07Music_LastFirst to use for the next school year. Group the Valley through Mills worksheets and clear the contents from cells B5:B15.

Clear the contents from cell A3. Save the template as e04ws07MusicTemp_LastFirst, replacing LastFirst with your actual name.

Instrument Rentals
Valley Day School
First Semester for School Year 2014-2015
Instrument     #Students    Rate per Student    Total Charges
Violin    20    350
Viola    12    350
Cello    3    450
Bass    2    450
Clarinet    10    275
Oboe    5    295
Flute    8    195
Saxophone    8    335
French Horn    3    420
Tuba    1    425
Trumpet    7    210
Total

Rental Rates

Instrument     Rate per Student
Bass     $450.00
Cello     $450.00
Clarinet     $275.00
Flute     $195.00
French Horn     $420.00
Oboe     $295.00
Saxophone     $335.00
Trumpet     $210.00
Tuba     $425.00
Viola     $350.00
Violin     $350.00

                        

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 10% with the discount code DHCOVID10