Consider the following snapshot of MS-Excel worksheet:
|
|
A |
B |
C |
D |
|
1 |
Roll Number |
Marks Test - 1 |
Marks Test - 2 |
Total Marks |
|
2 |
101 |
80 |
60 |
140 |
|
3 |
102 |
40 |
50 |
120 |
|
4 |
103 |
70 |
30 |
70 |
|
5 |
104 |
30 |
32 |
62 |
|
6 |
105 |
85 |
85 |
170 |
|
7 |
106 |
65 |
80 |
145 |
|
8 |
107 |
72 |
96 |
168 |
|
9 |
108 |
25 |
32 |
57 |
|
10 |
109 |
90 |
78 |
168 |
|
11 |
110 |
25 |
40 |
65 |
|
12 |
|
|
|
The formula = IF (B10 + C10 >100, IF (D10 > 100, "A", "B"), "C") in cell D12 will result in _______
1
A
2
B
3
C
4
AC