3.1 Format the merged cells A1:J1 as follows:
- Change the border colour to red - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Question 3
3.1 Format the merged cells A1:J1 as follows:
- Change the border colour to red.
- Set the fill colour to black.
3.2 Insert a function in cell G3 to determine the e... show full transcript
Worked Solution & Example Answer:3.1 Format the merged cells A1:J1 as follows:
- Change the border colour to red - NSC Computer Application Technology - Question 3 - 2018 - Paper 1
Step 1
3.1 Format the merged cells A1:J1 as follows:
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 format the merged cells A1:J1:
Select the merged cells A1:J1 and go to the 'Home' tab in the ribbon.
Click on 'Borders' and select 'Borders Color' to red.
For the fill color, choose the 'Fill Color' option and set it to black.
Step 2
3.2 Insert a function in cell G3 to determine the earliest year (column C) in which a painting was painted.
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 G3, use the following formula to find the earliest year:
=MIN(C:C)
Step 3
3.3 Insert a function in cell G4 to determine the number of paintings for which the place where the painting was painted (column G) is not given.
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
In cell G4, you should use this formula to count the paintings without a specified location:
=COUNTIF(G:G, "")
Step 4
3.4 The function in cell G5 displays the average width of all the paintings in the worksheet.
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
To calculate the average width in cell G5:
=AVERAGE(F:F)
Step 5
Add another function to cell G5 so that the given formula displays a value formatted to the nearest decimal value.
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
Modify cell G5 to round the average width calculated:
=ROUND(AVERAGE(F:F), 2)
Step 6
3.5 Insert a SUMIFS function in cell G6 to determine the total insurance value (column J) of all the paintings painted before 1900 in the city in which they are painted.
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 G6, insert this SUMIFS formula:
=SUMIFS(J:J, C:C, "<1900", I:I, "Chicago")
Step 7
3.6 Cells B9:B120 contains the full names of the artists of the paintings.
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 apply conditional formatting in cells B9:B120:
Select cells B9:B120.
Go to 'Conditional Formatting' in the 'Home' tab and select 'New Rule'.
Choose a 'Format only cells that contain' rule and specify the formatting options.
Step 8
3.7 Use a spreadsheet feature to automatically apply a two-colored gradient fill to the values in these cells.
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 range in question, then navigate to 'Conditional Formatting' and select 'Color Scales'. Choose a two-color gradient to apply the fill.
