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. =NOT(A1>10)

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

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

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

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

What is the function of the CONCATENATE function in Excel?

A. Joins two or more text strings into one string

B. Extracts a specific number of characters from the left of a string

C. Converts text to uppercase

D. Removes extra spaces from text

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
CONCATENATE combines text strings. UPPER converts to uppercase, TRIM removes extra spaces, LEFT extracts left characters.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which relationship layout constraint ensures that records cannot be deleted from a parent table if matching child records exist in a linked table?

A. Input Mask validation

B. Referential Integrity

C. Data Validation constraints

D. Cascade Update property

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Enforcing Referential Integrity ensures that relationships between tables stay consistent, preventing orphan records by blocking deletions in a parent table when linked child rows exist.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following key combinations is used to move the cursor to the beginning of the previous word in MS Word?

A. Alt + Left Arrow

B. Ctrl + Right Arrow

C. Ctrl + Left Arrow

D. Shift + Left Arrow

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Left moves to previous word.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs