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. F4
B. F8
C. F11
D. F2
Answer: Option A
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
In MS Access, the property 'Default Value' is used to:
A. Restrict the type of data
B. Set the maximum length of a field
C. Format the display of data
D. Automatically enter a value when a new record is created
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Default Value populates a field when a new record is added, unless overridden.
This question belongs to: Computer Microsoft Office
Question #2
What does the VLOOKUP function do in Excel?
A. Rounds a number to a specified number of digits
B. Returns the current date and time
C. Searches for a value in the first column of a table and returns a value in the same row from a specified column
D. Counts the number of cells that meet a condition
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP looks up a value vertically. It searches down the first column and returns a value from another column in that row.
This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to open the 'Find and Replace' dialog box in MS Word with the Replace tab active?
A. Alt + E, E
B. Ctrl + H
C. Ctrl + F
D. Ctrl + G
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + H opens the Find and Replace dialog with the Replace tab active. Ctrl+F opens the Navigation pane for Find. Ctrl+G opens Go To. Alt+E,E is old menu.
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)?