WorksheetsFormative Assessment-10: Computer Operation Level-3 (Extraction)
Total questions: 100
Worksheet time: 50mins
Which feature usually used to create a document like newspaper?
Bullet & numbering stops
Table
Columns
Tab
What is the standard unit of Font size?
Centimeters
Bytes
Point
Inches
Which ribbon contains options related to font formatting in MS Word?
Draw
Home
Insert
Design
Zoom, Google Meet, Microsoft Team etc. are the
Validates sources for customer requirements
Way of communication
Channels of communication
Procedure and Matters
To set the transition speed, select
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
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
Which year Microsoft PowerPoint was introduced?
1989
1990
1987
1996
The process of transferring files from your computer to a computer on the Internet is called
Uploading
Forwarding
FTP
Downloading
How many keys are on the keyboard?
101
104
105
110
When is computer literacy day celebrated?
2 December
5 June
1 May
15 August
Windows, Linux and DOS are examples of
Application software
Operating system
Programming language
Utility software
Which one is not word processing software?
WordPerfect
MS Word
LibreOffice
Prezi
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 Slides
Google Sheets
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
Which 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 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 Sheets, columns are presented by
Numbers
Letters
Letters and numbers
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 (=)
Colon (:)
What is a URL?
An acronym for Unlimited Resource for Learning
The address of a document or “page” on the World Wide Web
A type of programming object
A computer software program
Which format 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 in PowerPoint?
To add animations to slide
To record narrations for slides
To record endnotes for slides
To design and customize the appearance of all slides
Which is used to store firmware
EPROM
ROM
RAM
PROM
Which of the following is not a section break option?
Previous page
Next page
Even page
Odd page
To insert a new slide, go to the ____ 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
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
Which of the following are email service providers? Select all that apply.
Gmail
Outlook
MySQL
Yahoo Mail
iCloud Mail
Which of the following are antivirus software? Select all that apply.
Kaspersky
Adobe Photoshop
Microsoft Defender
Norton 360
Avast
What is Unicode?
An international character encoding standard
A web browser
A video compression format
A cloud storage service
What is Google Docs?
A tool that allows users to create and edit documents online while collaborating with users in real time
A desktop-only word processor without collaboration features
An email client for managing messages
A graphics editor for images
Which ribbon tab contains option related to font formatting in MS Word?
Home
Insert
Review
Page layout
Which feature in ms word automatically creaks common spelling mistakes as you type?
Auto Format
Auto Create
Auto Complete
Auto Save
Which Ribbon tab ms word is used for setting the margins orientation and size of documents?
Home
Insert
reference
Page layout
How can you insert a picture form your computer into MS Word document
Go to the insert tab click on picture
Press ctrl+p
Use the insert tab and click on picture
Go to the view tab and click on layout
How can you change the line spacing in a Microsoft word document?
Use the layout tab and adjust the spacing option
Press Shift + Enter
Use the Home tab and adjust the font size
Use the Insert tab and insert a text box
Which view In PowerPoint allows you to see multiple slides at once for editing purposes?
Normal View
Slide sorter view
Slide show view
Notes page view
Which feature in PowerPoint allows you to rehearse timings for your slide show?
Slide sorter
Presenter View
Animation Pane
Slide show tab>Rehearse Timings
Which feature in PowerPoint allows you to add motion and visual effects to text or objects on slides?
Slide sorter
Animation Effect/Pane
Presenter View
Slide show View
How can you start a PowerPoint slide show from the beginning? Note: • Press F5> Start a presentation from the beginning • Press Shift F5>Start a presentation from the current slide • Press Alt F5>Start the presentation in presenter View.
Click on the slide sorter button
Press F5
Use the slide show tab and click on Start Slide Show
Right click and select Start from Beginning
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
Which function in excel is used to find highest value in a rage of cells?
=Max()
=Min()
=Sum()
All of them
The intersection of a column and row in a worksheet is called?
Box
Cell
Range
Page Break
What is the purpose of a section break (continuous) in a word document?
Divide a page into two sections within the same page
Insert page numbers automatically
Change font styles across document
Save the file with a new name
What is Google Meet used for?
Online video meetings and conferencing in Google Workspace
Editing spreadsheets offline
Designing graphics and logos
Hosting code repositories
What is utility tool or software? give an example.
Software that performs specific maintenance tasks like antivirus, backup, or disk tools
A programming language used to build applications
A hardware device used for storage
A social media platform for messaging
What does Google Mean?
Global Organization Oriented Group Language Earth
General Online Graphical Lookup Engine
Global Open Graph Language Extension
Generic Object-Oriented Global Engine
Why is it necessary for employees to provide unbiased an objective information to clients?
It fosters trust, ensures transparency, and helps clients make informed decisions
It reduces paperwork for employees
It guarantees higher profits on every sale
It replaces the need for customer service
Microsoft is a __________ Software?
Word Processing Software
Programing Software
Complier
System Software
Which of the following is not present in MS Word?
Italic
Bold
Magic Tool
Underline
From which menu tab do you create a new document?
File tab
Home tab
Insert tab
View tab
How to activate the Read Mode in MS Word?
Home Read Mode
Insert Read Mode
Reference Read Mode
View Read Mode
Which MS Word feature helps to prevent accidental changes to a document?
Restrict Editing
Track Change
Read Only Mode
Protect Document
_____ is not a valid data type in MS Excel?
Character
Label
Number
Date/Time
_____ is the correct syntax of IF() function?
=IF(Logical_Text, [Value of True],[Value of False])
IF(Logical_Text, [Value of True],[Value of False])
-IF(Logical_Text, [Value of True],[Value of Ture])
=IF(Logical_Text, [Value of True][Value of False])
Which keyboard shortcut is used to easily open workbooks?
Ctrl + N
Shift + N
Ctrl + M
Ctrl + Tab
In a spreadsheet letters are used to represent what?
Row
Column
Cell
Formula
The main window in a computer spreadsheet is called what?
Spreadsheet
Workbook
Worksheet
Account Book
In MS PowerPoint presentation, the design that regulates the layout and formatting in the slide is called what?
Template
Design plates
Placeholder
Blueprints
What is the shortcut key for duplicating a slide in MS PowerPoint?
Ctrl + M
Ctrl + D
Ctrl + C
Ctrl + P
Which term do we use when an image in clip art changes the direction that it was originally facing?
Group
Rotate
Flip
Mirror
What is the purpose of a section break (continuous) in a Word document?
Divide a page into two sections within the same page
Start a new document
Insert a page number
Change the document theme
Which command is used to wrap text around an illustration or image in Word?
Wrap Text (Text Wrapping)
Insert Caption
Align Left
Crop
How do you share your screen in Zoom?
Click the Screen Share button, then choose the screen or application window
Click Invite and add participants
Open Chat and paste the link
Click Record to start sharing
Which of the following is an example of utility software?
Antivirus software
Presentation software
Web browser
Word processor
What is the basic difference between Etiquette and Manner?
Etiquette is a code of behavior, while Manners refer to the behaviors themselves
Etiquette is informal habits, while Manners are laws
Etiquette is personal style, while Manners are grammar rules
Etiquette means fashion, while Manners mean tone of voice
Mention the use of the Snipping Tool.
Capture screenshots
Format documents
Measure network speed
Encrypt files
Which is not edition of MS Word?
MS Word 2019
MS Word 2010
MS Word 2007
MS Word 1206
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
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
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
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
What is the default PowerPoint standard layout?
Compare
Title Only
Blank
Title slide
View displays the text of the slide only
Bullet view
Text view
Outline view
Notes view
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
How do you use the “Format Painter” tool to copy formatting?
Select text, click Format Painter on Home, then select the target text
Open Insert tab, click Format Painter, then print the document
Right‑click text and choose Save As, then reopen the file
Type the same style name in both places and press Enter
Which Excel function removes the irregular spacing, leaving one space between each value?
CLEAN
TRIM
REPLACE
PROPER
What is slide sorter view?
A view that shows each slide as a thumbnail for easy reordering and organization
A view for entering speaker notes
A view for editing slide masters only
A view that plays the slideshow full screen
Why is the “Wrap Text” feature used in MS Excel?
To merge adjacent cells
To display long text on multiple lines within a cell instead of overflowing
To apply bold formatting to text
To freeze the first column
Why are transitions useful in PowerPoint?
They automatically correct spelling on slides
They make presentations more engaging and professional by creating a smoother flow between slides
They convert slides to video without animation
They lock the file to prevent edits
How can you change the system date and time in Windows?
Open Control Panel > Devices and Printers
Go to Settings > Time & Language and change Date & Time
Press Ctrl+Alt+Del and choose Date
Open File Explorer and rename the clock file
Which of the following lists only operating system software?
Photoshop, Safari, Foxit Reader
Windows 10, MacOS, Ubuntu
Gmail, Zoom, WinZip
Excel, PowerPoint, Word
What is the function of a search engine?
Present information to users
Download files
Do manual work
None
Which one is Social Media?
Google Meet
Microsoft Team
Zoom
Tweeter
Which one is Online Storage?
Zoom
Meet
OneDrive
Google Classroom
Which one is not in correct Email ID format?
nsda@gov.bd
122nsda@gmail.com
@nsda.com
nsda@gmail.com
Which one is an Input Device?
Scanner
Speaker
Monitor
Printer
