Conditional formatting

Computing

What symbol must you use at the beginning of a cell when you want to use a function or a formula in that cell?

Name a function that tells you the maximum value.

Name a function that tells you the minimum value.

Name a function that tells you how many non-blank values there are.

What would be the easiest way to total several values together?

Can you give the cell references for each of the following range in cells row 15–20 in column A

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

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

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

A secondary source is a source which you have found and may decide to use.

A secondary source is the same as a primary source, except it looks prettier, like a chart.

A secondary source is when you decide to carry out a survey.

This is when the spreadsheet highlights cells of a similar criteria.

This is when the spreadsheet moves the data to the correct place.

This is when the spreadsheet selects the cells it wants to highlight

Filtering allows you to delete specific data

Filtering allows you to find specific data

What does filtering in a spreadsheet allow you to do?

Counts how many of a certain item there are