On the ''Prices'' worksheet, in the ''inventory Notice'' column, use a function to display ''Low'' if the '' inventory Level % is below 15%. Otherwise, leave the ''Inventory Notice'' blank.
Check the Solution below.

Correct Answer:

=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
Topic 3, Class ScheduleCase Study
Exhibit.

Comment: *

Name: *

Email: *

Verification: *

You are revising a sales summary report for Northwind Traders.
On the ''Summary'' worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ''$5,000,000.'' Check the Solution below.

Correct Answer:

Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.

Comment: *

Name: *

Email: *

Verification: *

On the 'Comparison' chart sheet, swap the data the axis.
Check the Solution below.

Comment: *

Name: *

Email: *

Verification: *

On the 'Enrolment Summary'' worksheet, name the range A3:B7 ''Enrollment'', Check the Solution below.

Comment: *

Name: *

Email: *

Verification: *

On the ''Inventory' chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.
Check the Solution below.

Comment: *

Name: *

Email: *

Verification: *