Question: Save the file IL _ EX 3 6 5 _ 2 0 2 1 _ EOM 2 - 1 _ FirstLastName _ 1 . xlsx
Save the file ILEXEOMFirstLastNamexlsx as ILEXEOMFirstLastNamexlsxo Edit the file name by changing to o If you do not see the xlsx file extension, do not type it The file extension will be added for you automatically. With the file ILEXEOMFirstLastNamexlsx open, ensure that your first and last name is displayed in cell B of the Documentation worksheet.o If cell B does not display your name, delete the file and download a new copy. PROJECT STEPS Jayden Keller manages the Lawn and Garden Departments at Hargrove Home Improvement stores throughout the Pacific Northwest. He created an Excel workbook to try and solve a problem at one store that often has too much or too little stock on hand to sell. He has asked you to format the workbook to make the information easier to interpret.Go to the Inventory worksheet. Apply the Heading cell style to cell A to match the formatting used in cell A Merge and center the range A:F Use AutoFit to resize column A to fit its contents Fill the range A:F with Green, Accent Lighter shading to separate the column headings from the data Use the Format Painter to apply the format from the range A:F to the range A:F to create consistent shading and borders in the worksheet Italicize the contents of the range A:A to separate the plant names from the rest of the data In the range A:F apply an Outside Border to the cells in the default color to clarify that the data in the range belongs together In the range G:H change the font color to Black, Text Lighter to deemphasize the text In the range B:Bthe Price Paid amounts apply the Comma format with two decimal places to display the complete values In the range F:Fthe Sale Value amounts apply the Accounting format to indicate the values are prices Jayden wants to emphasize On Hand amounts less than so the store knows when to order more plants. In the range D:Dthe On Hand values use Conditional Formatting Highlight Cells Rules to format cells whose contents are less than with Yellow Fill with Dark Yellow Text. Add the Arrows Colored icon set to the same range to include a visual reminder about when to order more plants Check the Spelling in the workbook to identify and correct any spelling errors. Hint: Ignore plant names. You should find and correct at least one spelling error.Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
