In Excel, the formula =A1>B1 returns: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the formula =A1>B1 returns:

A. Yes or No

B. TRUE or FALSE

C. Both A and B

D. 1 or 0

Answer: Option B

Solution (By JKSSB Mock Tests)

Logical comparison returns TRUE or FALSE. However, TRUE/FALSE can be coerced to 1/0, but direct result is boolean.

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

What is the shortcut key to redo an action in MS Office?

A. Ctrl + Y

B. Ctrl + Z

C. Alt + Shift + Backspace

D. Ctrl + Shift + Z

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Y is redo. Ctrl+Z is undo. Ctrl+Shift+Z sometimes also redo but standard is Ctrl+Y.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what does an 'append query' do?

A. Deletes records from a table

B. Adds records from one table to another

C. Creates a backup of the table

D. Updates existing records

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Append query inserts records into a target table.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function is used to perform a vertical lookup with approximate match?

A. INDEX MATCH

B. XLOOKUP

C. VLOOKUP(lookup_value, table_array, col_index, TRUE)

D. HLOOKUP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP with TRUE (or omitted) performs approximate match.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs