Font size
WorksheetsIT Support Service Level 3 Formative assessment 4
Total questions: 66
Worksheet time: 56mins
Which one is not a bangla font?
Arial
Kalpurush
Solaiman Lipi
Nikosh
Which one is a cell address in a spreadsheet?
5A
A5
@A5
A@5
Select the function for calculating the remainder of a division operation.
mod()
Reminder()
Remdiv()
Divrem()
'=if' is a _______ type of function in MS-Excel?
mathematical
Logical
Comparison
Relational
What PowerPoint feature will you use to apply motion effects to different objects of a Slide?
slide transition
Slide design
Animation object
Animation scheme
Which of the following is not a part of slide design?
Design template
Color scheme
Animation scheme
Slide layout
A microprocessor unit, a memory unit and an input/output unit form a:
CPU
Compiler
Microcomputer
ALU
The full form of SSD is
solid state device
Solid state drive
Secondary storage device
Secondary storage drive
Which provides the fastest data access time?
RAM
ROM
CD-ROM
Hard disk
A hard disk is divided into tracks which are further subdivided into:
clusters
Sectors
Vectors
Heads
From what location are the 1st computer instructions available on boot up?
ROM BIOS
CPU
Boot ini
CONFIG.SYS
ASCII stands for
American standard code for information interchange
American standard code for information interaction
All standard code for information interchange
All standard code for information interaction
The standard internet protocol is:
FTP
UDP
TCP/IP
TCP
The operating system manages:
Memory
Processor
Disk and I/O devices
All
Which is a search engine?
google chrome
Microsoft edge
MSN
Yellow page
How to open an email account?
Login
Signin
Sign account
Sign up
Which is not a cloud storage?
One Drive
Google Drive
Hard disk drive
Mega Drive
Which one is not social media?
Youtube
Google docs is a ______.
social media
One line storage
Online word processor
Cloud storage
Which is a volatile memory?
RAM
ROM
SSD
EPROM
Which one is not a part of system Unit?
scanner
Processor
RAM
HDD
The full form of OSH is
occupational safety and health
Official safety and health
Official health and safety
Occupational health and safety
Which class of IP 172.16.10.125 is?
class A
Class B
Class C
Class D
How many bits are in a MAC address?
32
38
48
64
Write down the meaning of WPM in typing.
What is the main difference between SAVE and SAVE AS?
What is the difference between formula and function in worksheet?
What is the main difference between router & switch?
What is the function of NIC?
What is the primary function of spreadsheet software?
creating and editing text documents
Creating and editing image and graphics
Creating and managing numerical data and calculations
Designing presentation
An excel workbook is a collection of?
workbooks
Worksheets
Charts
Worksheets and charts
Which effect we see as the slides of a PowerPoint changes over?
animation
Timing
Effect
Transition
In excel, what does the term 'data validation' refer to?
checking for errors in formula
Ensuring data accuracy through validation rules
Protecting data from unauthorized access
Sorting data in ascending order
In excel what does the function COUNTA() do?
counts the number of cells in a range that are not blank
Counts the number of cells in a range that are greater than zero
Count the number of cells in a range that contain text
Count the total number of cells in range
What happens when you click on CTRL+X after selecting some cells in excel?
the cell content of selected cells disappears from cell and stored in clipboard
Value is the cells selected are marked for cutting.
The selected cells are deleted and the cells are shifted left
The selected cells are deleted and cells are shifted up
The greater than sign(>) exemplifies a/an____________ operator.
arithmetic
Conditional
Logical
Greater
A saved document is referred to as a ____________?
File
Word
Folder
Project
Which of the following is considered an output peripheral in a computer system?
mouse
Monitor
Hard Drive
Keyboard
The place where accessories are connected in computer is known as?
port
Ring
Bus
Zip
Which of the following are input devices?
monitor
Printer
Scanner
Plotter
A program that provides software interface to hardware devices is called_____________
system software
Application software
Device Driver
All of the above
A region of computer memory where frequently accessed data can be stored rapid access is called?
cache
Token
Cookie
Plug-in
The programs which are as permanent as hardware and stored in ROM is known as?
hardware
Software
Firmware
ROMware
Keyboard converts typed in character to ______________code?
EBCIDIC
ASCII
decimal
Binary
You are the new IT admin, and you need to find the network configuration. What should you use?
ipconfig
Cmd
Netchange
Newnet
Office LANS which are scattered geographically on large scale, can be connected by the use of corporate?
CAN
DAN
LAN
WAN
What is the purpose of disaster recovery planning in computer system?
to create regular data backups
To prevent data loss
To ensure business continuity in case of disasters or data loss event
To encrypt data
What is a hot backup in the context of data backup methods?
A backup created while the system is running and fully operational
A backup stored in a location with a high temperature
A backup stored in the cloud
A backup created during system downtime
What is unicode?
Represents symbols or characters used in any language
Only few languages are supported
Supports only few characters
Characters from A to Z
The shortcuts that appear on the desktop is called:
image
My document
Icon
My computer
Which of the following is the brain of the computer?
Central processing unit
Memory
Arithmetic and logic unit
Control unit
Which of the following is designed to control the operations of a computer?
user
Application software
System software
Utility software
Which of the following does computer hardware consist of?
CPU
All of the above
I/O devices
Storage devices
When you delete a file in your computer, where does it go?
recycle bin
hard disk
Taskbar
None of these
What is DNS?
What is 'bandwidth'?
What are 'firewalls'?
What is cache memory?
A microprocessor unit, a memory unit and input output unit form a?
CPU
Compiler
Microcomputer
ALU
Which of the following is not a computer bus?
data bus
Timer bus
Control bus
Address bus
The brain of any computer system is.
ALU
Memory
CPU
Control unit
The personnel who deal with the computer & its management put together are called?
software
Human
Firmware
Hardware
A microprocessor is __________.
combined unit of monitor and keyboard.
Combined unit of ALU and CPU
Combined unit of CPU and UPS
None of these
When bearing in the power supply fan goes out, what should you replace?
fan
Case
Bearing
Power supply unit
All operating systems get their total memory initialized from?
CPU
BIOS
ROM
RAM
Which provided the fastest data access time?
clusters
Sectors
Vectors
Heads
