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.
Range from B1 to B7 = 7,5,7,3,7,8,7
Range from C1 to C7 = 8,6,11,8,4,3,9
If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is
A. 12
B. 28
C. 32
D. 39
E. 45
The following data is entered in the cells of an Excel sheet.
Range from B1 to B7 = 7,5,7,3,7,8,7
Range from C1 to C7 = 8,6,11,8,4,3,9
If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is
A. 12
B. 28
C. 32
D. 39
E. 45
Range from B1 to B7 = 7,5,7,3,7,8,7
Range from C1 to C7 = 8,6,11,8,4,3,9
Range from C1 to C7 = 8,6,11,8,4,3,9
If the value in the cell D9 is 7, the output of the function =SUMIF(B1:B7, D9,C1:C7) is
A. 12
B. 28
C. 32
D. 39
E. 45
Solution
We do the process. We put in the entries from B1 to B7 and C1 to C7, and at D9.
Then we type =SUMIF(B1:B7, D9,C1:C7) to get
OPTION C: 32 [ANSWER]
