Which of the following can be done by using conditional formatting?
Calculate quarterly sales.
Highlight all “no” responses.
Count the number of students in high school.
Calculate average scores on a math test.

Answers

Answer 1

Answer:

B

Step-by-step explanation:

Which of the following can be done by using conditional formatting?

Calculate quarterly sales.

Highlight all “no” responses.

Count the number of students in high school.

Calculate average scores on a math test.

Conditional formatting applies formatting to cells if specific conditions are met. For example, conditional formatting can be used to apply background color to “no” responses in a customer satisfaction survey. This will allow the business owner to quickly locate and read customer complaints and identify areas for improvement.

Answer 2

Conditional formatting involves applying cell formats to certain cells, if and only if they meet certain criteria.

Highlighting all "no" responses can be done using conditional formatting.

Options (a), (c) and (d) are all direct calculations that can be executed using Microsoft Excel functions and formulas such as:

SUM; to calculate quarterly sales (a)COUNT, to count number of students (c)AVERAGE, to calculate the average score (d)

However, option (b) indicates that;

The cell is to be highlighted

And the condition for highlighting the cell is that:

The content of the cell is "no"

By comparing the above analysis to the meaning of conditional formatting, we can conclude that, conditional formatting can only be applies to option (b).

Read more about conditional formatting at:

https://brainly.com/question/22754240


Related Questions

PLEASE HELP WILL BE MARK BRAINLIEST!

Answers

The reflection over the x axis is (-3,-2) :)

Blueberries cost $1.78 per pound. What is the cost of 1.05 pounds of blueberries? Round your answer to the hundredths. You will not grid the dollar sign.

Answers

Answer:

Approximately $1.87 ($1.869)

Step-by-step explanation:

There are 2 ways to do it

1.78 x 1.05 = 1.869 / $1.87

Or

1.78 x .05 = .089

1.78 + .089 = 1.869 / $1.87

PLEASE HELP if you can

Answers

The equation y--4=-2(x--1)

Write the equation of the line in fully simplified slope-intercept form.

Answers

Answer:

free

Step-by-step explanation:

25 POINTS PLEASE HELP!

Answers

Step-by-step explanation:

I think this is it :

For the schones a) 16,16 is double 8 so whatever the ingredients double them!

So it will be: 400g flour

60g caster sugar.... And so on

B) 4 is half 8, so whatever the ingredients half them

Flour = 100g

Sugar = 15g..... And so on

C) 24 is three time 8, so all ingredients triple them

Flour= 600g

Sugar = 90g...and so on

D) 40 is five times 8 so all ingredients multiply by 5

Flour= 1,000 g

Sugar= 150g.... And so on

E) 80 is 10 times 8

So multiply by 10

Flour = 2,000g

Sugar = 300g... And so on

F) 2 is one by fourth of 8

So, flour = 50g

Sugar = 7.5g

For ice-cream:

A) 8 is double 4 so whatever ingredient double

Double cream= 600ml

Milk= 640ml and so on

B) 2 is half 4 so make ingredients half

Double cream = 150ml

Milk = 160ml

C) here because it's only one person

U will divide all the ingredients by 4

So double cream = 300/4 =75ml

Milk = 320/4 = 80ml

So on...

D) for 3 people we will use bit c

For 3 people = double cream= 75x3= 225

Milk = 80x3 = 240ml

And so on

E) so for(c), we found for one person now we can easily use that and find this

Now for 6 people

For person, as we saw, = 75ml

For 6 people double cream = 75x6= 450ml

And for milk for 1 person = 80ml

For 6 people = 80x6= 480ml

And so on

F) 10 people

Double cream = 75ml x 10 = 750ml

Milk = 80ml x 10 = 800ml

For fish pie,

A) 15 is three times 5 so we will multiply 5 to each ingredient

Cod= 1500g

Haddock = 1200g and so one

B) for 1 person we will also divide each ingredient by 5 = Cod = 500÷5 = 100g

Haddock = 400÷5 = 80g and so one

C) we will use bit b for this too

Cod = 100 x 2 = 200g

Haddock = 80g x 2 = 160g and so on

D) 4 people

Cod= 100g x 4 = 400g

Haddock = 80 x 4 = 320g and so on

E) 8 people

Cod = 100 x 8 = 800g

Haddock = 80 x 8 = 640g and so on

F) 11 people

Cod = 100 x 11 = 1100g

Haddock = 80 x 11 = 880g

And so on

I hoooope this helps

I finallyyyyy got it

how do i solve this?

Answers

Answer:

y = 6

Step-by-step explanation:

You solve by using the pythagorean theorem, which is:

[tex]a^{2} +b^{2} =c^{2}[/tex]

Where a and b are legs of the triangle, and c is the hypotenuse, or y in this case. So let's rearrange this equation for c:

[tex]c=\sqrt{a^{2} +b^{2} }[/tex]

Now, we can substitute in the known values and solve:

[tex]c=\sqrt{3.6^{2} +4.8^{2} } = \sqrt{36} = 6[/tex]

Therefore, the value of y is 6

Hope this helps!

Cans someone please help me with this question

Answers

Answer:

domain: -2,-3, -1, 0, 1, 2

range: -2, -1, 0, 1, 2, 3

domain is the x value, range is for the y values

in this case, this isn't a line, it's just a line plot, so you just list the coordinates of where each point is for x and y.

£220 is invested at 3% pa simple work out the interest for 8 years.

Answers

Answer:

The answer is £52.8

Step-by-step explanation:

250 is equal to the ratio ____ to 100​

Answers

Answer:

25

Step-by-step explanation:

if you look at it, 250 is 1/4 of 1000 and 100 is 1/10 of 1000 so divide 250 by 10 and you get your answer.

What is the equation for the line graphed below?

Answers

Answer:

[tex] \boxed{y = - \frac{3}{4} x + 4}[/tex]

Step-by-step explanation:

The graph decreases. That meand the slope is in negative.

[tex]y = mx + b[/tex]

where m = slope and b = y-intercept. If the slope is positive, the graph will increase. Otherwise, decrease.

The only choice that the slope is negative is the third choice.


B- Y= - 3/4 x + 4
Your welcome!!

Hey! A step by step explanation on this would be great! Thanks!
(25 Points)

Answers

Step-by-step explanation:

We find the stationary point of (20 + 2x)(1200 - 60x),

where x is the unit rate of increase/decrease.

d/dx [(20 + 2x)(1200 - 60x)]

= d/dx (-120x² + 1200x + 24000)

= -240x + 1200.

When d/dx [(20 + 2x)(1200 - 60x)] = 0,

We have -240x + 1200 = 0. => x = 5.

Price per shirt that maximise revenue

= $20 + $2x = $20 + $2(5) = $30.

Maximum revenue

= (20 + 2(5))(1200 - 60(5))

= $30 * 900 = $27,000.

Can you please help me I really need it to

Answers

Answer:

red: 13/33

yellow: 12/33

blue: 8/33

Step-by-step explanation:

Add together all of the values to find the total amount of sections (13+12+8=33) --> this will be your denominator

From there, each time you make the numerator the number of that color, which gives you:

red: 13/33

yellow: 12/33

blue: 8/33

I hope this helps!

Answer:

The probability of landing on red is 13/33, the probability of landing on yellow is 12/33, and the probability of landing on blue is 8/33.

Step-by-step explanation:

Everything is just a fraction, so just add all the numbers for your denominator, and put the other number for red yellow or blue as the numerator then simplify the fraction

I need help. Please help me, thxs.

Answers

Answer:

50 years.

Step-by-step explanation:

Hope this helps!

which set or sets does the number 5.6 belong?

im givng 29 points .-.

Answers

Step-by-step explanation:

Integers only

b

Rational numbers only

c

Integers and Rational numbers only

d

Whole numbers, Integers, and Rational numbers

A new set of apple airpods cost $250 calculate the new price if you got a 20% discount and the sales tax 8%​

Answers

Answer:

$216

Step-by-step explanation

We know that we are paying 80% of the price of the airpods (20% off) so we can multiply the full price by 0.8.

250 * 0.8

This will give us 200.

Now, we need to add the sales tax which is 8%.

Simply multiply the 200 by 1.08 since we are paying the 200$ plus an extra 8% of the cost.

200 * 1.08 = $216

I hope this helped.

-6(x-2) show work (Simplfy)

Answers

Answer:

−6x+12

Step-by-step explanation:

Expand by distributing terms.

-6x-6\times -2

−6x−6×−2

2 Simplify  6\times -26×−2  to  -12−12.

-6x-(-12)

−6x−(−12)

3 Remove parentheses.

-6x+12

−6x+12

4x+5y=13,3x+2y=8 in substitution method​

Answers

answer: x= 2,y=1

hope i helped you :0

X= 5.20625 Y= -2.565

all real numbers that are greater than 6 and less than 10

Answers

Answer:

I didnt know that and now that I do idc caus math is well y'know math -_-

Answer: 7,8,9

Step-by-step explanation: all the numbers between 6 and 10

8x+11-6x+5
Your answer

Answers

Answer:

2x +16

Step-by-step explanation:

group them by similar variables

8x-6x. 11+5

2x+16

Answer:

2x+16

Step-by-step explanation:

combine like terms

8x-6x+11+5

8x-6x=2x

2x+11+5

11+5=16

2x+16

Find the line's slope and a point on the line.
y-4=
= (x + 5)

Answers

Answer:

y=x+9

Step-by-step explanation:

First, remove the parentheses.

Write in slope-intercept form. (y=mx+b)

What is the slope of the line?

Answers

4/3 USE THE FORMULA TO GET YOUR ANSWER

Write the equation so that y is a function of x. 5x + 4y - 7 = 5

Answers

