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

Question
In Excel, the function =ISBLANK(A1) returns:
A. TRUE only if A1 contains a formula returning empty
B. Both A and B
C. FALSE if A1 has a space
D. TRUE if A1 is empty, FALSE otherwise
Answer: Option B
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
What is the function of the keyboard shortcut Ctrl + K across Microsoft Word, Excel, and PowerPoint applications?
A. Applies an italic style formatting layer
B. Deletes the selected paragraph line block
C. Launches the spell checker tool
D. Opens the Insert Hyperlink dialog box window
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + K is the standard keyboard shortcut used to open the Insert Hyperlink dialog box across Microsoft Office applications, allowing users to link to files or web pages.
This question belongs to: Computer Microsoft Office
Question #2
Which field type in an MS Access table automatically generates a brand new sequential or randomized number every time a new row is appended?
A. AutoNumber
B. Calculated
C. OLE Object
D. Number
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The AutoNumber data type automatically inserts a unique, incremented numeric value whenever a new record is added to the table database.
This question belongs to: Computer Microsoft Office
Question #3
Which of the following database tools in MS Access provides a user-friendly layout or digital form explicitly designed to view, input, or navigate individual data records?
A. Query matrix
B. Form
C. Report
D. Macro routine
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Forms serve as user interface layouts that simplify data entry, record modification, and database navigation tasks for end-users.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.