NEW
Font size
WorksheetsNSDA_CO_L3_Preparation_03
Total questions: 70
Worksheet time: 36mins
In addition to password protection, what other security feature can be used in Microsoft Word to restrict editing?
Read-only mode
Track Changes
Document Encryption
Watermark
One of the Pages will be portrait, and another will be Landscape. Which one of the below you have to perform in MS Word?
Page Break
Section Break
Page Wrapping
Column Break
The space between the margin and the start of a paragraph is called____
Blank space
Positive space
Indentation
Negative space
Which of the functions bellow is used to send same letter to different recipient.
Macros
Template
Mail merge
Bibliography
In Microsoft Word, how can you insert a new table into you document?
Insert tab > Table > Insert Table
Page Layout tab > Table > New Table
Insert tab > Table > Add Table
Format tab > Table > Create Table
Which of the following is not an essential component to create mail merge?
Main Document
Merge fields
Merge to PDF
Data Source
Which commands is used to open MS Word directly (if installed) from the RUN dialog box in the Windows operating system?
Winword.exe
Word.exe
Msword.exe
Word356.exe
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
Correct steps to protect a PowerPoint presentation with a password?
Tools -> Protect Presentation -> Encrypt with password.
File -> Info -> Protect Presentation -> Encrypt with password.
File -> More Option -> Protect Presentation -> Encrypt with password.
All of the above
ARPANET stands for___
Advanced Rehearse Projects Agency Network
Advanced Research Projects Agency Newark
Advanced Research Project Agency Network
None of these
What is the default file name of Microsoft Excel File?
A ______ is a central device that divides a network connection among several devices.
To set the transition speed, select___.
Transitions > Timing Group > Duration Box
Transitions > Transitions Duration
Transitions > Transitions Timing Duration Box
None of the above
One of the following is not used to connect a wired printer.
802.11
USB
Ethernet
Parallel
Wi-Fi stand for
What is the full form if NIC?
Network ID Card
Network Interface Card
A ______ is a networking device that connects all if the devices on the network to transport data to another device.
Switch
Hub
Router
Modem
WLAN device is installed in or attached to a PC to provide an interface to a wireless network is _______
Access Point
Network Adapter
Repeater
Antenna
Which of the following is a correct format of email address?
Someone inserted a flowchart in a newsletter, which object did he/she use?
WordArt
Shape
Create flowchart.
chart
Which commands is used to open Power Point directly (if installed) from the RUN dialog box in Windows operating system?
Powerpoint
Powerpnt
Ppt
Pptx
Which feature in Microsoft Word is used for citing sources and creating a list of references?
Footnote
Endnote
Bibliography
Index
A typical modern computer uses.
Valves
LSI chips
Vacuum tubes
All of these
Smart Card is ______
Special purpose Cards
Microprocessor Cards
Processing unit contains memory for storing data
Processing unit for software
Which key is shortcut to delete current slide in PowerPoint?
Delete
Backspace
Enter
Both A & B
Which year Microsoft PowerPoint was introduced?
1989
1990
1987
1996
A PowerPoint template is saved as ____ File
ppts
potx
pstx
temx
Personal logs or journal entries posted on the website are known as?
Smartlogs
Photo
Blogs
All of the above
Which of the following cannot be a part of an email address?
Underscore (_)
Space ( )
At Sign (@)
Period (-)
___ is used to stack your open window so you can see all of them at once:
New Window
Cascade view
Arrange All View
All of the above
How to add animation to text, pictures, shapes, and more in your presentation?
Select Object, Select Animations, Choose an animation, Select Setup Effect and choose an effect.
Select Object, go to the Home tab, Select effects settings and choose an effect
Select Objects, Select Animations and Choose an animation, Select Effect Options and Choose an effect.
All of the above.
Which feature usually used to create a document like newspaper?
Bullet & numbering stops
Table
Columns
Tab
What is the standard unit of Front size?
Centimeters
Bytes
Point
Inches
Which of the function bellow is used to send same letter to different recipient.
Macros
Mail merge
Template
Bibliography
To view “Header and Footer”, user must switch to
a. Normal view
b. Print layout view
c. Print preview mode
d. Both b and C
Which of the following is not a strong media?
USB Pen drive
Portable Hard Drive
Optical Drive
15. Which of the following is not a type of page margin?
Normal
Narrow
Moderate
Middle
16. Home Key use to moves the cursor beginning of the
Line
Paragraph
Documents
Screen
Which ribbon includes the command for inserting charts that illustrate or compare date?
Draw
Insert
Home
Design
Which logical function returns TRUE if all arguments evalute TRUE; FALSE if not?
OR
IF
AND
ANDIF
20. 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
____ is used to customize how your presentation will look as a printed handout.
Slide Master View
Handout Master View
Notes Mater View
None of the above
During the slide show, which shortcut key is used to view the computer taskbar?
Ctrl + Shift + Del
Ctrl + T
Shift + T
Alt + T
The keyboard shortcut to stop media playback?
Alt + S
Alt + T
Esc
Alt + Q
The clock rate of a processor in measured in –
Megahertz or gigahertz
Nanosecond
Micro hertz
Miliseconds
In Microsoft PowerPoint ,two kinds of sound effects files than can be added to the presentation is-
.jpg files and .gif files
wav files and .jpg files
wav files and .gif files
.wav files and .mid files
To create an ID card using word processing softwere. Which is most important?
Insert & Modify shape
Page layout
Insert Header & footer & modify them
Insert and modify Picture
What does CountA() function do ?
Counts cell having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells
PowerPoint presentations are widely used as:
Note outlines for teachers
Project presentations by students
Communication of planning
All of above
Which is not a Text function in MS Excel?
CODE()
CLEAN()
CHAR()
DB()
What is a URL?
An acronym for Unlimited Resources for Learning
The address of a document or “page” on the World Wide Web
A type of programming object
A computer software program
Which of the following is NOT a type of non-verbal communication?
Facial expressions
Gestures
One to one communication
Written text
What is the first step in identifying a client’s requirements?
Offering solutions immediately
Listening actively to the client
Telling the client what they need
Discussing with the problem
How do you select multiple icons on the desktop in Windows?
Click each one individually
Hold the Ctrl key and click each icon
Press F1
Hold the Alt key and click each icon
What does dragging a window to the edge of the screen in Windows do?
Closes the window
Changes the background
Maximizes or snaps the window to half the screen
Opens the Start menu
What is the first software that loads when a computer is powered on ?
Operating system
BIOS/UEFI
Application Software
Firmware
You open your word processing software to begin a report, but the formatting toolbar is missing. What should you do first?
Restart the computer
Editing the file menu
View menu to restore the toolbar
Uninstall and reinstall the software immediately
Which of the following setting is found under the ‘Page Layout’ ( or ‘Layout’) tab in MS Word?
Numbering
Line Number
Line Spacing
Multilevel
Which tools use from references tab for format word documents?
Page Layout
Bibliography
Header & Footer
Labels
When preparing a research paper or academic report, what features are most important?
Animation and Transition
Footnotes, Citations, and Bibliography
Symbols and Equations
Page Color and Border
You are entering dates in a spreadsheet, but they are displaying as random numbers (e.g,44927). What is
the most likely issue?
The cell is formatted as text
The cell is formatted as general of number
The cell is formatted as long date
Your keyboard is malfunctioning
You went to check if a cell empty. Which function should you use?
=ISNUMBER()
=IFERROR()
=ISEMPTY()
=ISBLANK()
What is the result of =ROUND(12.789,2)?
12.87
12.7
12.79
13
What does the formula =IF(B2>100, “Pass”, “Fail”) do?
Compares B2 to 100 and displays “Pass” if less
B2<100 then Return “Pass” or “Fail”
Returns “Pass” if B2 is greater than 100, otherwise “Fail”
Returns “Fail” if B2 is greater than 100, otherwise “Pass”
Which operator is used to combine (concatenate) text from two cells?
+
&
-
*
You need to apply different headers and footers for different chapters in your document. What should you use?
Page Break
Table of Contents
Section Breaks
Next Page
