Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 8 Autumn - Understanding Spreadsheets and Computers 25-26

Total questions: 123

Worksheet time: 1hrs 3mins

Name
Class
Date
1.

What is the main purpose of a spreadsheet?

a)

To write essays

b)

To organise and analyse data

c)

To draw pictures

d)

To browse the internet

2.

Which of the following is a formula in a spreadsheet?

a)

=A1+B1

b)

Add A1 and B1

c)

A1 plus B1

d)

A1B1

3.

What does the SUM function do in a spreadsheet?

a)

Multiplies numbers

b)

Adds numbers together

c)

Finds the largest number

d)

Sorts numbers

4.

Which chart type is best for showing parts of a whole?

a)

Line chart

b)

Pie chart

c)

Scatter chart

d)

Column chart

5.

What does sorting data in a spreadsheet mean?

a)

Deleting data

b)

Arranging data in a specific order

c)

Hiding data

d)

Copying data

6.

Which function would you use to find the average of a set of numbers in a spreadsheet?

a)

=SUM()

b)

=AVERAGE()

c)

=MIN()

d)

=COUNT()

7.

What is the purpose of filtering data in a spreadsheet?

a)

To remove all data

b)

To display only the data that meets certain criteria

c)

To add new data

d)

To print the data

8.

Which of the following is NOT a valid spreadsheet cell reference?

a)

A1

b)

1A

c)

B2

d)

C10

9.

What is the first step in the fetch-decode-execute cycle?

a)

Decode

b)

Fetch

c)

Execute

d)

Store

10.

What does CPU stand for?

a)

Central Processing Unit

b)

Computer Power Unit

c)

Central Programming Unit

d)

Computer Processing Utility

11.

Which device is an input device?

a)

Printer

b)

Mouse

c)

Monitor

d)

Speaker

12.

Which device is an output device?

a)

Keyboard

b)

Scanner

c)

Monitor

d)

Microphone

13.

What is Moore’s Law?

a)

The speed of computers halves every two years

b)

The number of transistors on a chip doubles about every two years

c)

The price of computers doubles every year

d)

The size of computers doubles every year

14.

Which of the following is a function of the CPU?

a)

Storing data permanently

b)

Processing instructions

c)

Printing documents

d)

Displaying images

15.

Which of these is an example of e-safety?

a)

Sharing your password with friends

b)

Using a strong, unique password

c)

Posting your address online

d)

Meeting strangers from the internet alone

16.

What does the 'execute' stage do in the fetch-decode-execute cycle?

a)

Fetches the next instruction

b)

Decodes the instruction

c)

Carries out the instruction

d)

Stores the instruction

17.

Which of the following is the formula to multiply cell A1 by cell B1?

a)

=A1+B1

b)

=A1*B1

c)

=A1/B1

d)

=A1-B1

18.

What is the main function of a spreadsheet chart?

a)

To store data

b)

To visually represent data

c)

To delete data

d)

To print data

19.

Which of the following is an example of a spreadsheet function?

a)

=SUM(A1:A10)

b)

Add A1 to A10

c)

A1 plus A10

d)

A1A10

20.

Which of these is NOT an input device?

a)

Keyboard

b)

Mouse

c)

Printer

d)

Microphone

21.

What is the main purpose of e-safety?

a)

To make computers faster

b)

To protect users online

c)

To increase internet speed

d)

To improve graphics

22.

Which of the following is a good e-safety practice?

a)

Using the same password for every account

b)

Clicking on suspicious links

c)

Keeping your personal information private

d)

Posting your location online

23.

What does the 'decode' stage do in the fetch-decode-execute cycle?

a)

Fetches the instruction from memory

b)

Interprets what the instruction means

c)

Executes the instruction

d)

Stores the result

24.

Which of the following is a valid reason to use filtering in a spreadsheet?

a)

To delete all data

b)

To find specific information quickly

c)

To print the spreadsheet

d)

To change the font

25.

Which of the following is an example of an output device?

a)

Mouse

b)

Keyboard

c)

Printer

d)

Webcam

26.

What is the main component of a computer that carries out instructions?

a)

Hard drive

b)

CPU

c)

RAM

d)

Monitor

27.

Which of the following is a risk of not following e-safety rules?

a)

Improved computer performance

b)

Identity theft

c)

Faster internet speed

d)

Better graphics

28.

Which of these is NOT a type of chart you can create in a spreadsheet?

a)

Pie chart

b)

Bar chart

c)

Scatter chart

d)

Weather chart

29.

What is the correct formula to divide cell C2 by cell D2 in a spreadsheet?

a)

=C2+D2

b)

=C2*D2

c)

=C2/D2

d)

=C2-D2

30.

Which of the following best describes Moore’s Law?

a)

Computers get twice as heavy every two years

b)

The number of transistors on a chip doubles about every two years

c)

The price of computers halves every year

d)

The size of computer screens doubles every year

31.

Which of the following functions is used to display the highest value in a spreadsheet range?

a)

=COUNT(A1:A10)

b)

=SUM(A1:A10)

c)

=MAX(A1:A10)

d)

=MIN(A1:A10)

32.

Which of these is NOT a recommended e-safety measure?

a)

Being cautious with unknown emails

b)

Using strong passwords

c)

Updating antivirus software

d)

Sharing personal information publicly

33.

Which device is both an input and output device?

a)

Monitor

b)

Printer

c)

Touchscreen

d)

Speaker

34.

Which function in a spreadsheet finds the smallest value in a range?

a)

=AVERAGE()

b)

=COUNT()

c)

=MIN()

d)

=MAX()

35.

What is the role of the 'fetch' stage in the fetch-decode-execute cycle?

a)

Retrieves the instruction from memory

b)

Executes the instruction

c)

Interprets the instruction

d)

Stores the result

36.

Which of the following is an example of an output device?

a)

Printer

b)

Mouse

c)

Webcam

d)

Keyboard

37.

What is the term given to interest (small amount of money) added on top of what you usually put into a savings account over a period of time?

a)

Confounded interest

b)

Compound interest

c)

Contrive interest

d)

Conquest interest

38.

Why is it important to ensure you have good posture and positioning when sitting at a work station?

a)

Promote injury

b)

Reduces workspace

c)

Reduces foot room

d)

Reduces risk of injury

39.

Complete the missing word. This term describes the way you work at a workstation to ensure safety and productivity of the user. (a)   n_m_cs.

40.

What is the term given to keeping safe in a work place?

a)

Health & Space

b)

Hospitality & Satisfaction

c)

Health & Safety

d)

Health & Social Care

41.

Fill in the missing word

Delayed (a)   means when you save for an item to purchase it at a later date when you have sufficient funds.

42.

Why is delayed gratification a good way of making purchases?

a)

Shows you have impulse control/ will power

b)

It ensures you do not go into unnecessary debt

c)

Usually you make a saving as the item is cheaper by the time you have the funds

d)

All of the above

43.

Which of the following is an input device?

a)

Speaker

b)

Monitor

c)

Mouse

d)

Printer

44.

What is the main function of RAM in a computer?

a)

Displaying images

b)

Storing data permanently

c)

Processing instructions

d)

Storing data temporarily

45.

Which formula in a spreadsheet adds the values in cells B1 and C1?

a)

=B1-C1

b)

=B1*C1

c)

=B1+C1

d)

=B1/C1

46.

Which of the following is an input device?

a)

Printer

b)

Mouse

c)

Speaker

d)

Monitor

47.

Which function in a spreadsheet calculates the average of a range?

a)

=SUM()

b)

=MIN()

c)

=AVERAGE()

d)

=MAX()

48.

What should you avoid doing to stay safe online?

a)

Clicking on suspicious links

b)

Using privacy settings

c)

Creating strong passwords

d)

Updating your software

49.

Which formula would you use to multiply cell A3 by cell B3 in a spreadsheet?

a)

=A3+B3

b)

=A3*B3

c)

=A3/B3

d)

=A3-B3

50.

Which device is used to output sound from a computer?

a)

Scanner

b)

Keyboard

c)

Speaker

d)

Mouse

51.

What does the 'decode' stage do in the fetch-decode-execute cycle?

a)

Interprets the instruction

b)

Executes the instruction

c)

Fetches the instruction from memory

d)

Stores the result

52.

Which of the following is an example of a strong password?

a)

myname

b)

Qw!7xZ$2

c)

123456

d)

password123

53.

What does the MAX function do in a spreadsheet?

a)

Finds the largest number

b)

Finds the smallest number

c)

Adds numbers together

d)

Counts the number of cells

54.

Which device is used to input images into a computer?

a)

Speaker

b)

Monitor

c)

Scanner

d)

Printer

55.

Which function in a spreadsheet counts the number of cells with numbers in a range?

a)

=MIN()

b)

=COUNT()

c)

=SUM()

d)

=MAX()

56.

Which device is commonly used to input text into a computer?

a)

Keyboard

b)

Printer

c)

Speaker

d)

Monitor

57.

What should you do if you receive a suspicious email asking for personal information?

a)

Click on all links in the email

b)

Ignore or delete the email

c)

Reply with your details

d)

Forward it to friends

58.

Which of the following is an example of an input device?

a)

Printer

b)

Monitor

c)

Mouse

d)

Speaker

59.

What is the main function of the monitor in a computer system?

a)

To display output

b)

To input commands

c)

To process data

d)

To store files

60.

Which device is used to enter text into a computer?

a)

Monitor

b)

Printer

c)

Speaker

d)

Keyboard

61.

Which of the following helps protect your computer from viruses?

a)

Ignoring software updates

b)

Sharing passwords with friends

c)

Installing antivirus software

d)

Downloading files from unknown sources

62.

What does the SUM function do in a spreadsheet?

a)

Finds the average of numbers

b)

Adds numbers together

c)

Finds the largest number

d)

Counts the number of cells

63.

Which device is used to output sound from a computer?

a)

Scanner

b)

Mouse

c)

Keyboard

d)

Speaker

64.

Which formula would you use to add the values in cells A1 and B1 in a spreadsheet?

a)

=A1-B1

b)

=A1/B1

c)

=A1*B1

d)

=A1+B1

65.

Which device allows you to scan documents into a computer?

a)

Monitor

b)

Scanner

c)

Printer

d)

Speaker

66.

What is the main reason for using charts in a spreadsheet?

a)

To browse websites

b)

To play music

c)

To write text documents

d)

To display data visually

67.

Which of the following is used to store data temporarily while a computer is running?

a)

RAM

b)

Monitor

c)

Printer

d)

Hard drive

68.

What is the main function of the SUM function in a spreadsheet?

a)

To count the number of cells

b)

To sort data

c)

To add values together

d)

To find the largest value

69.

Which of these is an example of an input device?

a)

Monitor

b)

Mouse

c)

Projector

d)

Speaker

70.

Which function in a spreadsheet calculates the average of a range of numbers?

a)

=MIN()

b)

=SUM()

c)

=AVERAGE()

d)

=COUNT()

71.

Which device is used to display information from a computer visually?

a)

Keyboard

b)

Speaker

c)

Monitor

d)

Mouse

72.

What is the main purpose of using filters in a spreadsheet?

a)

To show only rows that match specific criteria

b)

To sort data alphabetically

c)

To add new columns

d)

To delete unwanted data

73.

Which function in a spreadsheet would you use to find the total number of cells that are not empty in a range?

a)

=SUM()

b)

=COUNT()

c)

=COUNTA()

d)

=COUNTBLANK()

74.

What is the main role of the 'execute' stage in the fetch-decode-execute cycle?

a)

To interpret the instruction

b)

To store the result

c)

To carry out the instruction

d)

To fetch the instruction from memory

75.

Which of the following is a recommended way to keep your computer safe online?

a)

Sharing login details

b)

Ignoring software updates

c)

Using weak passwords

d)

Installing antivirus software

76.

Which of the following is an example of an input device?

a)

Speaker

b)

Monitor

c)

Mouse

d)

Printer

77.

What does the 'execute' stage do in the fetch-decode-execute cycle?

a)

Stores the result

b)

Fetches the instruction from memory

c)

Interprets the instruction

d)

Performs the instruction's action

78.

Which function in a spreadsheet returns the largest value in a range?

a)

=COUNT()

b)

=MAX()

c)

=SUM()

d)

=MIN()

79.

Which function in a spreadsheet returns the smallest value in a range?

a)

=MAX()

b)

=MIN()

c)

=SUM()

d)

=COUNT()

80.

Which of the following is an input device?

a)

Printer

b)

Keyboard

c)

Speaker

d)

Monitor

81.

What is the main function of the CPU in a computer?

a)

To process instructions

b)

To display images

c)

To input data

d)

To store files permanently

82.

Which of the following is NOT an input device?

a)

Mouse

b)

Keyboard

c)

Monitor

d)

Webcam

83.

Which spreadsheet function returns the smallest value in a range?

a)

=MIN()

b)

=SUM()

c)

=MAX()

d)

=AVERAGE()

84.

What is a safe practice when creating passwords for online accounts?

a)

Sharing your password with friends

b)

Using 'password' as your password

c)

Using a mix of letters, numbers, and symbols

d)

Using your name and birthdate

85.

Which formula would you use to add cell C2 to cell D2 in a spreadsheet?

a)

=C2/D2

b)

=C2-D2

c)

=C2*D2

d)

=C2+D2

86.

What is the purpose of the 'decode' stage in the fetch-decode-execute cycle?

a)

To interpret the instruction

b)

To store the result

c)

To process user input

d)

To fetch the instruction from memory

87.

Which device is used to input text into a computer?

a)

Speaker

b)

Keyboard

c)

Monitor

d)

Printer

88.

Which function in a spreadsheet calculates the total of a range of numbers?

a)

=SUM()

b)

=MAX()

c)

=COUNT()

d)

=MIN()

89.

Which device allows you to both display images and receive touch input?

a)

Speaker

b)

Touchscreen

c)

Monitor

d)

Printer

90.

What is the role of RAM in a computer system?

a)

To store data temporarily

b)

To display graphics

c)

To print documents

d)

To input text

91.

Which formula would you use to subtract cell B4 from cell A4 in a spreadsheet?

a)

=A4*B4

b)

=A4-B4

c)

=A4+B4

d)

=A4/B4

92.

Which device is commonly used to capture photographs and input them into a computer?

a)

Printer

b)

Monitor

c)

Speaker

d)

Scanner

93.

What is the main purpose of using strong passwords for online accounts?

a)

To avoid updating passwords

b)

To share accounts with friends

c)

To protect accounts from unauthorized access

d)

To make accounts easier to remember

94.

Which of the following devices is used to capture images for a computer?

a)

Webcam

b)

Monitor

c)

Speaker

d)

Printer

95.

Which spreadsheet function would you use to count only the empty cells in a range?

a)

=MAX(A1:A10)

b)

=COUNT(A1:A10)

c)

=SUM(A1:A10)

d)

=COUNTBLANK(A1:A10)

96.

Which device is primarily used to convert physical documents into digital format?

a)

Scanner

b)

Speaker

c)

Monitor

d)

Keyboard

97.

Which of the following is a good practice for keeping your computer secure?

a)

Installing regular software updates

b)

Sharing your login details online

c)

Using the same password for every account

d)

Ignoring antivirus warnings

98.

Which device is used to capture sound and input it into a computer?

a)

Speaker

b)

Printer

c)

Microphone

d)

Monitor

99.

Which spreadsheet function would you use to add up all the values in a column?

a)

=AVERAGE()

b)

=COUNT()

c)

=MIN()

d)

=SUM()

100.

Which formula would you use to multiply cell C2 by cell D2 in a spreadsheet?

a)

=C2/D2

b)

=C2-D2

c)

=C2*D2

d)

=C2+D2

101.

