In Excel, what does the 'RANK' function do? MCQ with Answer and Explanation

Question Report Error

In Excel, what does the 'RANK' function do?

A. Returns the rank of a number in a list relative to other numbers

B. Sorts data in ascending order

C. Returns the position of a value in an array

D. Counts the number of values greater than a given number

Answer: Option A

Solution (By JKExamLibrary)

RANK returns the rank (position) of a number within a list of numbers, where rank 1 is the largest (default).

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Access, what is the maximum number of fields in a table?

A. 64

B. 255

C. 256

D. 1,000

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
An Access table can have up to 255 fields.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, the 'Allow Zero Length' property is relevant for:

A. All fields

B. Text and Memo (Long Text) fields

C. Date fields

D. Number fields

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Only text-based fields.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, what does the COUNTA function count?

A. Only text cells

B. All non-empty cells

C. Only numeric cells

D. Only blank cells

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
COUNTA counts cells containing any type of data (numbers, text, errors, etc.), excluding empty cells.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs