Year 9 - Lesson 1 - Spreadsheet Quiz

What is a formula?

• A function that adds together all values in a range of cells.

• A specific calculation performed in a cell using data from other cells.

• A formula that changes its cell references relative to where it is copied.

• A function that subtracts values in a range.

What is a relative formula?

• A formula that always refers to the same cell.

• A function that calculates a total.

• A formula that changes its cell references based on where it is copied.

• A calculation for percentages.

What does the SUM function do?

• Multiplies values.

• Adds all values in a range of cells.

• Divides numbers in a row.

• Formats data as percentages.

What is an absolute formula?

• A formula that changes depending on the row or column it's copied to.

• A function that always refers to the same cell regardless of where it is copied.

• A function that only works in the first row.

• A formula for currency calculations.

What does the ADD function do?

• Adds two or more values together.

• Multiplies values in adjacent cells.

• Formats values as currency.

• Divides one value by another.

A cell that contains currency data should be formatted as:

• Currency

• General

• Text

• Percentage

The formula =A1*$B$1 is an example of a(n):

• Relative formula

• Absolute formula

• Invalid formula

• Percentage formula

To calculate the total of cells A1 to A5, you would use the:

• SUM function

• ADD function

• AVERAGE function

• MULTIPLY function

The first column in a spreadsheet is usually used to store:

• Labels (e.g., names, categories)

• Numeric calculations

• Currency data

• Date formats

Formatting a spreadsheet correctly helps to make it:

• More difficult to read

• Easier to read

• Impossible to edit

• Larger in size