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


Answer: D) 3.5

Computer Science & Information Technology

You might also like to view...

Which is not one of the basic steps involved in creating a sequential file?

a. Open the file b. Create the contents of the file c. Close the file d. All of the above must be done to create a sequential file

Computer Science & Information Technology

When you buy software, you can only use it as specified in the EULA

Indicate whether the statement is true or false

Computer Science & Information Technology

To sort the order of records in a form, you need to open the form in:

A) Tabular View. B) Print Preview. C) Design View. D) Form View.

Computer Science & Information Technology

Best security practices balance the need for user __________ to information with the need for adequate protection while simultaneously demonstrating fiscal responsibility.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology