In Excel, the error '#REF!' indicates: MCQ with Answer and Explanation

Question
In Excel, the error '#REF!' indicates:
A. Wrong data type
B. Formula name not recognized
C. Division by zero
D. Invalid cell reference (cell may have been deleted)
Answer: Option D
Solution (By JKSSB Mock Tests)
#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.
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 PowerPoint, the 'Eyedropper' tool is useful for:
A. Drawing a freeform shape
B. Filling a shape with gradient
C. Removing a color from an image
D. Matching a color from one object to another
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Eyedropper picks up a color from any element.
This question belongs to: Computer Microsoft Office
Question #2
Which feature in MS PowerPoint allows you to pick an active application window on your desktop and insert a static snapshot image of it directly onto a slide?
A. Cameo live video stream
B. Screenshot
C. SmartArt graphic layout
D. Screen Recording video
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Screenshot tool captures a static image snapshot of any open window on your desktop and embeds it directly onto the active presentation slide.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which data type automatically generates a unique number for each new record?
A. Number
B. Currency
C. AutoNumber
D. Yes/No
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AutoNumber is used for sequential unique IDs. Number stores numeric values, Currency for monetary data, Yes/No for boolean.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: