Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the correct formula? begin{tabular}{|c|cc|} hline Date & Humidity % & Rating hline 10 -Jun-22 & 15 & Low hline 11 Jun-22

image text in transcribed

image text in transcribed

What is the correct formula?

\begin{tabular}{|c|cc|} \hline Date & Humidity % & Rating \\ \hline 10 -Jun-22 & 15 & "Low" \\ \hline 11 Jun-22 & 25 & \\ \hline 12 -Jun-22 & 70 & \\ \hline 13 Jun-22 & 20 & \\ \hline 14 Jun-22 & 90 & High \\ \hline 15Jun22 & 50 & \\ \hline 16 -Jun-22 & 85 & High \\ \hline 17 Jun-22 & 10 & \\ \hline 18 -Jun-22 & 75 & High \\ \hline 19 Jun-22 & 13 & \\ \hline 20 -Jun-22 & 55 & \\ \hline 21 Jun-22 & 30 & \\ \hline \end{tabular} 6. In cell C10, create a nested IF to determine the humidity rating for each of the given days. Use the criteria given below to determine the rating. (hint: this nested IF requires only two IF functions, you will want the most efficient formula to receive maximum points) - If the humidity is 75 or greater, then the cell value should be set to "High". - If the humidity is 25 or less, then the cell value should be set to "Low". - If the humidity is between 25 and 75 , then the cell value should be set to "Moderate". 7. Use the fill handle to complete the remaining values C11:C21. Use the fill options button to fill without formatting

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 Finance questions