Complete your MS Office preparation with MS Office MCQ Set 2 - extending coverage into MS PowerPoint (slide layouts, animations, transitions, presentation views) and MS Access (basic database creation, forms, queries, reports), alongside advanced Excel functions including VLOOKUP, pivot tables, and data validation. This set rounds out your office productivity knowledge and ensures you are fully prepared for the complete range of MS Office questions that government exams can throw at you - from straightforward keyboard shortcuts to application-based scenarios that test genuine working knowledge.
Read more ↓
Q 1 / 25
Advanced Internet DBMS and MS Office
The memory sizes in mainframe computers and advanced technology micro computer are expressed as
A
Bits
B
Bytes
C
Kilobytes
D
Megabytes
Answer & Explanation
While basic unit sizes are bytes, historical mainframe and advanced microcomputer capacities were commonly categorized and measured in Megabytes.
Q 2 / 25
Advanced Internet DBMS and MS Office
An error is also known as:
A
Bug
B
Debug
C
Cursor
D
Icon
Answer & Explanation
An error or flaw in a computer program that causes it to produce incorrect or unexpected results is called a bug.
Q 3 / 25
Advanced Internet DBMS and MS Office
Which of the following statement is wrong?
A
Photoshop is a graphical design tool by Adobe
B
Linux is free and open source software
C
Linux is owned and sold by Microsoft
D
Windows XP is an operating system
Answer & Explanation
Linux is an open-source operating system under the GPL license, and is not owned or sold by Microsoft.
Q 4 / 25
Advanced Internet DBMS and MS Office
Who invented the supercomputer?
A
Charles Babbage
B
JH Van Tassell
C
Charles Ginsberg
D
Seymour Cray
Answer & Explanation
Seymour Cray is universally recognized as the designer and inventor of the first commercially successful supercomputers.
Q 5 / 25
Advanced Internet DBMS and MS Office
Microsoft Word is an example of
A
an operating system
B
Processing device
C
Application software
D
an input device
Answer & Explanation
Microsoft Word is a word processing program classified as application software.
5 down - feeling confident?
⏱️ Quick Check
Try MS Office MCQ Set 2 in Test Mode
Timed · 25 questions · 25 min
Q 6 / 25
Advanced Internet DBMS and MS Office
In how many generations a computer can be classified?
A
3
B
4
C
5
D
6
Answer & Explanation
Computers are generally classified into five distinct generations based on core electronic components.
Q 7 / 25
Advanced Internet DBMS and MS Office
Which of the following memory is non-volatile?
A
ROM
B
SRAM
C
DRAM
D
All of the above
Answer & Explanation
ROM (Read-Only Memory) is non-volatile, meaning it retains its stored data even when the computer's power is turned off.
Q 8 / 25
Advanced Internet DBMS and MS Office
A light sensitive device that converts drawing, printed text or other images into digital form is
A
Plotter
B
Keyboard
C
OMR
D
Scanner
Answer & Explanation
A scanner is an input device that optically scans physical images, printed text, or objects and converts them into digital signals.
Q 9 / 25
Advanced Internet DBMS and MS Office
The basic architecture of computer was developed by
A
Blaise Pascal
B
John Von Neumann
C
Garden Moore
D
Charles Babbage
Answer & Explanation
The basic computer architecture (stored-program model) was proposed and developed by mathematician John von Neumann.
Q 10 / 25
Advanced Internet DBMS and MS Office
Which protocol provides e-mail facility among different hosts?
A
SNMP
B
FTP
C
TELNET
D
SMTP
Answer & Explanation
SMTP (Simple Mail Transfer Protocol) is the standard TCP/IP protocol used for sending and routing electronic mail.
10 down - feeling confident?
⏱️ Quick Check
Try MS Office MCQ Set 2 in Test Mode
Timed · 25 questions · 25 min
Q 11 / 25
Advanced Internet DBMS and MS Office
Second generation computers are made of
A
LSI
B
Transistors
C
VLSI
D
Vaccum Tubes
Answer & Explanation
Second-generation computers (1959-1964) transitioned from vacuum tubes to discrete transistors.
Q 12 / 25
Advanced Internet DBMS and MS Office
In order to tell Excel that we are entering a formula in cell, we must begin with an operator such as
A
+
B
$
C
=
D
@
Answer & Explanation
Every formula in Microsoft Excel must start with an equals sign (=) for the spreadsheet to compute it.
Q 13 / 25
Advanced Internet DBMS and MS Office
First generation of computer was based on which technology?
A
VLSI
B
Transistor
C
Vaccum Tube
D
LSI
Answer & Explanation
First-generation computers (1946-1958) relied on vacuum tubes for electronic switching and circuitry.
Q 14 / 25
Advanced Internet DBMS and MS Office
Fifth generation computers are based on
A
System Knowledge
B
Artificial Intelligence
C
VVLSI
D
Programming Intelligence
Answer & Explanation
Fifth-generation computing devices are based on parallel processing architectures and Artificial Intelligence (AI).
Q 15 / 25
Advanced Internet DBMS and MS Office
Microprocessor was introduced in which generation of computer?
A
2nd Generation
B
4th Generation
C
Both (A) and (B)
D
3rd Generation
Answer & Explanation
Microprocessors built using VLSI technology were introduced in the fourth generation of computers (starting in 1971).
15 down - feeling confident?
⏱️ Quick Check
Try MS Office MCQ Set 2 in Test Mode
Timed · 25 questions · 25 min
Q 16 / 25
Advanced Internet DBMS and MS Office
When the Language bar is ________, it means that you do not see it on the screen but it will be displayed the next time you start your computer.
A
Restored
B
Hidden
C
Minimized
D
Closed
Answer & Explanation
When the Language bar is hidden, it is temporarily inactive on the desktop workspace but will automatically initialize upon the next computer startup.
Q 17 / 25
Advanced Internet DBMS and MS Office
AutoCorrect was originally designed to replace _________ words as you type.
A
Short, repetitive
B
Grammatically incorrect
C
Misspelled
D
None of the above
Answer & Explanation
AutoCorrect was primarily created to automatically fix common typographical errors and misspelled words on-the-fly.
Q 18 / 25
Advanced Internet DBMS and MS Office
Home Key uses for
A
Moves the cursor beginning of the document
B
Moves the cursor beginning of the paragraph
C
Moves the cursor beginning of the screen
D
Moves the cursor beginning of the line
Answer & Explanation
Pressing the Home key instantly positions the typing cursor back to the starting point of the current line of text.
Q 19 / 25
Advanced Internet DBMS and MS Office
Which enables us to send the same letter to different persons?
A
Macros
B
Template
C
Mail merge
D
None of above
Answer & Explanation
Mail merge allows users to link a single form letter with a database list to generate personalized documents for multiple recipients.
Q 20 / 25
Advanced Internet DBMS and MS Office
A word processor would most likely be used to do
A
Keep an account of money spent
B
Do a computer search in media center
C
Maintain an inventory
D
Type a biography
Answer & Explanation
Word processing applications are specifically designed for typing, structuring, and formatting textual documents like biographies.
20 down - feeling confident?
⏱️ Quick Check
Try MS Office MCQ Set 2 in Test Mode
Timed · 25 questions · 25 min
Q 21 / 25
Advanced Internet DBMS and MS Office
The ability to combine name and addresses with a standard document is called ________
A
Document formatting
B
Database management
C
Mail merge
D
Form letters
Answer & Explanation
Mail merge is the processing method of combining names and mailing addresses with a master document template.
Q 22 / 25
Advanced Internet DBMS and MS Office
Which of the following is not essential component to perform a mail merge operation?
A
Main document
B
Data source
C
Merge fields
D
Word fields
Answer & Explanation
Performing a mail merge strictly requires the main document, a database source, and corresponding mapping merge fields.
Q 23 / 25
Advanced Internet DBMS and MS Office
”Ctrl + Right Arrow” is used to
A
Moves the cursor one word right
B
Moves the cursor end of the line
C
Moves the cursor end of the document
D
Moves the cursor one Paragraph down
Answer & Explanation
The keyboard shortcut Ctrl + Right Arrow shifts the cursor one entire word to the right.
Q 24 / 25
Advanced Internet DBMS and MS Office
What is gutter margin?
A
Margin that is added to the left margin when printing
B
Margin that is added to right margin when printing
C
Margin that is added to the binding side of page when printing
D
Margin that is added to the outside of the page when printing
Answer & Explanation
Gutter margin is extra space added to the binding side of a page layout during printing to prevent the binding from hiding text.
Q 25 / 25
Advanced Internet DBMS and MS Office
Which can be used for quick access to commonly used commands and tools?
A
Status bar
B
Tool bar
C
Menu bar
D
Title bar
Answer & Explanation
Toolbars provide instant, graphical click-access to frequently used program commands, tools, and options.