Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Explain the various techniques of training and development.

Answered: 1 week ago