In Excel, the function =ISBLANK(A1) returns: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the function =ISBLANK(A1) returns:

A. TRUE if A1 is empty, FALSE otherwise

B. TRUE only if A1 contains a formula returning empty

C. Both A and B

D. FALSE if A1 has a space

Answer: Option C

Solution (By JKSSB Mock Tests)

ISBLANK returns TRUE if cell is empty. A cell with a space is not empty, so FALSE.

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

What is the shortcut key used to insert a hyperlink into a selected cell or text across most MS Office programs?

A. Ctrl + H

B. Ctrl + K

C. Ctrl + M

D. Ctrl + L

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The standard keyboard shortcut to insert or edit a hyperlink in Microsoft applications like Word, Excel, and PowerPoint is Ctrl + K.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, the shortcut to apply double underline is:

A. Ctrl + Shift + D

B. Ctrl + U

C. Ctrl + Alt + D

D. Ctrl + D

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+D applies double underline. Ctrl+U single underline.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, which key is used to extend a selection?

A. Alt

B. Shift

C. F8

D. Ctrl

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F8 turns on extend selection mode; pressing it repeatedly selects word, sentence, paragraph, etc. Shift+arrow also extends.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs