The following data is entered in the cells of an Excel sheet ranging from L1 to
ID: 3022631 • Letter: T
Question
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. 31The 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
Explanation / Answer
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]
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.