IDNLearn.com makes it easy to find precise answers to your specific questions. Whether your question is simple or complex, our community is here to provide detailed and trustworthy answers quickly and effectively.

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

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

A. [tex]$=\operatorname{Min}()$[/tex]
B. [tex]$=$[/tex] Smallest()
C. =Bottom()
D. =Lowest()
E. =Floor()


Sagot :

To determine which function returns the value in Cell C77 based on the values in Cells B77:B81, let's break down the problem step by step:

### Step-by-Step Solution

1. Identify the values in Cell B77 through B81:
- B77: \[tex]$794 - B78: \$[/tex]721
- B79: \[tex]$854 - B80: \$[/tex]912
- B81: \[tex]$1,020 2. Identify the value in Cell C77: - C77: \$[/tex]721

3. Evaluate what Cell C77 represents:
- The value in Cell C77 (\$721) is the smallest value among the values in the range B77:B81.

4. Determine which function can automatically return the smallest value from a specified range:
- The function that finds the smallest value in a range of cells is typically called `MIN()` in many spreadsheet software applications.

5. Analyze the options provided:
- `=MIN()`: This function returns the smallest value in a specific range of cells.
- `=SMALLEST()`: This function is usually used with an additional argument to return the nth smallest value in the range.
- `=BOTTOM()`: This is not a standard function in typical spreadsheets.
- `=LOWEST()`: This is also not a standard function in typical spreadsheets.
- `=FLOOR()`: This function rounds a number down to the nearest multiple of a specified significance, but it does not find the smallest value in a range.

6. Select the correct function:
- Based on the analysis, `=MIN()` is the function that returns the smallest value among Cells B77:B81.

Therefore, the function that can automatically return the value in Cell C77 is `=MIN()`.

Thus, the choice corresponding to selecting the function `=MIN()` is the correct answer.