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

Question

Share Report Error

In Excel, the formula =A1>B1 returns:

A. TRUE or FALSE

B. 1 or 0

C. Yes or No

D. Both A and B

Answer: Option A

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

In MS Access, a select query that groups records and calculates sums, averages, etc., uses:

A. Sort row

B. Criteria row

C. Show row

D. Totals (Group By) row

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Clicking the Totals button (Σ) adds the Total row for grouping and aggregating.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following database objects in MS Access is primarily designed to securely look up, enter, or modify data in a table through a user-friendly layout?

A. Form

B. Macro

C. Report

D. Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, to view two parts of a document simultaneously, use:

A. Both A and B

B. Window -> New Window

C. View -> Split

D. Review -> Compare

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Split divides one window into two panes; New Window opens a second window of same document.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs