Free Printable Conditional formatting | Starter Quiz

Worksheets

Name

Class

Date

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”)

Reset

Similar Resources on Wayground