In Excel, the function =COLUMN() in cell D5 returns: MCQ with Answer and Explanation

In Excel, the function =COLUMN() in cell D5 returns:

A. Error

B. 4

C. D

D. 5

Answer: Option B

Column D is 4th column.

This question belongs to: Computer Microsoft Office

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

Question #1 Report Error

In PowerPoint, which of the following views displays a small image of each slide with its transition and timing?

A. Outline view

B. Reading view

C. Slide Sorter view

D. Normal view

Correct Answer: Option C

Explanation:
Slide Sorter shows thumbnails and can display transition icons and timings below slides.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Word, the 'Thesaurus' tool is available under which tab?

A. Home

B. Insert

C. References

D. Review

Correct Answer: Option D

Explanation:
The Thesaurus is located in the Review tab, in the Proofing group. It provides synonyms and antonyms.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

To convert text to uppercase in Excel, which function is used?

A. LOWER()

B. CAPITAL()

C. UPPER()

D. PROPER()

Correct Answer: Option C

Explanation:
UPPER makes all letters uppercase. PROPER capitalizes each word's first letter, LOWER makes all lowercase.

This question belongs to: Computer Microsoft Office