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

Question
What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel?
A. Alt + Enter
B. F4
C. F2
D. Ctrl + 1
Answer: Option B
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
In Excel, which tab contains the 'Page Setup' group?
A. Data
B. View
C. Page Layout
D. Insert
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Page Layout tab has Page Setup.
This question belongs to: Computer Microsoft Office
Question #2
In MS Excel, which of the following expressions is a valid syntax structure to calculate a logical conditional sum using multiple column criteria limits simultaneously?
A. =SUM.IF.MULTIPLE(Criteria_Range1, Criteria1, ...)
B. =MULTISUM(Sum_Range, Criteria_List)
C. =SUMIFS(Sum_Range, Criteria_Range1, Criteria1, Criteria_Range2, Criteria2)
D. =SUMIF(Criteria_Range, Criteria, Sum_Range)
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The SUMIFS function evaluates multiple criteria fields. Its syntax differs from SUMIF because it places the 'Sum_Range' as the very first argument.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which action query adds records from a query result to an existing table?
A. Update query
B. Delete query
C. Make-Table query
D. Append query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Append query inserts rows.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?