3.1 Format the cells in row 1 as follows:
3.1.1 Change the merged cell to only include cells A1:O1 - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Question 3
3.1 Format the cells in row 1 as follows:
3.1.1 Change the merged cell to only include cells A1:O1.
3.1.2 Apply a 'Thin Diagonal Stripe' pattern style fill effect ... show full transcript
Worked Solution & Example Answer:3.1 Format the cells in row 1 as follows:
3.1.1 Change the merged cell to only include cells A1:O1 - NSC Computer Application Technology - Question 3 - 2017 - Paper 1
Step 1
Change the merged cell to only include cells A1:O1.
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 merged cell, select the merged area spanning A1:O1. Right-click and select 'Format Cells,' then choose 'Alignment.' Uncheck 'Merge Cells' and merge A1:O1 only again to include only those cells.
Step 2
Apply a 'Thin Diagonal Stripe' pattern style fill effect to the merged cell.
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
Select the merged cell A1:O1, go to the 'Home' tab, click on the 'Fill Color' dropdown, select 'Fill Effects,' and then choose the 'Pattern' tab to apply a 'Thin Diagonal Stripe' fill.
Step 3
Freeze the panes so that all the headings in row 2 and the city and year columns display when you scroll down.
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
Go to the 'View' tab, click on 'Freeze Panes,' and then select 'Freeze Panes' again to freeze the top two rows so that the headings in row 2 remain visible while scrolling.
Step 4
Insert a function in cell D3 to convert the text that appears in cell C3 to a number.
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
In cell D3, use the formula: =VALUE(C3). This formula converts the text in cell C3 to a numerical value.
Step 5
Insert a function in cell G48 to determine the month occurring rainfall value in April.
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
In cell G48, use the formula: =MODE(H3:G46). This will return the most frequently occurring rainfall value for the month of April.
Step 6
Insert a function in cell H49 to determine the average rainfall for May for all the cities throughout all the years. Display the average rounded to the next highest whole number.
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
In cell H49, use the formula: =ROUNDUP(AVERAGE(H3:H46), 0). This formula calculates the average and rounds it up to the nearest whole number.
Step 7
Insert a function in cell K50 to determine the third highest rainfall in August.
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 K50, use the formula: =LARGE(K3:K46, 3). This retrieves the third highest rainfall value from the range specified.
Step 8
Insert a function in cell M51 to determine the total rainfall that fell in the four cities during October 2015.
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 M51, use the formula: =SUMIF(B3:B46, "2015", M3:M46). This sums the total rainfall for the city records for October 2015.
