In MS Excel, what does the error code '#NULL!' indicate? MCQ with Answer and Explanation

Question
In MS Excel, what does the error code '#NULL!' indicate?
A. A required lookup key value cannot be located inside a range array.
B. A formula attempts to divide a numeric value by an empty cell row.
C. A function name contains a typographical misspelling mistake.
D. A formula specifies an intersection of two cell ranges that do not intersect.
Answer: Option D
Solution (By JKSSB Mock Tests)
The #NULL! error occurs when a space operator is used between two ranges that do not intersect, such as evaluating =SUM(A1:A2 B1:B2) instead of using a comma operator.
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 Excel, which function is used to find the largest value that meets a condition?
A. MAX
B. MAXA
C. MAXIFS
D. LARGE
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MAXIFS returns the maximum value based on criteria.
This question belongs to: Computer Microsoft Office
Question #2
What is the function of the keyboard shortcut Ctrl + J when working inside an active document in MS Word?
A. Applies center alignment formatting to the paragraph
B. Inserts a clear hyperlink text reference field
C. Indents the paragraph from the left page margin
D. Justifies the text alignment flush with both margins
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + J applies Justify alignment, distributing spacing between words so that text aligns flush with both the left and right page margins.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to calculate the present value of an annuity?
A. PV
B. FV
C. PMT
D. NPER
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PV calculates present value, FV future value, PMT payment, NPER number of periods.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?