Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

41. Please refer to the following screenshot. The prices of the goods in Column A that are higher than the average price for all products

image text in transcribed

41. Please refer to the following screenshot. The prices of the goods in Column A that are higher than the average price for all products are highlighted in red in the table. How do you achieve this without first calculating the average? A 1 Product 2 Cookie 3 Muffin 4 Biscuit 5 Brownie 6 Cake 7 Pie B Price $6 $5 $3 $7 $15 $9 in "Conditional Formatting," choose "Highlight Cells Rules," then choose "Greater Than," and enter *EAVERAGE(B2:B7) as the reference in "Conditional Formatting," choose "Highlight Cells Rules," then choose "Greater Than," and enter ==MEAN(B2:37)" as the reference in "Conditional Formatting," choose "Top/Bottom Rules," then choose "Greater Than," and enter *EAVERAGE(B2:B7) as the reference in "Conditional Formatting," choose "Top/Bottom Rules," then choose "Above Average

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_2

Step: 3

blur-text-image_3

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

Sales Management Demystified A Self Teaching Guide

Authors: Robert Calvin

1st Edition

0071486542, 9780071486545

More Books

Students also viewed these Finance questions

Question

Describe the characteristics associated with qualitative study.

Answered: 1 week ago

Question

6. Discuss transcultural delegation.

Answered: 1 week ago