Question 8 / 15

Based on the values in Cells B77:B81, which function can automatically return the value in Cell C7?

[tex]\[
\begin{array}{|c|c|c|}
\hline
2 & B & C \\
\hline
76 & \text{Sales} & \\
\hline
77 & \$ 794 & \$ 721 \\
\hline
78 & \$ 721 & \\
\hline
79 & \$ 854 & \\
\hline
80 & \$ 912 & \\
\hline
81 & \$ 1,020 & \\
\hline
\end{array}
\][/tex]



Answer :

To solve the question of determining which function can automatically return the value in Cell C7, given the values in cells B77 to B81 in the range B77:B81, follow these steps:

1. Identify the Values in the Specified Range:
- B77: \[tex]$794 - B78: \$[/tex]721
- B79: \[tex]$854 - B80: \$[/tex]912
- B81: \[tex]$1020 2. Understand the Goal: - We need to find the appropriate function that will place a specific value into cell C7 based on these values. 3. Determine the Desired Outcome: - The function is asked to return a specific value. Cell C7 should contain the minimum value from the range B77:B81. 4. Finding the Minimum Value: - From the list of values (\$[/tex]794, \[tex]$721, \$[/tex]854, \[tex]$912, \$[/tex]1020), identify the smallest value.

5. Smallest Value is:
- Among \[tex]$794, \$[/tex]721, \[tex]$854, \$[/tex]912, and \[tex]$1020, the smallest value is \$[/tex]721.

6. The Appropriate Function to Use:
- Excel has a built-in function to determine the minimum value from a set of values. This function is `MIN`.

7. Application of the Function in Excel:
- To automatically place the minimum value from the range B77:B81 into cell C7, use the following function:

```
=MIN(B77:B81)
```

8. Result:
- By using `=MIN(B77:B81)` in cell C7, Excel will compute and display the value \$721.

Thus, the function that can automatically return the value in Cell C7, based on the values in Cells B77:B81, is =MIN(B77:B81).