In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function will return 'TRUE' if the value in A1 is greater than 10 and less than 20?

A. =OR(A1>10, A1<20)

B. =IF(A1>10, A1<20)

C. =AND(A1>10, A1<20)

D. =NOT(A1>10)

Answer: Option C

Solution (By JKSSB Mock Tests)

AND returns TRUE if all conditions are true.

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

Share Report

In MS Access, which query is used to find duplicate records in a table?

A. Crosstab query

B. Both A and B

C. Select query with GROUP BY and HAVING COUNT(*)>1

D. Find Duplicates Query Wizard

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both the wizard and a totals query can identify duplicates.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, to enter a new line within a cell, press:

A. Alt + Enter

B. Shift + Enter

C. Enter

D. Ctrl + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Alt+Enter starts a new line in the same cell.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which of the following is the correct syntax for SUMIF?

A. SUMIF(criteria, sum_range)

B. SUMIF(range, sum_range, criteria)

C. SUMIF(criteria, range, sum_range)

D. SUMIF(range, criteria, [sum_range])

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SUMIF(range, criteria, [sum_range]) is correct.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs