Font size
WorksheetsYear 8 Spreadsheets and computer hardware/storage
Total questions: 79
Worksheet time: 55mins
What is the main function of a spreadsheet formula?
To create colourful charts
To perform calculations automatically
To store large amounts of data
To design web pages
Which of the following is an example of a computer hardware component?
Microsoft Word
Google Chrome
Hard Drive
Dropbox
Which of these is a type of storage device?
Monitor
Keyboard
USB Flash Drive
Mouse
What is cloud storage primarily used for?
Storing data on physical devices
Storing data on remote servers accessible via the internet
Printing documents
Designing graphics
Which of the following is a spreadsheet function that calculates the average of a range of numbers?
SUM
AVERAGE
MAX
MIN
What unit is commonly used to measure the capacity of a storage device?
Metres
Ounces
Gigabytes
Celsius
Which of the following is NOT a type of computer hardware?
CPU
RAM
Operating System
Motherboard
What is the primary advantage of using cloud storage?
It is always free
It allows access to data from any device with internet
It never requires updates
It increases the speed of your computer
Which of the following formulas would you use to add the values in cells A1, A2, and A3 in a spreadsheet?
=A1×A2×A3
=A1+A2+A3
=A1−A2−A3
=A1/A2/A3
Which of these is a benefit of using a solid-state drive (SSD) over a traditional hard disk drive (HDD)?
SSDs are heavier
SSDs have moving parts
SSDs are faster
SSDs are more prone to damage
What is the space within the black border?
a cell
a box
a variable
a column
When you type a formula, what symbol must it start with?
!
*
+
=
In a cell reference, for example B2, what does the letter refer to?
The row the cell is in.
The worksheet the cell is in
The column the cell is in.
The spreadsheet the cell is in.
What would a spreadsheet be best used for?
Writing a letter
making a presentation
keeping track of your savings or money
searching for information
In a cell reference, such as B2, what does the number stand for?
the column the cell is in
the worksheet the cell is in
the row the cell is in
the value of the cell
Mathematical calculations in a spreadsheet are called:
words
values
formulas
labels
What function will add up all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
Which of the following is an example of a multiplication formula?
A-B
=C10-B9
14 x 10 = 140
=B2*B3
Which of the following cannot be used to create a spreadsheet?
Microsoft Excel
Google Sheets
Google Docs
Open Office Calc
Which of the following is an example of an addition formula?
=B4+D7
2+3+6=11
F3*G7
=B9/B6
What kind of a chart is this?
a pie chart
a bar chart
a cake chart
a line graph
What kind of a chart is this?
A line graph
A bar chart
A pie chart
Scatter Chart
What does CTRL Z do?
Cut
Undo
Paste
Copy
Tatsuo Horiuchi uses spreadsheets to create art. Which of the examples below do you think is a real use of a spreadsheet?
Create a full length role playing game.
Convert a photo into a spreadsheet
Create a sudoku
All three!
What function will calculate the AVERAGE of all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
Which symbol is used at the beginning of all formulae and functions?
+
-
=
$
Which symbol is used in a formula for adding?
*
-
/
+
Which symbol is used in a formula for subtracting?
*
-
/
+
Which symbol is used in a formula for multiplying?
*
-
/
+
Which symbol is used in a formula for dividing?
*
-
/
+
What is the formula to add up A1 and B1?
=SUM(A1:B1)
=A1+B1
A1+B1
=ADD(A1:B1)
What is the formula to work out A2 take away B2?
A2-B2
=A2-B2
=SUB(A2:B")
=A2MINUSB2
What is the formula to multiply A3 by B3?
=MULTIPLY(A3:B3)
=A3xB3
=A3*B3
=A3TIMESB3
What is the formula to divide A4 by B4?
=A4÷B4
=A4DIVIDEB4
=A4\B4
=A4/B4
What is the function to add up A1 to B5?
=A1+A2+A3+A4+A5+B1+B2+B3+B4+B5
=(A1:B5)
=SUM(A1:B5)
=ADD(A1:B5)
What is the function to find out the average of A1 to B5?
=(A1+A2+A3+A4+A5+B1+B2+B3+B4+B5)/10
=SUM(A1:B5)/10
=A1:B5)AVERAGE
=AVERAGE(A1:B5)
What is the difference between a formula and a function?
Nothing. They are exactly the same.
a formula uses words and functions use mathematical symbols.
A formula is input entirely by the user using cell references and mathematical symbols. A function uses a predefined formula, usually in the form of a word.
A formula starts with an = sign but a function doesn't.
What is the function to find out the lowest number in cells A1 to B5?
=LOWEST(A1:B5)
=LOW(A1:B5)
=MIN(A1:B5)
=MAX(A1:B5)
What is the function to find out the highest number in cells A1 to B5?
=HIGHEST(A1:B5)
=HIGH(A1:B5)
=MIN(A1:B5)
=MAX(A1:B5)
Which one is the advantage of cloud storage?
The user has no control over their data
Many programs can be run at the same time, regardless of the processing power of your device
Accessible anywhere with an internet connection
Portability
What is cloud computing?
Storing files on the Internet
Running programs on a remote server
Running an operating system
All of the above
What is cloud storage
Servers hidden in clouds
Closed Locations Of Underground Drill Storage
A type of storage that can be accessed with an internet connection
A type of storage that can be accessed in the clouds
Does cloud storage have to be free
Yes
No
Why would I know??!?1?
Which of these is an example of cloud storage
Google Drive
SSD's
Apple Iphones
Linux
Does Apple have their own cloud storage?
Yes
No
What is a disadvantage of cloud computing?
It is vulnerable to hacking
The storage can be easily expanded
Portability
All of the above
Who is believed to have invented cloud storage?
Ada Lovelace
J. C. R. Licklider
Bill Gates
Steve Jobs
What can you store on the cloud server?
documents
videos
music
all of the above
Backups protect against data loss due to...
file corruption
hardware failure
hardware failure and file corruption
neither
Which of the following backup options are considered removable media?
USB flash drives
NAS devices
Cloud storage
Local SATA drives
•You don’t need a powerful computer with a huge hard drive – everything is stored and run on a remote computer. You can this advantage on?
the Internet
Local area networks
optical devices
cloud storage
What is the main circuit board of a computer called?
Motherboard
CPU
RAM
Hard drive
What component is often referred to as the 'brain' of the computer?
RAM
Power supply unit
Motherboard
CPU
Which type of memory is considered short-term and is erased when the computer is turned off?
Optical drive
CPU
RAM
Hard drive
Michael is setting up his new computer. What is the function of the power supply unit in his computer?
To connect to the internet
To process instructions
To convert power from the wall outlet
To store data permanently
Which component is responsible for what you see on the monitor?
Network card
Sound card
Bluetooth card
Video card
Arjun wants to connect his computer to the Internet. What component does he need?
To increase processing speed
To store data
To improve sound quality
To connect to a network and access the Internet
Arjun is learning about computers in his class. His teacher asks, 'What does RAM stand for?'
Remote Access Memory
Random Access Memory
Read Access Memory
Rapid Access Memory
What is the function of a heat sink?
To store data
To connect to the internet
To improve video quality
To absorb heat from the CPU
Michael is setting up a new home office and wants to connect his wireless headphones to his computer. Which component should he use for wireless communication over short distances?
Network card
Sound card
Video card
Bluetooth card
Aria is building a custom gaming computer. What is the role of expansion cards in her computer?
To provide additional storage
To enhance or add new capabilities
To cool the CPU
To power the computer
The (a) is the computer's main circuit board. It's a thin plate that holds the (b) , (c) , connectors for the hard drive and optical drives, expansion cards to control the video and audio, and connections to your computer's ports (such as USB ports). The motherboard connects directly or indirectly to every part of the (d) .
motherboard
CPU
memory
computer
keyboard
monitor
printer
iPhone 15
mouse
scanner
The (a) (CPU), also called a (b) , is located inside the computer case on the (c) . It is sometimes called the (d) of the computer, and its job is to carry out (e) . Whenever you press a key, click the mouse, or start an application, you're sending instructions to the CPU.
central processing unit
processor
motherboard
brain
commands
graphics processing unit
hard drive
power supply
gps
tmobile chip
RAM is your system's (a) memory. Whenever your computer performs (b) , it temporarily stores the (c) in the RAM until it is needed.
short-term
calculations
data
long-term
graphics
files
video card
memory card
Label the parts of the computer.
monitor
keyboard
printer
Speaker
webcam
tower
Identify which image is a Hard Drive and a Solid-State Drive
A computer uses a combination of :
hardware and software
line paper and white paper
monitor and digital pixels
keyboard and mouse
The CPU is the internal operating unit or brains of your computer.
False
True
Central Processing Unit (CPU)
Computer Case
Monitor
Hard Drive
Keyboard
The CPU fits into the motherboard's CPU socket, which is covered by the ____, an object that absorbs heat from the CPU.
Sink
Heat Sink
Fan
Ice
What does CPU stand for?
Central Processing Unit
Control Processing Unit
Computer Power Unit
Core Processing Unit
Central Processing Unit
