The following data is injured in the cells in excel sheet ranging from A1 to A8
ID: 3022629 • Letter: T
Question
The following data is injured in the cells in excel sheet ranging from A1 to A8 have values greater than 8. Which of the following functions would provide the accurate result? A. =SUMIF(A1:A8,8) B. =AVERAGEIFS(A1:A8,">8) C. =AVERAGEIF(A1:A8,8) D. =COUNTIF(A1:A8,">8") E. =SUM(A1:A8,"8")The following data is injured in the cells in excel sheet ranging from A1 to A8 have values greater than 8. Which of the following functions would provide the accurate result? A. =SUMIF(A1:A8,8) B. =AVERAGEIFS(A1:A8,">8) C. =AVERAGEIF(A1:A8,8) D. =COUNTIF(A1:A8,">8") E. =SUM(A1:A8,"8")
A. =SUMIF(A1:A8,8) B. =AVERAGEIFS(A1:A8,">8) C. =AVERAGEIF(A1:A8,8) D. =COUNTIF(A1:A8,">8") E. =SUM(A1:A8,"8")
Explanation / Answer
The following data is injured in the cells in excel sheet ranging from A1 to A8 have values greater than 8. Which of the following functions would provide the accurate result?
A. =SUMIF(A1:A8,8)
B. =AVERAGEIFS(A1:A8,">8)
C. =AVERAGEIF(A1:A8,8)
D. =COUNTIF(A1:A8,">8")
E. =SUM(A1:A8,"8")
Answer:
D. =COUNTIF(A1:A8,">8")
(number of observations greater than 8)
E. =SUM(A1:A8,"8")
(sum of 8 observations and 8)