In Excel, the function =CHOOSE(2, "Red", "Green", "Blue") returns: MCQ with Answer and Explanation

In Excel, the function =CHOOSE(2, "Red", "Green", "Blue") returns:

A. Error

B. Green

C. Red

D. Blue

Answer: Option B

CHOOSE returns the 2nd value: Green.

This question belongs to: Computer Microsoft Office

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

Question #1 Report Error

In MS Access, which property makes a text field accept only uppercase letters?

A. Both A and B

B. Validation Rule

C. Format property set to >

D. Input Mask with >

Correct Answer: Option A

Explanation:
Format > displays uppercase. Input mask > forces entry to uppercase. Both can achieve.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Word, the 'Compare' feature is used to:

A. Check grammar

B. Compare document with a template

C. Compare two versions of a document and show differences

D. Measure reading level

Correct Answer: Option C

Explanation:
Compare (Review tab) merges and highlights changes between two documents.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, what field property specifies a pattern format rule (e.g., '(000) 000-0000') that users must strictly follow when entering data?

A. Format Parameter

B. Default Value

C. Validation Text

D. Input Mask

Correct Answer: Option D

Explanation:
An Input Mask creates a placeholder pattern constraint that guides formatting layout directly during manual data entry steps.

This question belongs to: Computer Microsoft Office