Year 7 End of Unit Assessment - Spreadsheet

Which of the following is used to begin a formula in Excel?

• +

• =

• *

• /

Which of these is a row labeled with?

• Letters

• Numbers

• Symbols

• Formulas

Which of these is an example of a value?

• Name

• Total

• 300

• Label

What is a spreadsheet mainly used for?

• Writing stories

• Making presentations

• Storing and calculating data

• Drawing pictures

What is a function in a spreadsheet?

• A set of data

• A type of cell

• A preset formula

• A visual tool

What would you use to add up values in a column?

• A chart

• A label

• SUM function

• A row

What is the purpose of a label in a spreadsheet?

• To calculate values

• To reference cells

• To describe data

• To store numbers

Which of these is NOT part of a spreadsheet?

• Cell

• Page

• Column

• Row

Which function is used to find the average in Excel?

• SUM()

• AVG()

• AVERAGE()

• MEAN()

How many worksheets can a spreadsheet have?

• Only one

• Two

• Multiple

• None