In Excel, a circular reference occurs when: MCQ with Answer and Explanation

Question
In Excel, a circular reference occurs when:
A. A formula refers to its own cell either directly or indirectly
B. A formula references a cell from a different worksheet
C. A cell reference uses both relative and absolute components
D. A cell is formatted as a circle
Answer: Option A
Solution (By JKSSB Mock Tests)
Circular reference means the formula depends on itself, creating an infinite loop.
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 MS PowerPoint, what is the default keyboard shortcut used to start a presentation slide show directly from the currently active slide instead of the beginning?
A. Ctrl + F5
B. Shift + F5
C. F5
D. Alt + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Shift + F5 launches the slide show from the currently active slide. Pressing F5 launches the presentation from the very first slide.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to find the largest value in a range?
A. MAXA
B. MAX
C. LARGE
D. MAXIFS
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The MAX function returns the largest numeric value in a range. LARGE can return the nth largest, MAXA includes logical values, MAXIFS finds max based on criteria.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the feature that automatically creates a border when you type three hyphens and press Enter is:
A. Smart Lookup
B. Quick Styles
C. AutoCorrect
D. AutoFormat As You Type
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Typing three hyphens, underscores, or equal signs and Enter triggers automatic border creation.
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: