Answered step by step
Verified Expert Solution
Question
1 Approved Answer
11. Apply Aqua, Accent 4, Lighter 60% shading to the range A2:B3 to separate the range from the rest of the worksheet. 12. To format
11. Apply Aqua, Accent 4, Lighter 60% shading to the range A2:B3 to separate the range from the rest of the worksheet. 12. To format the value as a dollar amount, decrease the number of decimal places in the cell containing the "Inventory Value" to 2 . 13. Apply the Accent3 cell style to the range A4:I4 to indicate those cells contain column headings. 14. Apply the Accounting number format to the Cost column and the Inventory value column to show that the values are dollar amounts. 15. Shanice wants to know at a glance which items have the most inventory value. In the Inventory Value column, use conditional formatting to create a Data Bars rule with the Gradient Fill Blue Data Bar color option. 16. Shanice also wants to highlight the items that need to be reordered. In the Reorder column, use conditional formatting Highlight Cells rules to format cells containing a value equal to "Reorder" in Light Red Fill with Dark Red Text. 17. Check the Spelling in the workbook to identify and correct any spelling errors
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started