QQuestionMicrosoft Office User Specialist
QuestionMicrosoft Office User Specialist
"Based on the values in Cells B^77:B^81, which function can automatically return the value in Cell C^77?
A. =Lowest
B. =Min
C. =Floor
D. =Smallest
E. =Bottom"
6 months agoReport content
Answer
Full Solution Locked
Sign in to view the complete step-by-step solution and unlock all study resources.
Step 1: Identify the appropriate function to return the lowest value in a range.
The given options include functions that can be used to find the smallest value in a dataset. An appropriate function for this task is either "=Min" or "=Smallest". However, since "=Smallest" is not a standard Excel function, we will consider "=Min" as the correct answer.
Step 2: Verify the correct usage of the "=Min" function.
To ensure that the "=Min" function is used correctly, it should be formatted as "=Min(2$)". In this case, the range includes Cells B^77:B^81. Therefore, the function should be written as "=Min(2$)".
Final Answer
The correct function to automatically return the value in Cell C^77 based on the values in Cells B^77:B^81 is "=Min(2$)".
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