Photo AI
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1
Question 4
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... show full transcript
Worked Solution & Example Answer:Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2016 - Paper 1
Step 1
Step 2
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.
Answer
In cell B6, input the formula:
=VLOOKUP(A6, Type_Type!$A$2:$B$21, 2, FALSE)
This function looks up the value in A6 within the specified table range of the Type_Type worksheet, returning the corresponding type.
Step 3
Step 4
4.4 Add a function in cell L5 to calculate the percentage of the percentage of mammals threatened in 2014 (column K) in relation to the total number of species evaluated (cell D10).
Answer
In cell L5, calculate the percentage by entering the following formula:
=K5/D10
Make sure that cell L5 is formatted as a percentage.
Step 5
4.5 Insert a function in cell N6 to determine the severity level by using the severity percentage in column M.
Answer
In cell N6, implement a nested IF function to categorize the severity level based on the percentage:
=IF(M6>50,"Very Severe",IF(M6>15,"Severe","Moderate"))
This formula checks the severity percentage in column M and assigns the appropriate label.