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 B
1 7
2 5
3 8
4 9
5 7

A) 4 B) 3 C) 4.5 D) 3.5

D

Computer Science & Information Technology

You might also like to view...

A(n) ___________is a mathematical process for doing something

a. Formula b. Algorithm c. Cipher d. None of the above

Computer Science & Information Technology

What type of model is identity-based access control?

a. Mandatory access control b. Discretionary access control c. Nondiscretionary access control d. Transitive-discretionary access control

Computer Science & Information Technology