Question discussion

In a spreadsheet, cell A1 contains 40, A2 contains 60 and A3 contains the formula =A1+A2*2. Cell B1 contains =IF(A3>A1+A2, MAX(A1:A3)-MIN(A…

2758Hard UPSC Principal Vice Principal 0 replies 1 views

In a spreadsheet, cell A1 contains 40, A2 contains 60 and A3 contains the formula =A1+A2*2. Cell B1 contains =IF(A3>A1+A2, MAX(A1:A3)-MIN(A1:A3), 0). What is the value displayed in B1?

A0
B100
C120
D160

Correct answer: C

Explanation

A3 = 40 + 60 × 2 = 160. As 160 > 100, B1 = MAX(40,60,160) - MIN(40,60,160) = 160 - 40 = 120.

Join the discussion Report an error

Discussion 0

Nobody has replied yet. Start the discussion!