Homework SourseThe following data is entered in the cells of an Excel sheet
The following data is entered in the cells of an Excel sheet ranging from L1 to L5: 16,9,11,15,12. What will be the output of the following function?
=SUMIF(L1:L5,\">12\")
A. 11
B. 15
C. 18
D. 27
E. 31
The following data is entered in the cells of an Excel sheet ranging from L1 to L5: 16,9,11,15,12. What will be the output of the following function?
=SUMIF(L1:L5,\">12\")
A. 11
B. 15
C. 18
D. 27
E. 31
The following data is entered in the cells of an Excel sheet ranging from L1 to L5: 16,9,11,15,12. What will be the output of the following function?
=SUMIF(L1:L5,\">12\")
A. 11
B. 15
C. 18
D. 27
E. 31
Solution
Putting in the entries at L1 to L5, then typing on any other empty cell
=SUMIF(L1:L5,\">12\")
It gives out
OPTION E: 31 [ANSWER]
