Answered

\begin{tabular}{|l|r|r|}
\hline
& Budget & Actual \\
\hline
\[tex]$ 1,128 & \$[/tex] 1,081 \\
\hline
\end{tabular}

Select the correct formula:

A. =MAX(C3:C12)
B. =MIN(C3:C12)
C. [tex]$=\operatorname{MIN}(B3:B12)$[/tex]
D. [tex]$=\operatorname{MAX}(B3:B12)$[/tex]

Please select the best answer from the choices provided:

A
B
C
D



Answer :

GinnyAnswer
To solve this problem, we need to find the values for the given Budget and Actual amounts and select the appropriate statistical measure based on the given Excel formulas:
- `=MAX(C3:C12)` determines the maximum value from the range C3 to C12.
- `=MIN(C3:C12)` determines the minimum value from the range C3 to C12.
- `=MIN(B3:B12)` determines the minimum value from the range B3 to B12.
- `=MAX(B3:B12)` determines the maximum value from the range B3 to B12.

Given table data:
- Budget: [1128, 0, 0, 0, 0, 0, 0, 0, 0, 0]
- Actual: [1081, 0, 0, 0, 0, 0, 0, 0, 0, 0]

First, we find the maximum and minimum values:
1. For the Budget column (B3:B12):
- MAX(B3:B12): The maximum value in the Budget column is \[tex]$1128. - MIN(B3:B12): The minimum value in the Budget column is \$[/tex]0.

2. For the Actual column (C3:C12):
- MAX(C3:C12): The maximum value in the Actual column is \[tex]$1081. - MIN(C3:C12): The minimum value in the Actual column is \$[/tex]0.

Now, based on the given answers:
- a. =MAX(C3:C12) -> 1081
- b. =MIN(C3:C12) -> 0
- c. =MIN(B3:B12) -> 0
- d. =MAX(B3:B12) -> 1128

The best answer to the question given the options and our calculations is:
c. [tex]\(=\operatorname{MIN}(B3:B12)\)[/tex]

Therefore, the best choice is:
C

Other Questions