QQuestionAnatomy and Physiology
QuestionAnatomy and Physiology
Based on the values in Cells B^77:B^81, which function can automatically return the value in Cell C^77?
| 76 | Sales | |
| --- | --- | --- |
| 77 | $\$ 1$ | $\$ 1$ |
| 78 | $\$ 1$ | |
| 79 | $\$ 1$ | |
| 80 | $\$ 1$ | |
| 81 | $\$ 1,1$ | |
# 0
Image not displaying?
| $=$ Lowest() | |
| --- | --- |
| (0) $=$ Min() | |
| $=$ Floor() | |
| $=$ Smallest() | |
| $=$ Bottom() | |
Attachments
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 function that returns the smallest value in a range.
The problem asks for a function that can automatically return the value in Cell C^77, which is the lowest value in the given range (B^77:B^81). Among the given options, the "Min()" function is used to find the smallest number in a given range.
Step 2: Apply the "Min()" function to the range (B^77:B^81).
To find the smallest value in the range (B^77:B^81), we need to apply the "Min()" function as follows: \text{Min}(B^77:B^81)
Final Answer
Applying the "Min()" function to the range (B^77:B^81) returns the smallest value, which is $721.
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