Which of the following is an example of an input device?

a)

Speaker

b)

Mouse

c)

Printer

d)

Monitor

102.

Which function would you use to count the number of cells containing numbers in a spreadsheet range?

a)

=AVERAGE()

b)

=SUM()

c)

=MAX()

d)

=COUNT()

103.

Which device is used to control the pointer on a computer screen?

a)

Speaker

b)

Printer

c)

Monitor

d)

Mouse

104.

Which formula would you use to add cell C2 and cell D2 in a spreadsheet?

a)

=C2-D2

b)

=C2*D2

c)

=C2/D2

d)

=C2+D2

105.

What is the main function of a monitor in a computer system?

a)

To input data

b)

To output visual information

c)

To store data

d)

To process instructions

106.

Which of the following is a safe way to protect your online accounts?

a)

Sharing your password via email

b)

Enabling two-factor authentication

c)

Writing your password on a sticky note

d)

Using the same password everywhere

107.

Which spreadsheet function would you use to count the number of cells containing numbers?

a)

=SUM()

b)

=MAX()

c)

=COUNT()

d)

=MIN()

108.

Which device is commonly used to input text into a computer?

a)

Monitor

b)

Keyboard

c)

Printer

d)

Speaker

109.

Which of the following is an example of an input device?

a)

Monitor

b)

Printer

c)

Keyboard

d)

Speaker

110.

Which spreadsheet function returns the highest value in a range?

a)

=MIN()

b)

=SUM()

c)

=MAX()

d)

=COUNT()

111.

What is a recommended way to create a strong password?

a)

Use only lowercase letters

b)

Repeat the same character

c)

Include a mix of letters, numbers, and symbols

d)

Use your birthdate

112.

Which of the following is responsible for temporarily storing data while a computer is running?

a)

Monitor

b)

Printer

c)

Hard drive

d)

RAM

113.

Which formula in a spreadsheet multiplies the values in cells D1 and E1?

a)

=D1-E1

b)

=D1*E1

c)

=D1/E1

d)

=D1+E1

114.

What is a good practice to protect your personal information online?

a)

Posting personal details on public forums

b)

Using the same password for all accounts

c)

Sharing passwords with friends

d)

Enabling two-factor authentication

115.

Which device is commonly used to move the cursor on a computer screen?

a)

Printer

b)

Mouse

c)

Monitor

d)

Speaker

116.

Which spreadsheet function finds the highest value in a range?

a)

=MAX()

b)

=MIN()

c)

=SUM()

d)

=COUNT()

117.

What is the main purpose of two-factor authentication?

a)

To make logging in faster

b)

To provide extra security for accounts

c)

To share passwords easily

d)

To store files online

118.

Which of the following is NOT an input device?

a)

Mouse

b)

Keyboard

c)

Monitor

d)

Scanner

119.

What is the main function of the 'decode' stage in the fetch-decode-execute cycle?

a)

To display the output

b)

To fetch the instruction from memory

c)

To interpret the instruction

d)

To store the result

120.

Which spreadsheet function returns the largest value in a range?

a)

=MIN()

b)

=SUM()

c)

=MAX()

d)

=COUNT()

121.

Alan Turing created a computer that

a)

Created the first calculator

b)

Broke the Enigma code, the German communication system

c)

Created Boolean Logic

d)

Created the Colossus machine

122.

Who created the Colossus, the machine that broke the Lorenz code, the German communication system that came after Enigma

a)

Jon von Neumann

b)

Bill Gates

c)

Alan Turing

d)

Tommy Flowers

123.

What did Jon von Neumann create?

a)

Fetch Decode Cycle

b)

Execute Fetch Decode cycle

c)

Fetch Decode Execute cycle

d)

Decode Fetch Execute cycle

Similar Resources on Wayground

تصميم وتكنالوجيا

122 questions

تصميم وتكنالوجيا

quiz

Worksheet

•

5th - 7th Grade

KUIS TIK kelas 7

120 questions

KUIS TIK kelas 7

quiz

Worksheet

•

7th Grade