If you autofill the formula =RANK.AVG(A1,$A$1:
$A$5,0) from B1 to B5,what would the value be in B5?
A) 4) 5
B) 4
C) 3) 5
D) 3
Correct Answer:
Verified
Q2: Which of the following is not an
Q3: Which function returns the rank of a
Q7: What is the sum_range argument of: =SUMIF(A2:A64,"Green",C2:C64)?
A)C2:C64
B)"Green"
C)SUMIF
D)A2:A64
Q9: Which of the following is an allowable
Q11: When using the Function Arguments Box, Excel
Q14: What function returns the variance of a
Q15: What are the two arguments for the
Q17: The RANK.EQ function returns _.
A)the rank of
Q18: A college admissions office might use which
Q19: What is the Criteria2 argument of: =COUNTIFS(A2:A64,"Blue",B2:B64,"Black")?
A)"Blue"
B)B2:B64
C)"Black"
D)A2:A64
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents