NSC Computer Application Technology Uses of common applications: Use formulae and/or functions fo

Question

Use formulae and/or functions for ALL calculations in the spreadsheet. Use absolute cell references only where necessary to ensure that formulae are correct when you copy it to other cells in the same column (copy down).

All formulae and/or functions should be inserted in such a manner that the correct results will still be obtained, even if changes are made to the existing data.

A study was done about all the species threatened with extinction. A summary of these threatened species has been stored in a spreadsheet.

Open the 4Species_Spesies spreadsheet and work in the Spec_Spes worksheet.

4.1 Change the height of row 1 to 30 pt.

4.2 Use a VLOOKUP function in cell B6 to determine to which type 'Birds' in cell A6 belongs by using the table in the Type_Type worksheet.

Ensure that this function will work correctly if copied to other cells.

4.3 Add a function in cell C10 to calculate the total number of vertebrate species.

4.4 Add a function in cell L5 to calculate the percentage of the total mammals threatened in 2014 (column K) in relation to the number of species evaluated (cell D10).

4.5 Insert a function in cell N6 to determine the severity level by using the severity percentage in column M as follows:

• A severity percentage of more than 50% is classified as 'Very Severe'.
• A severity percentage of more than 15% and less than or equal to 50% is classified as 'Severe'.
• A severity percentage of less than or equal to 15% is classified as 'Moderate'.

Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1

Worked Solution & Example Answer:Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1

Change the height of row 1 to 30 pt.

Use a VLOOKUP function in cell B6 to determine to which type 'Birds' in cell A6 belongs by using the table in the Type_Type worksheet.

Add a function in cell C10 to calculate the total number of vertebrate species.

Add a function in cell L5 to calculate the percentage of the total mammals threatened in 2014 (column K) in relation to the number of species evaluated (cell D10).

Insert a function in cell N6 to determine the severity level by using the severity percentage in column M.

Join the NSC students using SimpleStudy...