Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the 2 questions below. I have no idea how to do them so if you could explain or attatch screenshots that

I need help with the 2 questions below. I have no idea how to do them so if you could explain or attatch screenshots that would be greatly apprectiated. Thanks!

1. Create a custom conditional format for the range E2:E103 using the 4 Traffic Lights icon set (Black, Red, Yellow, Green). Edit the rule so that the red icon displays when the number value is greater than or equal to 1000; the yellow icon displays when the number value is less than 1000 and greater than or equal to 500; the green icon displays when the number value is less than 500 and greater than or equal to 250; and the black icon displays when the value is less than 250. Be sure to change the Type to Number before setting the rule for each icon.

2. Filter the table by the Red Traffic Light conditional formatting icon.

image text in transcribed

90% Layout Tables Charts SmartArt Formulas Data Review A Home Alignment Number Calibri (Body) 11 Wrap Text General Conditional Clear Paste Formatting 106 a 74,250 66 Fiona Limited Edition Print Sep-07 67 The Blind Leading the Blind Limited Edition Print 450 May-07 S 165 umited Awaiability 74.250 68 Angels of My village Limited Edition Print 650 Jan-o 165 LimitedAvailability S 107.250 69 Men and Aneels Mar 06 70 The Listener Limited Edition Print 195 Limited Avalabil Cecelia Limited Edition Print 350 Sep 06 S 155 Yes dS 68.250 71 450 May-05 65,250 The Bride Limited Edition Print 73 Saint with White Sleeves Limited Edition Print 550 Mar-05 S 150 Limited Avalability dS 82.500 88,000 74 Twilight Limited Edition Print 160 Limited Avalabil 7S Poofy Guy on a Short Leash Limited Edition Print 650 Aug-04 S 160 umited Awaiability IS 104,000 The Messenger Limited Edition Print 200 Jun 04 ms S 155.000 Limited Edition Print 650 lan-04 S 140 umited Awalability IS 91.000 St Brendan The Navigator 78 Babel Limited Edition Print 79 We Three Kings Limited Edition Print 950 Sep 03 S 160 Limited Avalability dS 152.000 80 Portrait with Red Berries 74,250 Limited Edition Print Jun-03 81 Touching the Hem of God Limited Edition Print 750 Mar-03 S Yes dS 1387s0 550 Jan-03 s 135 Yes 82 Sleeper Lost in Dreams Limited Edition Print 83 Ten Lepers Sep-02 84 Faith, Hope and Charity Limited Edition Print JuH02 101.750 85 Garden Rende 86 Monarch of All He surveys 87 Benediction Jul.10 99s Limited Availability 74.6.25 88 Parables Dec 09 995 Limited Awailability 89 The Royal Processional Jan-05 1.250 Yes 90 Once Upon a Time Mar-04 1,750 Yes 91 Arise and Shine Forth Mar 12 92 Shakespearean Fantasy May 11 Masterwork Canvas Edition 93 The Return of the Fa 94 A Place of Her Own 95 Cecelia 96 Faith, Hope and Charity 97 Man Taking a Leek on a Tiled Wall for a Walk 98 Pierim Angel Oct 10 IS IS 96, 250 99 Plates Smalwark Canvas Edition 100 Tempus Fugit Apr-10 Smal work Canvas Edition 195 Limited Availability 101 Angel Unobserved Smalwork canvas Edition Mar 10 2s Yes IS 78.750 102 Finding Your Fish Oct-09 Smal work Canvas Edition 375 225 103 F Rose Smalwark Canvas Edition 2Sol Apr 09 193 Yes IS 8,750 104 Largest Edition Sre and HIEhest IssuePrice 1820 Jan-02 105 Analysis for Most Expensive Art 1.What was the largest issue size? 107 2. How many pie eces are some sort of Masterwork"? 108 3. How many pieces are not sold out? 4. Which piece had the highest price? 110 5. What type of art was the highest issue price piece? Format Neutra

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

Database Marketing The New Profit Frontier

Authors: Ed Burnett

1st Edition

0964535629, 978-0964535626

More Books

Students also viewed these Databases questions

Question

What are the steps in the T&D process?

Answered: 1 week ago

Question

=+Describe an important trade-off you recently faced

Answered: 1 week ago