What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel?

A. F4

B. Alt + Enter

C. F2

D. Ctrl + 1

Answer: Option A

Solution (By JKSSB Mock Tests)

F4 cycles through reference types in formula edit mode.

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, to create a bulleted list quickly, type an asterisk (*) and press:

A. Shift + Enter

B. Enter

C. Ctrl + Enter

D. Spacebar or Tab

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Typing * followed by Spacebar or Tab automatically starts a bulleted list (AutoFormat).

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, to enter a new line within a cell, press:

A. Shift + Enter

B. Ctrl + Enter

C. Enter

D. Alt + Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Alt+Enter starts a new line in the same cell.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS PowerPoint, which option is used to insert a table?

A. Insert > Table

B. Insert > Table > Insert Table

C. Both A and B

D. Home > Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can insert a table via Insert > Table, then choose a grid or Insert Table dialog. Both are valid.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs