Introduction to Spreadsheets and Basic IT skills for KS3 Computer Science

Question 1

Which of the following is a popular browser?

Accepted Answer

Google Chrome

Question 2

Which of the following is an example of an operating system?

Accepted Answer

Windows 10

Question 3

What is the main purpose of a spreadsheet?

Accepted Answer

To organize and analyze data

Question 4

Which of the following is not a type of software?

Accepted Answer

Hard drive

Question 5

What is a hyperlink used for?

Accepted Answer

To create a connection to another webpage or file

Question 6

Which function calculates the average of a range of cells?

Accepted Answer

AVERAGE

Question 7

What is the intersection of a row and a column called?

Accepted Answer

Cell

Question 8

Which is an example of a storage device?

Accepted Answer

Hard Drive

Question 9

Which of these is an output device?

Accepted Answer

Speaker

Question 10

Which shortcut is used to copy a selected item?

Accepted Answer

Ctrl + C

Question 11

What is the main function of word processing software?

Accepted Answer

To write and edit text documents

Question 12

What does ‘IT’ stand for?

Accepted Answer

Information Technology

Question 13

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

Accepted Answer

Pie chart

Question 14

What is the purpose of the ‘SUM’ function in a spreadsheet?

Accepted Answer

To add numbers

Question 15

What is the output of =SUM(A1) if A1 to A5 contains the values 1, 2, 3, 4, and 5?

Accepted Answer

15

Question 16

What function finds the largest number in a range of cells?

Accepted Answer

MAX

Question 17

What is the purpose of a firewall?

Accepted Answer

To monitor and control incoming and outgoing network traffic

Question 18

What is the function of a search engine?

Accepted Answer

To find information on the internet

Question 19

What symbol is used to start a formula in a spreadsheet?

Accepted Answer

=

Question 20

What does RAM stand for in computing?

Accepted Answer

Random Access Memory

Question 21

In a spreadsheet, rows are identified by:

Accepted Answer

Numbers

Question 22

Which of the following is an input device?

Accepted Answer

Keyboard

Question 23

Columns in a spreadsheet are labeled using:

Accepted Answer

Letters

Question 24

What does the 'merge cells' option do?

Accepted Answer

Combines two cells into one larger cell

Question 25

What is the purpose of antivirus software?

Accepted Answer

To protect the computer from malware

Question 26

Which of the following is an example of spreadsheet software?

Accepted Answer

Google Sheets

Question 27

What is a ‘range’ in spreadsheet terms?

Accepted Answer

A group of cells

Question 28

What is a spreadsheet used for?

Accepted Answer

Calculating and organizing data

Question 29

What is the main purpose of email?

Accepted Answer

To send and receive messages electronically

Question 30

How do you change the number format of a cell to currency?

Accepted Answer

Format → Number → Currency

Question 31

How can you lock specific rows or columns in a spreadsheet for easy viewing?

Accepted Answer

Freeze Panes

Question 32

What function counts the number of numeric entries in a range?

Accepted Answer

COUNT

Question 33

What does the term ‘cell reference’ refer to?

Accepted Answer

The position of a cell (e.g., A1)

Question 34

Which key is commonly used to refresh a web page?

Accepted Answer

F5

Question 35

What does 'URL' stand for?

Accepted Answer

Uniform Resource Locator

Question 36

Which function key is used to enter full-screen mode in most browsers?

Accepted Answer

F11

Question 37

What is the formula for adding values in cells A1 and A2?

Accepted Answer

=SUM(A1,A2)

Question 38

What does a formula starting with =IF do?

Accepted Answer

Tests a condition and returns a result

Question 39

Which tool can be used to quickly copy formulas or values to adjacent cells?

Accepted Answer

Fill Handle

Question 40

What is the main purpose of an operating system?

Accepted Answer

To manage computer hardware and software

Introduction to Spreadsheets and Basic IT skills for KS3 Computer Science

Questions 40

Introduction to Spreadsheets and Basic IT skills for KS3 Computer Science

Questions 40