Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Question 3
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 3 - 2016 - Paper 1
Step 1
Change the background colour of cell A1 to any colour of your choice.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To change the background colour of cell A1, select cell A1, navigate to the 'Format' menu, and choose 'Cell'. From there, click on the 'Fill Color' option and select your desired colour.
Step 2
Merge cells A1:J1.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To merge the cells A1 through J1, highlight the cells A1 to J1, right-click, and select 'Merge Cells' or use the 'Merge' button in the toolbar.
Step 3
Rotate the headings of row 2 by 90 degrees.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select the cells in row 2 that you wish to rotate, go to 'Format', choose 'Text Rotation', and set it to 90 degrees.
Step 4
Change the colour of ONLY the bottom border of cells A2:J2 to red.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select cells A2 to J2, right-click and choose 'Format Cells'. Navigate to the 'Border' tab, select the bottom border style, choose red as the colour, and apply it.
Step 5
Use a data format to display all the negative numbers in cells C7:C32 in red and with TWO decimal places.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select the range C7:C32, open the 'Format Cells' option, choose 'Number', and set the decimal places to 2. Then, ensure you select a 'Custom' format that displays negative numbers in red.
Step 6
Use conditional formatting in column D to display the cell with the HIGHEST value AND the cell with the LOWEST value in bold.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Select the range in column D, go to 'Conditional Formatting', choose 'New Rule', and use the 'Use a formula to determine which cells to format' option. Apply the formula for the highest and lowest values and set the formatting to bold.
Step 7
Use a combination of functions to extract the temperature in degrees Fahrenheit from cell C4 into cell D4.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To extract the temperature, use the formula:
D4 = MID(C4,FIND(' ',C4)+1,LEN(C4))
This extracts the number after the space in cell C4.
Step 8
Add a formula in cell D7 using the temperature in degrees Celsius in cell C7 and convert it to degrees Fahrenheit.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In cell D7, use the formula:
D7=(C7∗9/5)+32
This formula converts the temperature from Celsius to Fahrenheit.
