Assessment Description: Please see the attachment file below. Thank you

Page 1 of 3 Excel Module 1 Assignment (15 points possible, -2 each error/omission) For this assignment you will be creating an Excel spreadsheet to track sales of a book. This spreadsheet will determine the markup amount, retail price, sale price and profit margin . Steps to Perform: Step Instructions 1 Download and open the Excel Module 1 Assignment_Data File.xlsx. Save the file to your computer as Excel Module 1 Assignment_YourLastName.xlsx 2 Make cell A8 your active cell. Type Playing Cards and press Enter. Click cell A9, type Magnet, and then press Enter. 3 Use Auto Fill to Complete a Sequence Click Cell B5, type 101, and then type 102 in B6; Select cells B5 and B6. Click on fill handle at (square on bottom right of cell) and drag down stoppi ng at B9. 4 Add the following values to the worksheet: Type 0.20 into cell G6 and press Enter. Type 0.15 into cell G7 and press Enter. Type 0.08 into cell G8 and press Enter. Type 0.25 into cell G9 and press Enter. 5 Go to cell A1, Find and Replace any instance of .2 to .1. Click cell A2 and type today’s date month/day and change to Short Date format. 6 Click cell E5 and type a formula to multiply Cost * Markup (=C5*D5 ). Make E5 your active cell again and then use the fill handle to drag down the formula down through E9. 7 Click cell F5. Type a formula to add Cost and the Markup Price (=C5+E5 ). press enter, make F5 your active cell again and use the fill handle to drag down the formula down through F9. 8 Click cell H5. Type =F5 -(G5*F5), then use fill handle to drag down as completed before; make sure you don’t copy too far, only down to H9. Page 2 of 3 Step Instructions 9 Click cell I5. Type =(H5 -C5)/H5 and you know the drill! Use the fill handle to copy down. 10 Insert a column t o the left of the column that has Profit Margin in it. 11 Click cell I4, type Profit Amount, and then press Enter. Write formula in I5 that calculates the Sale Price minus the Cost (you use appropriate cell references) . Use fill handle to copy down approp riately. 12 Select row 4 and apply wrap text to headings and then center them in the cells. Change the font color to the headings with a font color of your choice. 13 Insert a row above row 8. Click cell A8. Type Souvenirs and format bold. 14 Select the range G4: H1 and apply a thick outside border . Next apply a fill color the same color as the color you used for the heading font color. 15 Select A1:J1 and Merge and Center row 1 information. Bold and make a little larger . Select A2:J2 and Merge and Center row 2 information. Bold and make one size smaller than the same font size as you did in row 1 . 16 Select cell A6:A7. Click Increase Indent in the Alignment group once . Select t he range A1 9:A1 1 and click Increase Indent once. 17 Format Values in the worksheet appropriately, applying Currency format to cells that represent money and Percent Style format to cells that should be represented by percent values. If any cells fill with ####, widen the column they are in. 18 Rename the worksheet Tab 1, change its name to Swag Shop and change t he tab color to match the previous fill color and font color choice earlier. All this formatting of the worksheet tab can be completed by right clicking on the Sheet Tab itself. 19 Create a Header on the worksheet that has your full name in left section, the sheet tab name in the center section and the file name in the right section. Use Header/Footer Elements to insert the sheet name and the file name, do not type in yourself. Page 3 of 3 Step Instructions 20 Look over the worksheet. Save and Close. Do not submit until you are rea dy for the file to be graded. Submit in Blackboard for grading by clicking on the link Excel Module 1 Assignment, Browse Local Files, click on your file, click Open, once you see attached, click Submit.