Exercise Spreadsheet P6

What is done using the Sort & Filter tool in Spreadsheet?

• Delete unwanted data

• Calculate the amount of data

• Arrange data in alphabetical order

• Show only selected data

What are the functions of MAX and MIN in a Spreadsheet?

• Calculate the total data

• Save file

• Find the highest and lowest value in the data

• Delete filter

What is done by clicking 'Boy' after selecting 'Gender' in step 8?

• Show only male data

• Remove filter

• Save file

• Show only female data

What is done by clicking 'Select All' after selecting 'Gender' in step 7?

• Delete filter

• Show only female data

• Show all data without filter

• Save file

What is done by clicking 'Clear' after selecting 'Sort & Filter' in step 1?

• Show all data without filter

• Show only female data

• Save file

• Delete filter

What is done by clicking 'OK' after selecting 'Boy' in step 9?

• Delete filter

• Show all data without filter

• Show only male data

• Save file

What is done by clicking 'OK' after selecting 'Girl' in step 10?

• Save the file

• Show only female data

• Show all data without filter

• Remove filter

What does clicking 'OK' after selecting 'Remove Filters' do in step 2?

• Show only female data

• Remove filter

• Show all data without filter

• Save file

What is the purpose of clicking 'Confirm' after selecting 'Male' in step 9?

• Delete the filter

• Show all data without filter

• Show only male data

• Save the file

What action is performed by clicking 'Confirm' after selecting 'Female' in step 10?

• Save the file

• Show only female data

• Show all data without filter

• Remove the filter