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). — 35 plzz give correct answer and explain also​

Answer 1

Answer:

I think the easiest way to understand it is to start with a very basic example...

Say you have dates 3/15/15, 3/16/15, and 3/17/15 in cells a1 a2 and a3 respectively..

Then in column b you have sales volumes of 50,60,and 70 units in row 1,2,3 respectively and in column c you have sales price of $10, $11, and $12 respectively..

Now in column d you can calculate revenue by selecting cells d1 through d3 (all three cells at the same time) and typing the formula =B1:B3*C1:C3 and pressing ctrl+shift+enter. What this does is treats each section (ie your b and c cells) of your multiplication formula as an array (or group of cells) and gives you seperate results for each cell row in the corresponding cell of the array you entered the formulas into.

Explanation: