The contents of cell A1 ,B1,C1,and D1 are 5,-25,20 and -35,respectively .What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1)
Answers
Answered by
6
Answer:
-35 as it is the lowest value
Answered by
5
(-35) is the correct answer which is enters on the cell E1.
Explanation:
- The min function is used in the excel sheet or spreadsheet to find the minimum value on the behalf of some cell data which is passed on the argument of the min function.
- The syntax of the min function is "MIN(first_cell,Second_cell,third_cell)" or MIN(firstcell:lastcell).
- So the above question holds the argument which is used to check the minimum value from A1, B1, C1, and D1, in which -35 is the minimum value. Hence -35 is the answer.
Learn More :
- MS-Excel Sheet :brainly.in/question/11921439
Similar questions