In MS Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5? MCQ with Answer and Explanation

In MS Excel, what type of cell reference style is used when a formula contains a cell formatted as $C$5?
A. Mixed Cell Reference
B. Absolute Cell Reference
C. Relative Cell Reference
D. External sheet reference link
Answer: Option B
Solution (By JKSSB Mock Tests)
An absolute cell reference locks both the column letter and the row number with dollar signs ($C$5), ensuring that the reference does not change when the formula is copied to another cell.

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 returns the row number of a reference?
A. ROW_NUMBER()
B. ROW()
C. COLUMN()
D. ROWS()

Correct Answer: Option B


Explanation:
ROW(reference) returns row number. COLUMN returns column number.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, which of the following is NOT a standard slide layout?
A. Comparison
B. Chart Slide
C. Section Header
D. Title and 2 Content

Correct Answer: Option B


Explanation:
Chart Slide is not a built-in layout.

This question belongs to: Computer Microsoft Office
Question #3
In Access, which of the following is a valid way to import data from an Excel spreadsheet?
A. File > Open > Excel
B. Home > Import
C. Create > Import Excel
D. External Data tab > Excel

Correct Answer: Option D


Explanation:
The External Data tab has options to import from Excel. File > Open opens Access databases, not import.

This question belongs to: Computer Microsoft Office