Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Modify the conditional formatting rule you applied in the previous step as follows: a Green Circle icon of type Number is displayed for values greater

Modify the conditional formatting rule you applied in the previous step as follows:
a Green Circle icon of type Number is displayed for values greater than or equal to 0.8(representing 80%). Note: Set the type box to Number before setting the values for the icons, just like you did in the learning activity.
a Gray Circle icon of type Number is displayed for values less than 0.8 and greater than or equal to 0.6(60%). Do not confuse gray with black - make use of the tool tips to help you.
a Yellow Circle icon is displayed for values less than 0.6 and greater than or equal to 0.5(50%).
a Red Circle With Border icon is displayed for values less than 0.5.
When done you should see that grades less than 50% have a red stop light icon, grades in the 50s have a yellow stop light icon, grades greater than or equal to 60 and less than 80 have a gray stop light icon, and grades 80 and above have a green stop light icon.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+31-6 Describe our short-term and working memory capacity.

Answered: 1 week ago