spreadsheet test

Spreadsheets can be used for

• calculations

• messaging

• games

• edit videos

match the following data types

• Date

• £7.50

• text

• 12/03/2025

• integer

• 07950 445 781

• currency

• 98

=SUM is used calculate the

• total

• smallest number

• largest number

• average

What does this do =A1 x A3

• multiplies the numbers

• divides the numbers

• error
  x is not the multiply symbol

• adds the numbers

What technique make a cell reference fixed when you copy a formula

• adding borders

• using ( )

• absolute cell reference

• single dollar sign

spreadsheets are fun

• Yes

• No

Match the following spreadsheet software

• Sheets

• Microsoft

• Calc

• Apple

• Excel

• LibreOffice

• Numbers

• Google

A mail ​ (a)   allows you to send ​ (b)   to many people from a ​ (c)   automatically

• merge
• letters
• list

A ​ (a)   and a ​ (b)   is needed to complete a mail merge

• template document
• list of people
• profile photo
• advanced calculations
• sample music

What coding language does Excel run?

• HTML

• PHP

• vba

• java