Question

The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and
–35, respectively. What will be the value displayed in cell
E1 which contains the formula =MIN(A1:D1).

Answer 1

Answer:

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

Step-by-step explanation:

Answer 2

Answer:

–40 is your answer. ccomputer