7.2 Spreadsheet End of Unit Assessment

What Tutor Group are you in?

• 7D
• 7P
• 7G
• 7S
• 7B

Define the term spreadsheet:

• A file that is used to store data and carry out simple and complex calculations
• A document where images and data can be stored
• A document that creates graphs
• A document that has cells and rows

There are many versions of spreadsheet software. Select TWO of the most commonly used versions below:

• Microsoft Excel
• Google Sheets
• Microsoft Access
• Google Docs

Identify an advantage of a spreadsheet:

• Teachers can use them for creating there shopping lists
• Automatic calculation and recalculation
• Creating reports
• Creating columns and rows of data entry

Select the symbol that represents division in a spreadsheet:

• +
• /
• x
• *
• <

Select the symbol that represents multiply in a spreadsheet:

• x
• xx
• =
• +
• *

Select the symbol that represents addition in a spreadsheet:

• x
• -
• =
• +
• *

Select the symbol that represents subtraction in a spreadsheet:

• x
• -
• =
• +
• *

Select the symbol that must be used at the start of every formula and function:

• =
• ==
• ++
• xx
• +

In the below screenshot what is the correct term for area the highlighted in red?

• Row
• Column
• Line
• Arrow