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

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation