Conditional formatting | Starter Quiz | Oak National Academy

How is data sorted in a spreadsheet?

• A-Z or Z-A

• B-C or Z-A

• Only A-Z

What does filtering in a spreadsheet allow you to do?

• Filtering allows you to add data

• Filtering allows you to delete specific data

• Filtering allows you to find specific data

Which AVERAGE formula is correct?

• =AVERAGE(D:D9)

• =AVERAGE(D4:D9)

• AVERAGE(D4:D9)

What does the COUNTIF formula do?

• Counts how many of a certain item there are

• Counts the column

• Counts the rows

Which is the correct IF formula?

• =IF( “Well Done”, “Try again” D4=3,)

• =IF(D4=3, “Well Done”, “Try again”)

• IF(D4=3, “Well Done”, “Try again”)