NEW
Font size
WorksheetsMultiple Choice Questions: MS Excel & Word Basics
Total questions: 30
Worksheet time: 15mins
Which function is used to find the sum of complex numbers in MS Excel?
SUM ()
ADD ()
CSUM ()
IMSUM ()
In spreadsheet software, what is the intersection of a column and a row called?
Column
Address
Value
Cell
Which feature allows you to narrow down the data in your worksheet?
Filters
Reporting
Sorting
Statics
Which one is an example of spreadsheet software?
MS Excel
MS Word with advanced table features for calculations
MS Access
MS PowerPoint
Which of the function below is used to send the same letter to different recipients?
Macros
Template
Mail merge
Bibliography
Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?
OR
AND
IF
ANDIF
Which function is used to create a date with year, month, and day?
DATE()
DATEDIF()
DATEVALUE()
CURDATE()
Which memory is faster?
Cache
RAM
ROM
SSD
A Processor unit, a memory unit, and an I/O system form a/an:
Central Processing Unit
Arithmetic Logic Unit
Control Unit
Microcomputer
Zoom, Google Meet, Microsoft Team etc. are the:
Validates sources for customer requirements
Way of communication
Channels of communication
Procedure and Matters
In customer service, etiquette refers to:
Good interpersonal communication with clients
Listening skills to understand and respond to customers’ needs
Verbal & non-verbal Communication skills
All of above
Which option is used to customize how your presentation will look as a printed handout?
Slide Master View
Handout Master View
Notes Master View
None of the above
Which option/feature is used to avoid showing all of the elements of a slide at once?
Hide slide
Turn off animations
Build slide
Normal view mode
The keyboard shortcut to stop media playback?
Alt + S
Alt + T
Esc
Alt + Q
Which of the following MS-Word feature crosses texts out by drawing a line through it?
Subscript
Pagination
Underline
Strikethrough
Which function in Excel tells how many numeric entries are there?
NUM
COUNT
SUM
CHKNUM
What is the process called when you transfer files from your computer to a computer on the Internet?
Uploading
Forwarding
FTP
Downloading
Which one of the following is an input device?
Monitor
Speaker
Printer
Scanner
Which of the following is not a feature in Microsoft Word?
Italic
Magic tool
Font
Bold
Which component is typically used in a modern computer?
Valves
LSI chips
Transistors with manual switches
Mechanical relays
Which of the following is NOT a virtual video conferencing platform?
Zoom
Google Meet
Dropbox
Skype
Which shortcut key combination is used to create a hyperlink in most word processing software?
Ctrl + H
Ctrl + K
Ctrl + Enter
Ctrl + S
What does GUI stand for in computer terminology?
General User Interface
Graphical User Interface
Global User Integration
Guided User Instruction
Which option best describes the purpose of a section break in a Word document?
To divide a document into sections with different page layouts or formatting
To save the document automatically
To insert a table of contents
To change the font style throughout the document
How many bits are in one nibble in computer systems?
2 bits
4 bits
8 bits
16 bits
Which printing option allows you to print on both sides of the paper?
Collate
Duplex
Draft
Portrait
What is the main function of driver software in a computer system?
It provides a software interface to hardware devices, enabling operating systems and other programs to access hardware functions without needing to know precise details about the hardware.
It stores user data and files for long-term access.
It manages the computer's power supply and cooling system.
It protects the computer from viruses and malware.
Which statement best describes the difference between a function and a formula in Excel?
A formula is an expression that uses operators, cell references, numbers, and functions to perform calculations, while a function is a predefined operation within Excel that can be used as part of a formula to achieve specific tasks.
A function is a type of hardware device, while a formula is a software application.
A formula is used only for text, while a function is used only for numbers.
A function and a formula are exactly the same in Excel.
What is the Unicode Standard used for in computer processing?
It is the universal character representation that provides a consistent way of encoding multilingual plain text, making it easier to exchange text files internationally.
It is a type of antivirus software that protects computers from malware.
It is a hardware component that increases computer speed.
It is a method for compressing large files for storage.
Which of the following best describes the purpose of antivirus software?
A computer antivirus is a software program designed to detect, prevent, and remove malicious software, commonly known as malware, from a computer.
Antivirus software is used to create and edit documents.
Antivirus software is a hardware device that increases memory capacity.
Antivirus software is used to connect computers to the Internet.
