3.1 Edit the heading in row 1 as follows:
Merge and centre cells A1:J1 - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Question 3
3.1 Edit the heading in row 1 as follows:
Merge and centre cells A1:J1.
Apply a 'Distributed (Indent)' horizontal text alignment with an indent of 13.
3.2 The tota... show full transcript
Worked Solution & Example Answer:3.1 Edit the heading in row 1 as follows:
Merge and centre cells A1:J1 - NSC Computer Application Technology - Question 3 - 2023 - Paper 1
Step 1
Edit the heading in row 1 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 edit the heading in row 1, first, select cells A1 through J1. Then, merge these cells and centre the text. After that, apply a 'Distributed (Indent)' horizontal alignment and set the indent to 13.
Step 2
The total number of cars sold by each salesperson for the period 2022/2023 is stored in row 7.
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 E3, insert the formula =SMALL(C7:C17, 2) to find the second total number of cars sold by a salesperson for the period 2022/2023.
Step 3
Insert a function in cell E4 to determine the number of months in which the total monthly sales of cars were more than 15.
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 E4, use the formula =COUNTIF(J9:J20, ">15") to count the number of months where the sales total was greater than 15.
Step 4
Apply a spreadsheet feature to cells C9:I20 to display the percentage values of 0 to 50 in a two-colour scale format style.
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 the range C9:I20, and under conditional formatting, apply a two-colour scale. Set the minimum value to display in blue and ensure the maximum value is set to 50 percent.
Step 5
Insert a lookup function in cell F23 to display the name of the salesperson who sold the most cars for the period 2022/2023.
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 F23, use the formula =HLOOKUP(MAX(C7:C17), C7:C17, 2, FALSE) or =XLOOKUP(MAX(C7:C17), C7:C17, C8:C18) to find the name of the salesperson with the highest sales for the period.
