4.1 Insert a function in cell J15 to determine the total number of Toyota vehicles in the showroom - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Question 4
4.1 Insert a function in cell J15 to determine the total number of Toyota vehicles in the showroom.
4.2 Insert a function in cell J18 to determine the second highes... show full transcript
Worked Solution & Example Answer:4.1 Insert a function in cell J15 to determine the total number of Toyota vehicles in the showroom - NSC Computer Application Technology - Question 4 - 2017 - Paper 1
Step 1
Insert a function in cell J15 to determine the total number of Toyota vehicles in the showroom.
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 determine the total number of Toyota vehicles, use the COUNTIF function:
=COUNTIF(A3:A57, "Toyota")
This formula counts all instances of 'Toyota' within the specified range.
Step 2
Insert a function in cell J18 to determine the second highest total of all the various vehicles in the showroom (column J).
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
For finding the second highest total of all vehicles, use the LARGE function:
=LARGE(J3:J16, 2)
This formula returns the second largest value from the range J3 to J16.
Step 3
Insert a function in cell J19 to determine the total number of vehicles in the showroom.
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
To find the total number of vehicles, you can sum up the values:
=SUM(J3:J16)
This aggregation will give the total count of vehicles present.
Step 4
Insert a function in cell J20 to determine the total value of the VW vehicles in the showroom.
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 find the total value of VW vehicles, utilize the SUMIF function:
=SUMIF(A3:A57, "VW", F3:F57)
This function sums up values in the designated range based on the criteria specified (VW).
Step 5
Use an appropriate spreadsheet feature to format all unique values in cells J3:J16 with a green fill colour.
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
To apply the conditional formatting for unique values:
Highlight cells J3:J16.
Navigate to the 'Conditional Formatting' option.
Select 'Highlight Cells Rules' and choose 'Duplicate Values'.
Modify the rule to format unique values and set the fill color to green.
Step 6
Change the chart/graph title to resemble the chart/graph below by carrying out the instructions that follow.
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
To modify the chart:
Set the vertical axis title to 'Number of cars'.
Adjust the chart/graph title to 'Makes Available'.
Format the columns to remove gaps between them.
Change the border of the columns to a solid black line.
