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

Question

Share 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. Returns the position of a value in an array

C. Sorts data in ascending order

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

Answer: Option A

Solution (By JKSSB Mock Tests)

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In MS Word, the 'Alt + Ctrl + F2' shortcut opens:

A. Open dialog (same as Ctrl+O)

B. New document

C. Print dialog

D. Save As

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+Ctrl+F2 opens Open dialog.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what is the maximum size of an OLE Object field?

A. 256 MB

B. Limited by database size

C. 2 GB

D. 1 GB

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
OLE Object fields can store up to 1 GB of data.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, to add a footer to all slides, go to:

A. Design -> Slide Size

B. View -> Slide Master -> Insert Footer

C. Insert -> Header & Footer

D. Transitions -> Footer

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Header & Footer dialog adds date, slide number, custom text.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs