Excel:

Hello,

I got stuck in step 8, can you help me from step 8 to 12. Thank you

A B D E F 1 Kitchen and Cookware Emporium End-Year Inventory w N 3 4 Product On-Hand Retail Cost 5 Baking Set 12. 144.99 6 Marble Pastry Board 6 39.90 7 Rolling Pin 12" 251 17.00 8 Rolling Pin 10" 18 11.00 9 Measuring Cups 151 24.95 10 Nonstick Cookware Sel 8 249.89 11 Saut Pan, 5 qt. 21 69.80 12 Casserole, 6 qt. 4 49.99 13 Bakers Dish, 12" x 9" 27 59.95 Change Total 1.25 What if? 156.99 45.90 42.00 29.00 39.95 257.89 90.80 53.99 86.95 2 4 Step 2: Add the worksheet title Kitchen and Cookware Emporium End-Year Inventory. Step 3: Use the font Century Gothic, size 14, then merge and center the title over all of the column labels. Step 4: Change the font for the rest of the spreadsheet to Century Schoolbook, size 11. Step 5: Bold, center, and italicize all the column labels. Step 6: Create a formula to calculate the Total column. Step 7: Format the Retail Cost and Total columns using comma style with two decimal places. Step 8: Using an absolute reference enter a formula in the What if? column that reflects a 25-percent price increase on the Retail Cost for each item sold. Step 9: Format the What if? column so that it displays the Accounting Number format with two decimal places. Step 10: Apply conditional formatting so that any On-Hand value that is greater than 20 appears with yellow fill with a dark yellow text. Step 11: Check the spelling in the worksheet and make sure all columns are wide enough to display all the data and labels. Step 12: Enter your name in the Header that shows: Your name in the left margin and the filename in the right margin