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