In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula? MCQ with Answer and Explanation

Question

In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula?

A. F2

B. F8

C. F11

D. F4

Answer: Option D

Solution (By JKSSB Mock Tests)

Pressing the F4 key while editing a cell reference in an Excel formula toggles through absolute ($A$1), mixed (A$1, $A1), and relative (A1) references.

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 Word, which option is used to insert a list of figures?

A. References -> Insert Table of Figures

B. Review -> Table of Figures

C. Layout -> Figures

D. Insert -> Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Figures is under References.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, what does the 'Format' property of a field do?

A. Controls how data is displayed, not how it is stored

B. Restricts data entry to a pattern

C. Sets the maximum number of characters

D. Specifies the data type

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Format property customizes display (e.g., date format).

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Access, which of the following is used to enforce referential integrity?

A. Relationships

B. Input Masks

C. Validation Rules

D. Default Values

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Referential integrity is enforced through relationships between tables, ensuring that foreign key values match primary key values. Validation rules are for field-level validation.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs