If You Autofill the Formula =RANK

question 43

Multiple Choice

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

---

Definitions:

Distress

Acute stress or discomfort resulting from situations perceived as threatening or overwhelming.

Misinformation Effect

Information received from others about an event that can alter a memory to conform to the information received from other people.

Plausibility

The quality of appearing to be reasonable or probable, often used in the context of arguments or theories.

Confidence

The belief in one's abilities and making decisions or taking actions with a sense of assurance and firm trust in oneself.