More Related Content
More from ViscKand (8)
Recently uploaded (20)
Case Problem: Instruments.xlsx
- 1. Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-Instruments.xlsx- Data File needed for this Case Problem: Instruments.xlsx Anthony's Music Store Anthony Malone sells and rents musical instruments. One part of his business involves renting instruments to K-12 students who participate in school bands and orchestras. Instruments available for rent include flutes, clarinets, trombones, Oboes, piccolos, saxophones, accordions, bassoons, and French hems. Anthony maintains an Excel worksheet to track instrument rentals that includes the following information: Renterthe name of the renter Instrumentthe type of instrument rented Rental Datethe date the instrument was rented Rental Periodeither 3 or 9 months, as shown in the Rental Period column: no other rental periods are allowed Ins Cod - indicates whether renters elected to purchase instrument insurance; if elected, Yes appears in the Ins Cod column, otherwise, Na is entered Shipping Codeindicates whether the renter wants the instrument delivered directly to the school (either Ground or Rush), or the renter will pick up the instrument at the store
- 2. (Piclaip). Anthony wants you to expand the information that is tracked. Complete the following: 1. Open the Instruments workbook located in the Excel8 ? Tutorial folder included with your Data Files, and then save the workbook as Instrument Rentals in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and the date. 3. In the Rental Data worksheet, in column G, create a formula that uses the HLOOKUP function to assign a group code (A, B, C, D, or E) from the InstrumentGroups range in the Rental Information worksheet to the instrument listed in column B.