Year 9 Spreadsheet Quiz

What is a box on a spreadsheet known as?

Spot the bug: name = int(input("enter your name"))

What is wrong with this function? =AVARAGE(A1:B1)

• Should be spelt =AVERAGE()

• Nothing, it's fine

• The : should be a ;

• Needs a closing bracket

What is wrong with this function? =MAXIMUM(A1:B1)

• Should be =MAX(1A:1B)

• Should be =MAX(A1:B1)

• Should be =MAX(A1;B1)

• Should be =MAX(1A;1B)

What is the green square in the corner of a cell called on a spreadsheet?

What is wrong with this function? =IF(A1 > B1, "A1 is bigger than B1","False"

• Nothing, it is correct

• If should be lower case

• Missing a comma

• Missing an end bracket

In Excel, if I want to create a bar chart I click "insert", then click...

What is wrong with this function? =IF(A1 > B1, "A1 is bigger than B1, "False")

• Missing , after B1

• Missing " after B1

• Nothing, it's fine

• Too few arguments

What does this icon do?

In Excel, what does the COUNTIF function do?

• Nothing, you have made this function up

• Counts the number of cells according to a given value

• Counts the number of cells that have any value in them

• Nothing, it won't work because it needs to be in lower case