Question

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)​

Answer 1

(-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