To prevent unauthorised users from accessing the worksheet

To keep certain rows or columns visible while scrolling

To convert data into a fixed format

To hide sensitive information in the workbook

To create a chart

To add the contents of cells together

To change the appearance of cells in a range based on specified conditions

To make the contents of cells a different colour so that people can see them better

To display the average of a range of cells

Don't know

To count the number of cells that meet a specified condition

To search for a value in a vertical range and return a corresponding value from the same row

PivotTables

Data Validation

Goal Seek

Conditional Formatting