You and your friend decided to go to Goa after you finish your finals. however your demanding parents set a couple of conditions to join your friends (see MS-EXCEL spreadsheet below)

A

B

C

D

1

Category of condition

Minimal results needed

Actual results

Allowed (Yes No)?

2

Hours spent on homework weekly

2

3

3

Midterm score

70

68

4

Final exam score

75

77

Imagine your parents ask you to either meet the final exam score condition or both if the two remaining (homework and midterm) conditions. Which of the following formulas A-C can be used in the cell D2 to answer the question: will you be able to join your friends with the results given?

A. = IF (C4 > = B4, "Yes", IF (AND (C2 > = B2, C3 > = B3). "Yes", "No"))

B. = IF (AND (C2 > = B2, C3 > = B3), "Yes", IF (C4 > = B4, " : Yes", "No"))

C. = IF (OR (AND (C2 > = B2, C3 > = B3), C4 > = B4). "Yes", "No")

Choose the correct answer from the options given below:

Question

Question

This question was previously asked in

UGC NET Official Paper 1: Held On 19 June 2023 Shift 2

Answer 1

Key Points

The formula A will return Yes if the final exam score is greater than or equal to 75, and No if it is not. However, it will not check if the homework and midterm scores are also met.
The formula B will first check if the homework and midterm scores are met. If they are, it will return Yes. If they are not, it will check if the final exam score is greater than or equal to 75. If it is, it will return Yes. If it is not, it will return No.
The formula C will first check if the homework and midterm scores are met, or if the final exam score is greater than or equal to 75. If either of these conditions is met, it will return Yes. If neither of these conditions is met, it will return No.

Therefore, the correct formulas are A, B and C.

	A	B	C	D
1	Category of condition	Minimal results needed	Actual results	Allowed (Yes No)?
2	Hours spent on homework weekly	2	3
3	Midterm score	70	68
4	Final exam score	75	77