What does the F4 key do in MS Excel after applying a format? MCQ with Answer and Explanation

Question
What does the F4 key do in MS Excel after applying a format?
A. Closes the current workbook
B. Toggles between absolute and relative reference in a formula
C. Repeats the last action (e.g., formatting)
D. Opens the Format Cells dialog
Answer: Option C
Solution (By JKSSB Mock Tests)
F4 repeats the last command or action. In a formula editing mode, F4 cycles reference types.
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 Word, what is the default paper size?
A. Executive
B. A4
C. Legal
D. Letter (8.5" x 11")
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Default paper size in US English version is Letter. In many regions, it's A4, but for competitive exams, often Letter is the default. I'll go with A, but clarify in solution that it depends on regional settings. Many exams ask default paper size = Letter (8.5x11). So I'll set A.
This question belongs to: Computer Microsoft Office
Question #2
The 'Ctrl + Shift + 8' shortcut in MS Word does what?
A. Sets line spacing to double
B. Inserts a page break
C. Toggles display of paragraph marks and hidden formatting symbols
D. Applies double strikethrough
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+8 (Ctrl+*) shows/hides formatting marks.
This question belongs to: Computer Microsoft Office
Question #3
Which specialized tool in MS PowerPoint allows an author to record precise rehearsal durations for each slide to ensure an automated slide show runs smoothly?
A. Animation Painter
B. Slide Master
C. Set Up Slide Show
D. Rehearse Timings
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Rehearse Timings allows you to run through your presentation and log the length of time spent on each slide, saving those parameters to automate presentation delivery.
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)?