Question

The contents of cell A1,B1,C1and D1 are 10,-20,30,-40 respectively. What will be the value displayed in cell E1 which contains the formula =MIN (A1:D1)

Answer 1

answer - 10
I hope it will help you.

Answer 2

(-40) 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 -40 is the minimum value. Hence -40 is the answer.

Learn More :

• MS-Excel Sheet :brainly.in/question/11921439