狠狠撸

狠狠撸Share a Scribd company logo

Case Problem: Instruments.xlsx

?
?
V
ViscKand

Anthony's Music Store rents musical instruments to K-12 students. Anthony tracks rentals in an Excel worksheet including renter name, instrument, rental date, rental period of 3 or 9 months, and whether insurance or delivery was selected. Students are asked to expand the worksheet to assign instrument group codes (A-E) using HLOOKUP based on the instrument name.

1 of 2
Download to read offline
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: ? Renter—the name of the renter ? Instrument—the type of instrument rented ? Rental Date—the date the instrument was rented ? Rental Period—either 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 Code—indicates 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
(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.

More Related Content

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: ? Renter—the name of the renter ? Instrument—the type of instrument rented ? Rental Date—the date the instrument was rented ? Rental Period—either 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 Code—indicates 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.