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

Question

Share Report Error

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

A. Relative Reference

B. Absolute Reference

C. External reference link

D. Mixed Reference

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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

Share Report

In MS Access, to create a form that automatically adjusts to the size of the window, you can use:

A. Design View with auto-resize

B. Layout View and anchoring

C. Property 'Auto Resize'

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Anchoring controls in Layout View helps responsive design.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, to add a new record in a table, you can use:

A. Datasheet view -> New Record row (asterisk *)

B. Both A and C

C. SQL INSERT command

D. Design view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can add records via Datasheet view or via an INSERT query.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, a 'Navigation form' is used to:

A. Enter data

B. Print reports

C. Create tables

D. Provide a menu system to open forms and reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Navigation form acts as a switchboard.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs