Excel project. You must follow the instructions file.

Place your order today and enjoy professional academic writing services—From simple class assignments to dissertations. Give us a chance to impress you.


Order a Similar Paper Order a Different Paper

Excel project. You must follow the instructions file.

Excel project. You must follow the instructions file.
Hargrove Home Improvement Formatting a Worksheet GETTING STARTED Open the file IL_EX19_EOM2-1_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as IL_EX19_EOM2-1_FirstLastName_2.xlsx by changing the “1” to a “2”. If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file IL_EX19_EOM2-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. 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 4 cell style to cell A1 to match the formatting used in cell A2. Merge and center the range A1:F1. Use AutoFit to resize column A to fit its contents. Fill the range A3:F3 with Green, Accent 1, Lighter 60% shading to separate the column headings from the data. Use the Format Painter to apply the format from the range A11:F11 to the range A13:F13 to create consistent shading and borders in the worksheet. Italicize the contents of the range A4:A14 to separate the plant names from the rest of the data. In the range A3:F14, apply an Outside Border to the cells in the default color to clarify that the data in the range belongs together. In the range G1:H1, change the font color to Black, Text 1, Lighter 35% to de-emphasize the text. In the range B4:B14 (the Price Paid amounts), apply the Comma format with two decimal places to display the complete values. In the range F4:F14 (the Sale Value amounts), apply the Accounting format to indicate the values are prices. Jayden wants to emphasize On Hand amounts less than 15 so the store knows when to order more plants. In the range D4:D14 (the On Hand values), use Conditional Formatting Highlight Cells Rules to format cells whose contents are less than 15 with Yellow Fill with Dark Yellow Text. Add the 3 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 SAM website to submit your completed project. Final Figure 1: Inventory Worksheet

Writerbay.net

When writing your assignment, we aim to help you get an A, not just beat the deadline.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now


Order a Similar Paper Order a Different Paper