際際滷

際際滷Share a Scribd company logo

Case Problem: Music.xlsx

V
ViscKand

Christian Wirth wants to better organize his extensive music CD collection by creating a workbook to track each artist, CD, genre, and song, and asks you to complete the workbook by adding input validation, cell protection, and macros to ensure accurate information. The document provides instructions to open the provided Music workbook, review the worksheets, create defined names in specified cells, add validation rules for genre, artist, and CD lists, test the validation rules, and insert vertical WordArt reading "Music Inventory" in a complementary color.

Convert to study materialsBETA

Transform any presentation into ready-made study materialselect from outputs like summaries, definitions, and practice questions.

1 of 2
Download to read offline
Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-Music.xlsx- Data File needed for this Case Problem: Music.xlsx Music Inventory Christlan Wirth has an extensive collection of music CDs. He wants to create a better way to organize the Inventory of what he owns. Christian has started a workbook that he can use. enter each artIst, CD, genre, and song in hls collection. He asks you to finish it by incorporating input validatIon, cell protection, and macros to help ensure that the collected information Is accurate. Complete the following: 1. Open the Music workbook located In the Excel ?Cases folder included with your Data Files, and then save the workbook as Music Inventory In the location specified by your Instructor. 2. In the Documentation sheet, enter your name and the date, and then review all of the worksheets in the workbook 3. In the Music Entry worksheet, create appropriate defined names for each cell in the ranges A2:E14 and Al2B14. 4. Create the following validation rules: a. Genre (cell B4): The list of genres is in the range D2.D11. Enter an appropriate input message and error alert b. Artist (cell B12). The list of artists are in the range A2.A3 on the CDs worksheet. Enter an appropriate input message and error alert. c. CD (cell B13): The list of CDs is in the range B2.B3 on the CDs worksheet. Enter an appropriate input message and error alert.
5. Test the validation rules for cells B4. B12, and B13 to ensure that the correct data appears In the valldation 6. Insert a WordArt teat box, and then enter Music Inventory as thereat. Rotate the WordArt so that it is vertical In column E. Change the text fill. a color complementing the shade of green in the headings. (Hint: On the INSERT tab, click the Insert WordArt button. Then use the DRAWING TOOLS FORMAT tab to format the WordArt.)

More Related Content

Case Problem: Music.xlsx

  • 1. Buy here: http://homeworknumber.one/products.php?product=Cas e-Problem%3A-Music.xlsx- Data File needed for this Case Problem: Music.xlsx Music Inventory Christlan Wirth has an extensive collection of music CDs. He wants to create a better way to organize the Inventory of what he owns. Christian has started a workbook that he can use. enter each artIst, CD, genre, and song in hls collection. He asks you to finish it by incorporating input validatIon, cell protection, and macros to help ensure that the collected information Is accurate. Complete the following: 1. Open the Music workbook located In the Excel ?Cases folder included with your Data Files, and then save the workbook as Music Inventory In the location specified by your Instructor. 2. In the Documentation sheet, enter your name and the date, and then review all of the worksheets in the workbook 3. In the Music Entry worksheet, create appropriate defined names for each cell in the ranges A2:E14 and Al2B14. 4. Create the following validation rules: a. Genre (cell B4): The list of genres is in the range D2.D11. Enter an appropriate input message and error alert b. Artist (cell B12). The list of artists are in the range A2.A3 on the CDs worksheet. Enter an appropriate input message and error alert. c. CD (cell B13): The list of CDs is in the range B2.B3 on the CDs worksheet. Enter an appropriate input message and error alert.
  • 2. 5. Test the validation rules for cells B4. B12, and B13 to ensure that the correct data appears In the valldation 6. Insert a WordArt teat box, and then enter Music Inventory as thereat. Rotate the WordArt so that it is vertical In column E. Change the text fill. a color complementing the shade of green in the headings. (Hint: On the INSERT tab, click the Insert WordArt button. Then use the DRAWING TOOLS FORMAT tab to format the WordArt.)