In Excel, the error '#NULL!' occurs when: MCQ with Answer and Explanation

Question
In Excel, the error '#NULL!' occurs when:
A. Cell reference is invalid
B. You specify an intersection of two areas that don't intersect
C. Division by zero
D. A formula is not recognized
Answer: Option B
Solution (By JKSSB Mock Tests)
#NULL! means no intersection when using space 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
What is the maximum number of rows supported natively by an MS Excel worksheet worksheet file since Excel 2007 (.xlsx onwards)?
A. 1,048,576
B. 16,384
C. 65,536
D. 524,288
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Modern versions of MS Excel support exactly 1,048,576 rows and 16,384 columns per worksheet.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, the formula =SUM(Sheet2:Sheet5!B3) will:
A. Sum range B3 on the active sheet
B. Cause an error because of incorrect syntax
C. Sum cell B3 from Sheet2 through Sheet5
D. Sum all cells named Sheet2 and Sheet5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
This 3-D reference sums the same cell across multiple worksheets.
This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is a valid way to run a query?
A. Open the query in Datasheet View
B. Run button in Design View
C. All of the above
D. Double-click the query in the Navigation Pane
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can run a query by double-clicking, opening in Datasheet view, or clicking Run in Design View.
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)?