Excel 365 2021 Module 2 End of Module Project 1 Hargrove Home Improvement

Описание: For Solution contact us on WhatsApp or Email
WhatsApp: +1 209 345 9376
Email address: [email protected]
Whatsapp link : https://wa.link/t4mgjz


new perspectives excel 2019 module 1 sam project 1a,module 1: end of module project 1,new perspectives excel 2019 | module 1: end of module project 2,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 2: sam project 1a,module 5 sam project 1a,new perspectives excel 2019 module 2 end of module project 1,excel module 8 sam end of module project 1,excel module 8 sam project,module 5: sam project 1a

Project Steps:
1. "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."
Apply a cell style.
Merge and center a range.
2. Use AutoFit to resize column A to fit its contents.
Change the column width.
3. Fill the range A3:F3 with Green, Accent 1, Lighter 60% shading to separate the column headings from the data.
Change the fill color of a cell/range.
4. 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.
Use the Format Painter to copy formatting.
5. Italicize the contents of the range A4:A14 to separate the plant names from the rest of the data.
Change the font style.
6. 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.
Add a border to a range.
7. In the range G1:H1, change the font color to Black, Text 1, Lighter 35% to de-emphasize the text.
Change the font color.
8. In the range B4:B14 (the Price Paid amounts), apply the Comma format with two decimal places to display the complete values.
Change the number format.
9. In the range F4:F14 (the Sale Value amounts), apply the Accounting format to indicate the values are prices.
Change the number format.
10. 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.
Apply a conditional formatting rule.
Format a conditional formatting rule.
Apply a conditional formatting rule.
11. 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.)
Use Spell Check to update cell contents.