What will be the result of the formula =Min (Average (B1, B2), Product (B3 : B4) where value of B1 = 20, B2 = 24, B3 = 15, B4 = 20?
Solution
Correct Answer: Option B
Let's break down the formula step by step:
1. `Average(B1, B2)` is the average of B1 and B2, which is `(20 + 24) / 2 = 44 / 2 = 22`.
2. `Product(B3:B4)` is the product of the values in cells B3 and B4, which is `15 * 20 = 300`.
3. Finally, `Min(Average(B1, B2), Product(B3:B4))` takes the minimum value between the results of the two previous calculations: `Min(22, 300)`.
The minimum value between 22 and 300 is 22. So, the result of the formula is B) 22.
1. `Average(B1, B2)` is the average of B1 and B2, which is `(20 + 24) / 2 = 44 / 2 = 22`.
2. `Product(B3:B4)` is the product of the values in cells B3 and B4, which is `15 * 20 = 300`.
3. Finally, `Min(Average(B1, B2), Product(B3:B4))` takes the minimum value between the results of the two previous calculations: `Min(22, 300)`.
The minimum value between 22 and 300 is 22. So, the result of the formula is B) 22.
Practice More Questions on Our App!
Download our app for free and access thousands of MCQ questions with detailed solutions