WorksheetsUnderstanding Computer Hardware
Total questions: 100
Worksheet time: 1hrs 10mins
What is the main function of the CPU?
The CPU handles user interface design.
The CPU is responsible for network communication.
The CPU primarily manages memory storage.
The main function of the CPU is to execute instructions and process data.
What does RAM stand for?
Random Allocation Method
Random Access Memory
Readily Available Memory
Rapid Access Module
Name one type of storage device.
Hard drive
USB stick
Optical disc
Flash memory
What is the function of a power supply unit?
The function of a power supply unit is to store data for the computer.
The function of a power supply unit is to manage software applications.
The function of a power supply unit is to cool down the computer components.
The function of a power supply unit is to convert and supply electrical power to computer components.
What is the difference between SSD and HDD?
The main difference is that SSDs use magnetic disks while HDDs use flash memory.
HDDs are faster and more reliable than SSDs.
SSDs are cheaper and have larger storage than HDDs.
The main difference is that SSDs are faster and more durable than HDDs.
What component is responsible for cooling the computer?
Cooling fan
Graphics card
Motherboard
Power supply
What does the box with the red arrow pointing at means?
Font Style
Text Color
Bold
Font Size
The Insert WordArt button is located on the ___ Ribbon.
Design
Home
Insert
Layout
The title bar displays which of the following?
A quick way to find where commands are located in the application
Commands to manage work in documents
The name of the active location in the the document
The name of the current, active file
Which of the following items do people most commonly use the Word application to create?
Create database objects to manage data between systems
Create documents to distribute such as letters, brochures, and social media posts
Create slides to present content such as a meeting agenda
Create spreadsheets to track items such as budgets, lists, and timesheets
A set of commands and command groups at the top of the document window that you can minimize or hide.
Button
Group
Ribbon
Tab
The blank space around the boundaries of the document content.
Border
Indentation
Margin
Spacing
Keyboard Shortcut for New Document
CTRL + C
CTRL + D
CTRL + ENTER
CTRL + N
What is the shortcut key to print a document?
Alt + P
Shift + P
Ctrl + P
Ctrl + D
What does the box with the red arrow pointing at means?
Font Style
Text Color
Bold
Font Size
The Insert WordArt button is located on the ___ Ribbon.
Design
Home
Insert
Layout
The title bar displays which of the following?
A quick way to find where commands are located in the application
Commands to manage work in documents
The name of the active location in the the document
The name of the current, active file
Which of the following items do people most commonly use the Word application to create?
Create database objects to manage data between systems
Create documents to distribute such as letters, brochures, and social media posts
Create slides to present content such as a meeting agenda
Create spreadsheets to track items such as budgets, lists, and timesheets
A set of commands and command groups at the top of the document window that you can minimize or hide.
Button
Group
Ribbon
Tab
The blank space around the boundaries of the document content.
Border
Indentation
Margin
Spacing
Keyboard Shortcut for New Document
CTRL + C
CTRL + D
CTRL + ENTER
CTRL + N
What is the shortcut key to print a document?
Alt + P
Shift + P
Ctrl + P
Ctrl + D
It is known as the spreadsheet application.
MS Word
MS Excel
MS PowerPoint
MS Publisher
MS Excel is widely used for ______, financial application, statistics and engineering calculations.
accounting
word processing
photo editing
video editing
_______ is a rectangular area where a column and row intersect.
cell
column
row
sheet tab
To sort names in a worksheet, we can use ____ button
Here in Excel, Which button will you select to calculate total marks ?
Identify the Excel Icon.
What is the cell address of the pink cell?
A1
1A
D3
3D
An Excel file format extension is
doc
xls
txt
mp3
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this button used for?
Creating a new document
Opening a document
Saving a document
Inserting a picture
Which of these is the PASTE button?
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
Rows are__________groups of cells.
Diagonal
Horizontal
Slant
Vertical
Letters and ______ are accepted as contents of the cell.
Numbers
Letters
Words
Symbols
What is shortcut to exit Microsoft Excel?
Alt + F1
Alt + F2
Alt + F3
Alt + F4
In your opinion, what is the best application to organise information?
MS Excel
MS PowerPoint
MS Word
Other
To completely change the contents of a cell select the cell & type the new data & press (a) .
To select all the cells in a worksheet, press _________.
Ctrl + A
Ctrl + B
Ctrl + Z
Ctrl + Z
What can you adjust from the Page Design tab?
Grammar settings
Page orientation and size
Zoom level
Text alignment
What is the purpose of the Ruler in Microsoft Publisher?
To set paragraph indentation
To adjust page margins
To measure object sizes
All of the above
What tab do you use to adjust table properties?
Format
Design
Layout
Table Tools
How can you import pictures into your publication?
Through the Page Design tab
From the File menu
Using the Pictures option in the Insert tab
By dragging and dropping into the workspace
On which tab would you find margins and page orientation?
Home
Insert
Page Layout
Data
What is the shortcut key to bold the selected text in Microsoft Word?
Ctrl + B
Ctrl + I
Ctrl + U
Alt + B
How can you change the line spacing to double in a Microsoft Word document?
Format > Paragraph > Line Spacing > Double
Edit > Line Spacing > Double
Tools > Options > Double Line Spacing
View > Line Spacing Options > Double
Microsoft program that allows you to create and make a presentation is called as .............................
MS PowerPoint
MS Word
MS Excel
MS Paint
Which is the MS PowerPoint application logo?
MS PowerPoint Presentation consists of ....................
Pages
Worksheets
Slides
Quick Access toolbar is present on the title bar. You can perform many tasks with just one click.
True
False
Which one of the programs below is the PowerPoint presentation?
To add a theme to the slide, you will click ______________________ tab.
Insert
Home
Design
Viewing a presentation means to see your slides on a full computer screen.
True
False
INTERNET GIVES US ACCESS TO _______ ON ALMOST EVERY SUBJECT.
INSTRUCTION
INFORMATION
INSTALLATION
INTERNET STANDS FOR _____
INTERNATIONAL NETWORK
INFORMATION NETWORK
INVARIABLE NETWORK
_______ IS ONE OF THE MOST POPULAR SEARCH ENGINES
TROJAN HORSE
AVG
______ IS A FACILITY ON THE INTERNET TO SEND AND RECEIVE MESSAGES ANYWHERE AROUND THE WORLD IN REST TIME.
ANTIVIRUS
SOFTWARE
WHEN YOU VISIT ANY SITE, THE FIRST PAGE THAT OPENS IS CALLED
HOUSE PAGE
HOME PAGE
HAUNTED PAGE
VGA
USB Type A
Ethernet
HDMI
VGA
Ethernet
USB Type B
HDMI
Audio Input
Audio Output
Define Computer Port
A cable used to connect 2 electronic devices
A connection point or interface between a computer and a device
A special place where large amounts of data a temporarily stored
A part of the computer that houses the CPU
What does USB stand for?
Universal Serial Bus
Unedited System Bracket
Unified Sound Bar
Unique Sequencing Bus
What are VGA cables used for?
Video
Audio
Data Transfer
Power
What is HDMI used for?
Power
Video
Networking
Data Sharing
What is a computer?
A computer is case that manipulates information or data.
A computer is an electronic device that manipulates information or data.
A computer is powered box that manipulates information or data.
A computer has the ability to:
It has the ability to store, retrieve, and process data.
It has the ability to store, retrieve, and pastas data.
It has the ability to stage, retrieve, and process data.
Software is ...
Hardware for your computer
any set of instructions that tells the hardware what to do and how to do it
all hardware components
any set of instructions for you to read
A _____________is a computer that serves up information to other computers on a network.
Mainstay
Laptop
Desktop
Server
A PC and Mac are known as:
personal assistants
automated tellers
personal computers
What is the most common type of PC operating system
OS X
Lynux
Microsoft Windows
A _______ is a collection of all the files in an organisation
Record
Database
Field
What is an Computer Functions ?
gathers data, allows users to input data.
Input, Output, Process, Storage.
consist of step-by-step instructions that tell
the computer how to do its work.
Program
Data
Storage
Keyboard
____is information that a user physically enters into a computer by pressing a key on a keyboard, clicking a mouse, tapping a touch screen, pushing a button on a game controller, speaking into a microphone, etc.
input
output
storage
processing
____is the saving of information on memory chips, discs, or other storage media by a computer for later use.
input
output
storage
processing
A system for making digital resources publicly available over the internet using a web browser that paved the way for email, chatrooms, and social media sites.
World Wide Web
Microchip
Smartphone
Supercomputers
A mobile phone that functions as a computer and allows users to access the internet.
World Wide Web
Microchip
Smartphone
Supercomputers
CPU stands for?
Central Programming Unit
Computer Progress Unit
Computer Programming Unit
Central Processing Unit
Performs calculations (i.e. addition, division, multiplication, subtraction)
MAR (Memory Address Register)
MDR (Memory Data Register)
CIR (Current Instruction Register)
PC (Program Counter)
ALU (Arithmetic and Logic Unit)
Which device is used to record sound?
Keyboard
Mouse
Microphone
Joystick
