Table of Contents
Answer :
None of the options provided will return the value in Cell C77 based on the values in B77:B81. Instead, use the formula =C77 to directly reference the value in Cell C77.
76 Sales
77 $794
78 $721
79 $854
80 $912
81 $1,020
A. =Highest()
B. =Top()
C. =Max()
D. =Biggest()
E. =Ceiling()
Explanation:
To automatically return the value in Cell C77 based on the values in Cells B77:B81, you can use the** =Max() function. **None of the given options will automatically return the value in Cell C77 based on the values in Cells B77:B81. Excel functions such as =Highest(), =Top(), =Max(), =Biggest(), and =Ceiling() do not directly link cells in this manner. If you want to return the value in C77 regardless of the values in B77:B81, you can simply reference the cell directly in your formula as =C77.