WorksheetsPMF Skills Institute — Formative Assessment -3
Total questions: 90
Worksheet time: 45mins
Auto correct are originally designed to replace ____ words as you types?
Short, repetitive
Grammatical incorrect
Misspelled
None of these
Which is the Right term of PowerPoint Presentation?
Slides
Clipart
Image
Chart
Which is the shortcut key for creating hyperlink?
Ctrl + E
Ctrl + K
Ctrl + H
Ctrl + Z
Which feature is allowing you to narrow down the data in your worksheet?
Filters
Reporting
Sorting
Statics
Which sign is used in the formula to use absolute reference?
Underscore (_)
Dollar ($)
Equal (=)
Column (:)
What is a URL?
An acronym for Unlimited Resource for Learning
The address of document or “page” on the world wide web.
A type of programming object
A computer software program
Which formats represents the number with the dollar ( )sign?[Forexample, 10000]
Automatic
Number
Currency
Time
Which ribbon tab in MS Word contains options for adjusting the margins and orientations of the document?
Reference
Insert
Home
Page layout
What is the purpose of Slide Master PowerPoint?
To add animations to slide
To record narrations for slides
To record endnote for slides
To design and customize the appearance of all slide
Which is used to store firmware
EPROM
ROM
RAM
PROM
Documents can be ____With MS Word.
Created
Edited
Saved
All of the above
Which of the following is not a section break options?
Previous page
Next page
Even page
Odd page
. Which ribbon contains options related to font formatting in MS Word?
Draw
Home
Insert
Design
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
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
To set the transition speed, select the correct menu path.
Transitions > Timing Group > Duration Box
Transitions > Transitions Duration
Transitions > Transitions Timing Duration Box
None of the above
The keyboard shortcut to stop media playback is which of the following?
Alt + S
Alt + T
Esc
Alt + Q
During the slide show, which shortcut key is used to view the computer taskbar?
Ctrl + Shift + Del
Ctrl + T
Shift + T
Alt + T
In Bijoy Unicode, which combination forms the word “উঠি”?
উ + ি
উ + ୀ
ও + ি
উ + ু
Select the font names from the list.
Arial
Calibri
Times New Roman
Verdana
Tahoma
Which statement best describes Google Docs?
An online word processor that allows users to create and edit documents collaboratively in real time
A desktop-only spreadsheet application for offline data analysis
A browser extension that blocks advertisements on websites
A file compression utility for reducing document size
Which of the following are email service providers?
Gmail
Outlook
AOL Mail
Yahoo Mail
iCloud Mail
Which of the following are antivirus software products?
Kaspersky
McAfee
Microsoft Defender
Norton 360
Avast
Which statement best describes Unicode?
An international character encoding standard
A word processing application
A computer virus scanner
A file compression format
What does the Collate option in printing settings do?
Arranges printed pages in the correct order for a document
Increases the print resolution for sharper text
Enables automatic double-sided printing by default
Changes the paper size to fit the content
Which statement best describes Google Docs?
An online word processor that allows users to create and edit documents collaboratively in real time
A desktop-only spreadsheet application for offline data analysis
A browser extension that blocks advertisements on websites
A file compression utility for reducing document size
How many keys are on a standard keyboard?
101
102
104
108
When is Computer Literacy Day celebrated?
2 December
1 May
5 October
10 January
Which is not edition of MS Word?
MS Word 2019
MS Word 2010
MS Word 2007
MS Word 1206
Which tab do you use to change the page orientation in MS Word?
Layout
Home
Insert
Design
What is the purpose of the “Style” feature in MS Word?
To check spelling
To format text consistently
To save document
To insert image
From which menu tab a new document is created?
Home Tab
Insert Tab
Layout Tab
File Tab
How to adjust the width of a column automatically in a table to fit the content?
Split
Merge cell
Table tools
AutoFit
Which command is used to apply a consistent format to multiple text selections?
Font
Styles
Text effects
Format painter
Which MS Word feature helps to prevent accidental change to a document?
Password Protect
Protect Document
Restrict Editing
Track Change
How to insert a page break in MS Word?
Insert > Page Break
Insert > Layout > Page Break
Home > Insert > Page Break
Insert > Break > Page Break
The greater than sign (>) exemplifies a/an operator.
Conditional
Logical
Greater
Relational
In a computer spreadsheet, the tool used to construct formula is called
Filter
Formula bar
Format painter
Cells
_____ is not function in Excel?
Max
Subtract
Min
Sum
Which keyboard shortcut is used to easily switch open workbooks?
Ctrl + Tab
Ctrl + Enter
Ctrl + S
Ctrl + Open
The placement of information within a cell at the left edge, right edge, or center is:
Indentation
Placement
Alignment
Identification
What is the maximum number of slides you can add in a PowerPoint presentation?
100
250
400
There is no maximum limit
Which is these sections does a slide layout NOT have?
Lists
Animations
Titles
Charts
What is the PowerPoint standard layout?
Compares
Title Only
Blank
Title slide
Which view displays the text of the slide only?
Bullet View
Text View
Outline View
Notes View
Which one the following is a free e-mail service provider?
Foxit pdf editor
Safari
Gmail
None of the above
Which one of the following is used for file compression?
Google Chrome
WinZip
7-Zip
Both B & C
Which of the following is an online meeting platform?
Zoom
Google Meet
Both A & B
None of the above
What is the purpose of “Mail Merge”?
To create personalized letters or labels
To merge two images in a slide
To attach files to an e-mail
To encrypt a document
How do you use the “Format Painter” tool?
Select text, click Format Painter on Home, then select the text to apply formatting
Open Insert tab, choose Paint Styles, then save the file
Right-click the status bar and toggle Format Painter
Go to View tab and switch to Painter mode
What is COUNT() function in Excel normally used for?
Counting cells that contain numbers or dates, excluding blanks and text
Counting all cells in a range including blanks
Summing numeric values in a range
Averaging numbers in a list
Which Excel function removes irregular spacing, leaving one space between each value?
CLEAN
TRIM
SUBSTITUTE
PROPER
What is Slide Sorter view?
A view that shows thumbnails of slides for easy rearrangement
A full-screen presentation view
A view to edit slide notes only
A view that hides all slides
What is the default file extension of PowerPoint files?
.docx
.xlsx
.pptx
.txt
Why is the “Wrap Text” feature used in MS Excel?
To split numbers into separate cells
To display longer text fully within a cell without overflowing
To merge adjacent cells automatically
To rotate text diagonally
Why are transitions useful in PowerPoint?
They make slides load faster on old computers
They make presentations more engaging and professional by smoothing the flow between slides
They automatically correct spelling on slides
They convert slides into a video file
How do you change the date and time of the system?
Control Panel > Devices and Printers
Settings > Time & Language > Date & time
Right-click Desktop > Refresh
Open Task Manager > Performance
Select the operating systems from the list.
Windows 10
macOS
Ubuntu (Linux)
Google Chrome
Adobe Reader
Which one is not word processing software?
WordPerfect
MS Word
Libra office
Preizi
What type of chart will you use to compare performance of sales of two product?
Column chart
Line chart
Bar chart
Pie chart
Which is not presentation software?
Google slide
Google sheet
Prezi
MS PowerPoint
Auto correct are originally designed to replace ____ words as you types?
Short, repetitive
Grammatical incorrect
Misspelled
None of these
Which type of templates provides all the user with a design concept, color scheme, and fonts for presentation?
Format
Content
Normal
Design
_____ excel function returns TRUE or FALSE based on two or more conditions?
AVERAGEIFS
=CONCAT
=COUNT
=AND
What is a motion path?
A type of animation entrance effect
A method of advancing slide
A method of moving items on a slide
All of above
Which is is the Right term of PowerPoint Presentation?
Slides
Clipart
Image
Chart
Which is the shortcut key for creating hyperlink?
Ctrl + E
Ctrl + K
Ctrl + H
Ctrl + Z
In google sheet, columns are presented by
Numbers
Letters
Letters and Number
Cells
Which feature is allowing you to narrow down the data in your worksheet?
Filters
Reporting
Sorting
Statics
Which sign is used in the formula to use absolute reference?
Underscore (_)
Dollar ($)
Equal (=)
Column (:)
What is a URL?
An acronym for Unlimited Resource for Learning
The address of document or “page” on the world wide web
A type of programming object
A computer software program
Which formats represents the number with the dollar ( )sign?[Forexample, 10000]
Automatic
Number
Currency
Time
Which ribbon tab in MS Word contains options for adjusting the margins and orientations of the document?
Reference
Insert
Home
Page layout
What is the purpose of Slide Master PowerPoint?
To add animations to slide
To record narration for slides
To record endnote for slides
To design and customize the appearance of all slide
Which is used to store firmware?
EPROM
ROM
RAM
PROM
Documents can be ______ with MS Word.
Created
Edited
Saved
All of the above
Which of the following is not a section break options?
Previous page
Next page
Even page
Odd page
To insert a new slide go to __ tab, in the slides group click new slide?
View
Layout
Insert
Home
A ______ is a central device that divides a network connection among several devices?
Router
Modem
Switch
Hub
How can you insert a new page in the middle of an existing document in Microsoft Word?
View tab
Ctrl + N
Click the page layout tab
Insert page break options
Which feature in PowerPoint allows you to add motion and visual effects to text or object on slide?
Slide sorter
Presenter view
Slide show view
Animations
How can you freeze the top row and the first column in Excel?
Use the freeze panes option under the view tab
Use the split option under the home tab
Use the freeze panes option under the home tab
Use the freeze panes option under the format tab
What is the purpose of the track change feature in MS Word?
It allows you to insert comments into the document
It keeps a record of all the changes made to the document
It automatically saves the document at regular intervals
It adjust the spicing between line of text
Which of the following are email service providers? Select all that apply.
Gmail
Outlook
AOL Mail
Yahoo Mail
iCloud Mail
Which of the following are antivirus software? Select all that apply.
Kaspersky
McAfee
Microsoft Defender
Norton 360
Avast
What does Unicode represent?
An international character encoding standard
A file compression utility for multimedia
A protocol for wireless networking
A markup language for web pages
What is Google Doc?
A desktop-only PDF editor for offline use
A programming IDE for writing Java code
A service that allows users to create and edit documents online and collaborate in real time
A browser extension for blocking ads
What does the “Collate” option in printing settings do?
Prints only odd-numbered pages
Ensures printed pages are arranged in the correct order for a document
Scales the document to fit on one page
Converts the document to grayscale
