Q1In MS Excel, what is the default keyboard shortcut to toggle the absolute cell referencing mode ($) while editing a formula?
Correct Answer: B
Explanation
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.
Q2In MS PowerPoint, which view allows you to see all the slides in a presentation as thumbnails arranged in horizontal rows for easy reordering?
A
Outline View
B
Slide Sorter View
C
Presenter View
D
Reading View
Correct Answer: B
Explanation
Slide Sorter View displays all slides in the presentation as miniature thumbnails, allowing users to easily reorder, delete, or organize slides into sections.
Q3Which of the following database objects in MS Access is primarily designed to securely look up, enter, or modify data in a table through a user-friendly layout?
A
Query
B
Report
C
Form
D
Macro
Correct Answer: C
Explanation
A Form in MS Access provides a user interface or layout used to view, enter, change, or navigate records in a table or query.
Q4What is the key combination used to insert a mandatory page break manually in MS Word?
A
Alt + Enter
B
Ctrl + Enter
C
Shift + Enter
D
Ctrl + Shift + Enter
Correct Answer: B
Explanation
Ctrl + Enter inserts a hard or manual page break at the cursor position in MS Word, while Shift + Enter inserts a soft line break.
Q5Which transition or animation effect property in MS PowerPoint allows an animation to start at the exact same time as the previous animation item?
A
On Click
B
With Previous
C
After Previous
D
Trigger
Correct Answer: B
Explanation
The 'With Previous' setting starts the selected animation effect simultaneously with the animation immediately preceding it on the slide timeline.
Q6In MS Access, which data type is ideal for fields that store long strings of alphanumeric characters, sentences, or paragraphs exceeding 255 characters?
A
Short Text
B
Long Text
C
Hyperlink
D
OLE Object
Correct Answer: B
Explanation
In modern versions of MS Access, 'Long Text' (previously called Memo) stores up to about 1 gigabyte of text, whereas 'Short Text' is capped at 255 characters.
Q7What is the function of the shortcut key combination Ctrl + Shift + G in MS Word?
A
Opens the Word Count dialog box
B
Activates the Research pane
C
Inserts a hyperlink
D
Toggles between uppercase and lowercase text
Correct Answer: A
Explanation
Ctrl + Shift + G directly opens the Word Count statistics dialog box in MS Word, providing details like pages, words, characters, and paragraphs.
Q8Which feature in MS PowerPoint allows you to pick specific slides from a larger presentation file to build an alternative sequence without modifying the original slides?
A
Slide Master
B
Custom Slide Show
C
Rehearsed Timings
D
Broadcast Slide Show
Correct Answer: B
Explanation
A Custom Slide Show lets you select specific slides from your current presentation file and arrange them into a separate tailored sequence for a specific audience.
Q9What happens when you select a block of text in MS Word and press the 'Ctrl + E' shortcut?
A
The text is right-aligned
B
The text is left-aligned
C
The text is centered
D
The text is justified
Correct Answer: C
Explanation
Ctrl + E is the standard keyboard shortcut used to center-align the selected text or paragraph in MS Word.
Q10Which function in MS Excel counts the number of cells in a specified range that contain numerical data only?
A
COUNTA
B
COUNTBLANK
C
COUNT
D
COUNTIF
Correct Answer: C
Explanation
The COUNT function counts cells containing numbers only. COUNTA counts all non-empty cells regardless of data type, and COUNTBLANK counts empty cells.
Q11Which view or master layout in MS PowerPoint is used to edit universal design themes, default fonts, and global slide layouts for an entire presentation file at once?
A
Handout Master
B
Notes Master
C
Slide Master
D
Outline Master
Correct Answer: C
Explanation
The Slide Master is the top slide in a hierarchy of slides that stores information about the theme and slide layouts of a presentation. Editing it changes all slides automatically.
Q12In MS Word, the small customized toolbar that appears immediately next to your cursor after selecting text containing options like bold, italic, and font size is called the:
A
Quick Access Toolbar
B
Mini Toolbar
C
Status Bar
D
Ribbon Explorer
Correct Answer: B
Explanation
The Mini Toolbar automatically appears as a semi-transparent overlay when text is selected, offering rapid access to high-frequency formatting options.
Q13Which MS Excel function returns the serial number of the current system date and time simultaneously?
A
TODAY()
B
NOW()
C
DATE()
D
TIME()
Correct Answer: B
Explanation
The NOW() function returns both the current system date and time. In contrast, TODAY() returns only the current system date without the exact time.
Q14In MS Word, which specific type of indent moves all lines of a paragraph inward from the left margin except for the first line?
A
First Line Indent
B
Hanging Indent
C
Right Indent
D
Negative Indent
Correct Answer: B
Explanation
A Hanging Indent leaves the first line of a paragraph flush with the margin, while all subsequent lines are indented or set inward.
Q15What is the keyboard shortcut to start a presentation slide show directly from the currently active slide instead of the beginning in MS PowerPoint?
A
F5
B
Shift + F5
C
Ctrl + F5
D
Alt + F5
Correct Answer: B
Explanation
While pressing F5 runs a presentation from slide one, pressing Shift + F5 initiates the slide show from whichever slide is currently active on your screen.
FREE LIMIT REACHED
Unlock Remaining Questions
You've previewed 15 free questions.
Upgrade to unlock the remaining
1,184 questions in this topic,
plus 54,353+ MCQs and
All Premium Mock Tests.
1 Month Plan
₹39
₹39 / month
⭐ BEST VALUE
3 Months Plan
₹89
₹29.67 / month
6 Months Plan
₹149
₹24.83 / month
1 Year Plan
₹199
₹16.58 / month
Secure Purchase
Instant Activation
24×7 Support