QUESTION 3: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Question 3
QUESTION 3: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet. Use absolute cell references only where necessary to ensure that form... show full transcript
Worked Solution & Example Answer:QUESTION 3: SPREADSHEET
Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 3 - 2016 - Paper 1
Step 1
3.1.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
Select cell A1 and use the 'Fill Color' tool in the toolbar to change the background color to any color of your choice.
Step 2
3.1.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
Highlight cells A1 through J1, then click on the 'Merge & Center' option in the toolbar to merge the cells.
Step 3
3.1.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 row 2, right-click and choose 'Format Cells.' Under the 'Alignment' tab, set the Orientation to 90 degrees.
Step 4
3.1.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.' Go to the 'Border' tab, select the red color, and apply it to the bottom border.
Step 5
3.2 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 cells C7 through C32. Right-click and choose 'Format Cells.' In the 'Number' tab, select 'Number' and set the decimal places to 2. Then select a custom format that displays negative numbers in red.
Step 6
3.3 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 select 'Format only top or bottom ranked values.' Set one for the highest and one for the lowest, applying the bold format.
Step 7
3.4 Use a combination of functions to extract the temperature in degrees Fahrenheit from cell C4 and insert it 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
In cell D4, use the formula: =MID(C4, FIND(' ', C4) + 1, LEN(C4)) * 9/5 + 32 to extract the Fahrenheit value.
Step 8
3.5 Add a formula in cell D7 using the temperature in degrees Celsius in cell C7.
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, enter the formula: =C7 * 9 / 5 + 32 to convert the Celsius temperature in C7 to Fahrenheit.
