ICT Assessment Level 1 and Level 2

You have been asked to search the internet to find the date for the Brazil Olympic Games in 2016. Write down what would you type in the search bar?

Give one reason why you selected the URL above.

State what is wrong with this print screen? Identify how you could improve the image.

Identify which symbol is used at the start of every formula?

Write a formula below to calculate the Income for Irena Koslov?

Explain what the SUM function is used for?

Explain how ‘Absolute Referencing’ is used in a formula. Give an example.

Explain how this V Lookup formula works.

You need to create a graph to show the Hair Stylist and their Income. Circle the cells you would use?

Identify three examples of formatting the spreadsheet above.