Kelly€™s Boutique, located in Pewaukee, Wisconsin, sells a unique combination of books and women€™s shoes. Customers love to peruse her book inventory while trying on the latest in shoe fashions, often buying both books and shoes even though they came in to buy only one type of merchandise. Casey, Kelly€™s youngest son, a college student studying accounting, is home for the holidays and can€™t wait to help his mom come in from the dark ages and use computers in her business. Throughout this text Casey will make every attempt to bring his mom up to speed by teaching her the use of Excel and Access as they apply to her accounting and business needs.
To begin, Casey suggests that Kelly use a worksheet to make a list of her book inventory. She doesn€™t maintain a large inventory, but she does carry books that she thinks moms in the community might be interested in reading or buying as gifts for their children or friends.
Start with worksheet ch2-05. Format this worksheet using bold and italics formatting for the titles and bold and border formatting for the column names.
Add formulas for column E to compute the sales price as list price less the dis-count specified. Add the following two books and related information to the list. (Be sure the list maintains its alphabetic organization by inserting rows in the correct place.)

Insert a new column D with the title €˜€˜On Hand€™€™ in bold, centered, and cen-ter justified. Change the formatting of the column to no decimals. Add the fol-lowing on hand values to column D.

Add a €˜€˜Total€™€™ label in cell B27 and a SUM function in cell D27 to add up the quantity of books on hand. Change the name of Sheet1 to €˜€˜8% Discount.€™€™ Create a copy of this worksheet and place it before Sheet2. Change the name of the newly created worksheet to €˜€˜12% Discount.€™€™ Change the discount in cell F1 of this worksheet to 12%. Save the file as ch2-05_student_name (replacing student_name with your name).

a. Print the completed 8% Discount worksheet in Value view, with your name and date printed in the lower left footer and file name in the lower right footer.
b. Print the completed 12% Discount worksheet in Value view, with your name and date printed in the lower left footer and file name in the lower right footer.
c. Print the completed 8% Discount worksheet in Formula view, with gridlines and row and column headings, landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and file name in the lower right footer.
d. Print the completed 12% Discount worksheet in Formula view, with gridlines and row and column headings, landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and file name in the lower right footer.

Transcribed Image Text:

Dept Product List Price Author Make Way for Ducklings Snow Falling on Cedars 17.99 21.95 Children Adult McClosky Guterson Product Author On Hand Angela's Ashes Betsy – Tacy Blueberries for Sal McCourt Lovelace 2 McCloskey Brink Caddie Woodlawn Deep End of the Ocean Divine Secrets of the YaYa Sisterhood Mitchard 4 Wells 3 Green Eggs and Ham Harry Potter and the Chamber of Secrets Harry Potter and the Prisoner of Azkaban Harry Potter and the Sorcerer's Stone Hop on Pop Horse Whisperer Lentil Seuss 1 Rowling Rowling Rowling 3 2 Seuss 1 Evans McCloskey McCloskey Make Way for Ducklings Memoirs of a Geisha Message in a Bottle One Morning in Maine Snow Falling on Cedars Golden Sparks McCloskey Guterson 2 The Cat in the Hat Seuss The Notebook Sparks