KS2 Computing/ICT Quiz

What is a spreadsheet primarily used for?

• Writing essays

• Organizing and calculating data

• Drawing pictures

• Playing games

Which symbol is used to start a formula in most spreadsheet programs?

• =

• +

• #

• @

What is a cell in a spreadsheet?

• A type of formula

• A single box where a row and column meet

• A type of chart

• A type of font

Which function adds up a range of numbers in a spreadsheet?

• AVERAGE

• SUM

• COUNT

• MAX

What is the name of the horizontal sections in a spreadsheet?

• Columns

• Rows

• Cells

• Sheets

Which of the following is an example of spreadsheet software?

• Microsoft Word

• Microsoft Excel

• Adobe Photoshop

• Google Slides

What does the formula =A1+B1 do?

• Multiplies the values in A1 and B1

• Adds the values in A1 and B1

• Subtracts the value in B1 from A1

• Divides the value in A1 by B1

What is a chart in a spreadsheet used for?

• To write text

• To visualize data

• To create formulas

• To delete data

Which of the following is NOT a type of chart in spreadsheets?

• Pie chart

• Bar chart

• Line chart

• Paragraph chart

What does the term 'cell reference' mean?

• The name of a spreadsheet

• The address of a cell, such as A1 or B2

• A type of formula

• A type of chart