what will cell contain if A1 B1 C1 D1 contains 18, - 8,60 ,- 4 respectively if in cell E1 formula is written =MIN(A1:D1)
Answers
Answered by
1
the least value or minimum among this ie -4
riti7272:
and what will the ans if the formula is =COUNT(A1:D1)
plzz tel if u know this .!
it counts how many number have been entered in the range. in your case its 4
thanku..
that means i have done Correct in exam.!
great
thanku..!
Answered by
1
(-8) 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 -8 is the minimum value. Hence -8 is the answer.
Learn More :
- MS-Excel Sheet :brainly.in/question/11921439
Similar questions