Y6 CCC Spreadsheets

To format multiple cells, what should be highlighted?

• A single cell

• A range of cells

• The entire spreadsheet

• The title

Why might we use a spreadsheet for calculations?

• It makes the data look colourful.

• It helps to quickly perform calculations and analyse data.

• It is more fun than using a calculator.

• It can be used to draw pictures.

What can spreadsheets create?

• Charts

• Music

• Videos

What is the first step in writing a formula in a spreadsheet?

• Start with a number

• Start with a letter

• Start with an equal sign

• Start with a symbol

How can you use the same formula in multiple cells?

• Write the formula again in each cell

• Copy the formula and paste it into other cells

• Write a different formula in each cell

• Use a calculator

What is the purpose of using cell references (A1, B2 etc) in formulas?

• To make the spreadsheet look more complex

• So the spreadsheet updates when data changes

• To add colors to the cells

• To create hyperlinks

What does cell A1 contain?

• Sweet
• Mars
• A1
• Cost

What is the name of a "box" on a spreadsheet?

• Cell

• Box

• Rectangle

What is the correct order for a Cell Reference?

• Letter then Number

• Number then Letter

What is used to perform calculations in a spreadsheet?

• Magic

• Formula

• Conditional formatting

• Macro