QQuestion
Question
Based on the values in Cells B^77:B^81, what function can automatically return the value in Cell C^77?
76 Sales
77 $794
78 $721
79 $854
80 $912
81 $1,020
A. =Highest()
B. =Top()
C. =Max()
D. =Biggest()
E. =Ceiling()
6 months agoReport content
Answer
Full Solution Locked
Sign in to view the complete step-by-step solution and unlock all study resources.
Step 1I'll solve this step by step:
Step 2: Identify the Problem
The problem requires determining which Excel function will return the highest value from the range of sales figures in Cells B^77:B^81.
Final Answer
Key Insights: - =Max() is the standard Excel function for finding the highest value in a range - It works with both numbers and cell references - In this case, it would return 1,020 from the given sales figures
Need Help with Homework?
Stuck on a difficult problem? We've got you covered:
- Post your question or upload an image
- Get instant step-by-step solutions
- Learn from our AI and community of students
Related Questions
No related questions found