Y8 Spreadsheet Final Quizizz

What does a formula do?

• calculates transporter cells

• calculates cells

• calculates transfixed cells

What is the divide sign on a computer?

• *

• ]

• /

Each cell in spreadsheets is unique. True or False?

• True

• False

What is the Fill Handle Button used for?

• To copy cells styling

• To copy only the data as text

• To copy the formula and move the referencing to the corresponding cell

• To copy only the data as a specific value

• To copy the formula and move the referencing to the alternate string value

Which formula is to find the average of cells from B15 to B17?

• =average(B15:B17)

• =average-b(15:17)

• average(B15:B17)

• =average(B15)+(B17)

What is the purpose of an If statement?

• to select data to present quantum data

• to identify select data to hide

• to check a value meets a certain criteria and display whether it has been met

• to check if a value is yes

Describe what this formula does? If(A3>10, “PASS”, “FAIL”)

• It checks if A3 Value is less then 10, if it is it says True

• It checks if the value in cell A3 is greater than 10, and if it is, it displays pass, otherwise fail

• If the cell A3 has the value greater than 20, it says Fail

What does a 'named range' mean?

• highlighting some cells

• highlighting some parts of cells

• naming a range of cells something specific

• naming a range of cells to reference sum formula

Spreadsheets are used in 'What If?' analysis. What does this mean?

• Using spreadsheets to calculate windows

• Using spreadsheets to calculate different seasons of games

• Using spreadsheets to calculate different scenarios

• Using spreadsheets to calculate different pattern reconstructions and making scenarios real

What does =Find() do?

• Finds a certain cell

• Finds a certain value in a cell