Which of the following Excel functions is used to rank a number in a list? MCQ with Answer and Explanation

Which of the following Excel functions is used to rank a number in a list?
A. RANK.AVG()
B. RANK.EQ()
C. All of these
D. RANK()
Answer: Option C
Solution (By JKExamLibrary)
RANK (old), RANK.EQ, RANK.AVG are all ranking functions.

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 PowerPoint, which tab would you use to change the orientation of slides from landscape to portrait?
A. Home -> Orientation
B. View -> Slide Orientation
C. Design -> Slide Size -> Custom Slide Size
D. Insert -> Slide Orientation

Correct Answer: Option C


Explanation:
Slide orientation is under Design -> Slide Size.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which PowerPoint feature allows you to package the presentation with all linked files and fonts?
A. Compress Media
B. Export as PDF
C. Package for CD
D. Create Video

Correct Answer: Option C


Explanation:
Package for CD bundles the presentation and all external files for portability.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS PowerPoint, what is the difference between a 'Theme' and a 'Template'?
A. A Theme includes colors, fonts, and effects; a Template includes content and layout
B. Theme is for slides, Template is for handouts
C. A Template includes colors, fonts, and effects; a Theme includes content
D. They are the same

Correct Answer: Option A


Explanation:
A Theme is a set of design elements (colors, fonts, effects). A Template is a file that includes a theme, slide layouts, and often content placeholders or sample content to provide a starting point.

This question belongs to: Computer Microsoft Office