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
8
(-35) is the correct answer which is enters on the cell E1.
Explanation:
- The MIN() function is a predefined function that is used in the spreadsheet to extract the minimum information from the argument which is passed on this function.
- The above question states some value for column A1, B1, C1, and D1 and there is a min formula for the cell E1 which takes the value of A1, B1, C1 and D1 as an argument.
- Then the cell E1 holds the value "-31" because it is a minimum value from A1, B1, C1, and D1.
Learn More:
MS-Excel Sheet : brainly.in/question/11921439
Similar questions