Based on the Values in Cells B77:B81, Which Function Can Automatically Return the Value in Cell C77?

University:

Unit No:
Level: High school
Pages: 1 / Words 159
Paper Type: Assignment
Course Code:
Downloads: 67729

Brief :

based on the values in cells b77 b81 what function can automatically return the value in cell c77

A. =Floor)
B. =Smallest
C. =Lowest
D. =Bottom
E. =Min()

Answer

E. =Min()

Based on the values in cells b77: b81, the right answer to this question is in Min(), and it will reappear in cell c77. The min() function in excel, is used to find the lowest number in the range of values. So, as we know, c77 includes the lowest value in this sheet, and to make it reappear, we need to use a min function, as it can draw out the minimum value. But, in the case of string values, this function conducts an alphabetic comparison.

Download Full Answer

Often times, students feel unable to work on assignments and think, “Who will do my assignment?” By providing "Sample" on various subjects, we are trying to help them understand all the intricacies of writing. We have the most qualified and skilled assignment writers who can provide the best assignment writing services, essay writing services, dissertation writing services, and more at the most affordable rates. Place your order now for surprising discounts.