Answer:\

Step-by-step explanation:

A Store charfes $0.20 per pound plus a set fee of $2 for ice.How many pounds of ice would somebody have brought if they paid $15

Answers

Answer:

65 pounds of ice

Step-by-step explanation:

15-2=13

13/0.2=65

Find f(4).
f(x) = x2 + 2x - 3
A)
5
B)
11
13
D)
21
Elimina

Answers

Answer:D

Step-by-step explanation:

you plug 4 in for x

f(4)=4^2+2(4)-3

=16+8-3

=24-3

=21

Determine the approximate value of angle A.

Answers

Answer: The correct answer is 40 I got this question right.

Which graph shows the solution to the system of linear inequalities below?
y 2x+1
y <-2x-3

A. Graph B
B. Graph A
C. Graph
D. Graph D

Answers

The answer is 2x+1......

Please help on 9 10 11❤️

Answers

10 is the third one hope I helped!

What is f(2) for the function f(x)=3x+8
F(2)=

Answers

Plug in 2 for x
f(2) = 3(2) + 8
f(2) = 6 + 8
Solution: f(2) = 14
The value f(2) is 14

What percent is 680 of 2300?​

Answers

Answer:

29.565217391304%

Step-by-step explanation:

thanks

hope it helps

Solve for x 2x+3=1x+-4

Answers

Answer:

x = -7

Step-by-step explanation:

2x + 3 = 1x + -4

-1x        -1x

1x + 3 = -4

    -3      -3

x = -7

Other Questions
Solve for the value of w.(w-8)(2W-1) One of the tasks that a forensic odontologist might have is to determine the time of death for a bodyTrueFalse Travis and his army believed that the defense of the Alamo was essential to the Texas Revolution because it..(There are no answer choices)(Also please give a short answer) Which of the following statemeants is true about payday loans Conjuguez les verbes entre parentheses aux temps convenables.(6au choix)6 marks pls1. Si vous avez le temps , ________________(attedre)-moi !2. Si M. Paul tait riche, il __________________(pouvoir) acheter une maison.3. Nous ___________________(recevoir) la carte hier.4. Tout le monde m_______________ si je porte ce pantalon noir. ( apprecier)5. Lorsque nous arriverons au cinema , le film _______________( dj commencer)6. Le medcin ma conseill de ______________ (se reposer) bien.7. ________________________(regarder) ces photos, sil te plait.8. Quand javais 10 ans , je _____________________(lire) beaucoup de livres. If a truck loses 5610 J of energy as it slows down due to an external force of 425 N, what distance will it have moved after the force is first applied Numerical fluency1A selection box contains four typesof sweets: 6 caramels, 7 chocolates,4 bonbons and 3 nougatsWhat fraction are carame/sb. What fraction are not caramels? i need help with this question ASAPP X+y=10 what does x equal 16. How did the British Raj come into existence?A. Indian rulers and politicians agreed to let Britain trade in India.B. Britain annexed a large part of India for its empire.C. Indian merchants convinced the British government to invade India.D. Britain borrowed money to purchase land in India. In a lab experiment, the decay of a radioactive isotope is being observed. At the beginning of the first day of the experiment the mass of the substance was 1000 grams and mass was decreasing by 14% per day. Determine the mass of the radioactive sample at the beginning of the 10th day of the experiment. Round to the nearest tenth (if necessary). What are 3 different units of measurement for measuring the amount of space a sample of matter occupies? RIGHT ANSWER GETS BRAINLESTComplete the code.You are writing a loop to allow the user to enter data until they enter a "Q". You want to allow them to enter an upper- or lowercase "Q". if yourTeam. () == "q": breakThe options they give are:UpperComparelower What reactive species is produced in the initiation step of the free radical chlorination of 2,2-dimethylpropane 10 points Print Item 3 As of December 31, Year 2, Moss Company had total cash of $147,000, notes payable of $84,700, and common stock of $51,500. During Year 3, Moss earned $27,000 of cash revenue, paid $15,500 for cash expenses, and paid a $2,100 cash dividend to the stockholders. Required a. Determine the amount of retained earnings as of December 31, Year 2. b. I NEED A NAME FOR THIS QUICK teachers going to collect them at 6:20 which is in like 25 minutes please help me choose a name Dominic has more interest in updating his status on social networks than in calling people or texting. He wants to be able to post about what he is doing every day, along with high-quality photographs and links to the songs he is listening to. Dominic also gets lost on the road pretty easily, so he needs something with a reliable GPS. He will likely carry his phone in a small carrying case that he will buy as an accessory. Which phone should Dominic get? In one paragraph, explain which is the best option for him and why. Use proper spelling and grammar. How many grams are in 4.7 moles of Na2O? What's the correct pattern for -ER verbs?o, as, a, amos, is, ano, es, e, emos is, eno, es, e, imos, s, en Write an equivalent expression to show the relationship of multiplication and addition 6 + 6 + 6