5. Test the validation rules for cells B4, B12, and B13 to ensure that the correct data appears in..

5. Test the validation rules for cells B4, B12, and B13 to
ensure that the correct data appears in the

validation lists.

6. Insert a WordArt text box, and then enter Music Inventory
as the text. Rotate the

WordArt so that it is vertical in column E. Change the text
fill to 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.)

7. Create the following formulas for the specified cells in
the CD Transfer Area:

Cell A22: =Artist_Name

Cell B22: =CD_Name

Cell C22:

5. Test the validation rules for cells B4, B12, and B13 to
ensure that the correct data appears in the

validation lists.

6. Insert a WordArt text box, and then enter Music Inventory
as the text. Rotate the

WordArt so that it is vertical in column E. Change the text
fill to 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.)

7. Create the following formulas for the specified cells in
the CD Transfer Area:

Cell A22: =Artist_Name

Cell B22: =CD_Name

Cell C22: =Genre

8. Create the following formulas for the specified cells in
the Song Transfer Area:

Cell A25: =Artist

Cell B5: =CD

Cell C25: =Song

9. In the Music Entry worksheet, unlock the input cells,
which are in the ranges B2:B4 and

B12:B14.