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 cell reference uses both relative and absolute components
C. A formula references a cell from a different worksheet
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, which feature can be used to copy all standard formatting, animations, colors, and styling from one object and apply it to another?
A. Design Template
B. Animation Painter
C. Format Painter
D. Style Manager
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.
This question belongs to: Computer Microsoft Office
Question #2
What does Ctrl + Y do in MS Office?
A. Redo or repeat the last action
B. Delete a line
C. Open a new document
D. Yank text to clipboard
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Y redoes an undone action or repeats the last command.
This question belongs to: Computer Microsoft Office
Question #3
What is the purpose of the PMT function in Excel?
A. Projects the future value of an investment
B. Returns the present value of an investment
C. Converts a number to text with currency format
D. Calculates the periodic payment for a loan based on constant payments and interest rate
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT(rate, nper, pv) computes loan payment. FV returns future value, PV present value.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Networking 325 Microsoft Office 1199 CPU (Central Processing Unit) 327 Cyber Security 269 Memory and Storage Devices 438
Explore Subjects
Geography GK 6121 Current Affairs 575 History GK 3374 Accountancy and Statistics 3179 Maths 5575
Practice Mix
Select the most appropriate meaning of the idiom: 'Make a mountain out of a molehill'.
What does the 'GUI' acronym stand for in computer interface terminology?
A trader marks his goods 80% above cost price and gives a discount of 40%. Find his gain percent.
Which type of memory is used to store the firmware that boots the computer?
The average of 8 numbers is 30. If one number is 40, find the average of the remaining 7.