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

In MS Excel, what type of referencing style is used when a formula contains a cell reference formatted as B$4?
A. Mixed Reference
B. Relative Reference
C. External reference link
D. Absolute Reference
Answer: Option A
Solution (By JKExamLibrary)
A mixed cell reference locks down either the column or the row while leaving the other free to shift relatively during formula copy-paste procedures.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Word, the 'Columns' feature allows you to:
A. Divide text into newspaper-style columns
B. Adjust paragraph indents
C. Create a chart
D. Insert table columns

Correct Answer: Option A


Explanation:
Columns feature under Layout tab formats text in multiple columns.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Access, what is a 'Primary Key'?
A. A field that allows duplicate values
B. A field that stores external data
C. A field that uniquely identifies each record in a table
D. A field used for sorting

Correct Answer: Option C


Explanation:
A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In PowerPoint, which button allows you to present online to remote viewers?
A. Broadcast Slide Show
B. Skype Meeting
C. Share via OneDrive
D. Present Online (or Office Presentation Service)

Correct Answer: Option D


Explanation:
Present Online (Office Presentation Service) lets others view in a browser. In newer versions, it's 'Present Online' or 'Share'. Broadcast Slide Show was older term.

This question belongs to: Computer Microsoft Office