7.1 Open the 7CapeTown word processing document - NSC Computer Application Technology - Question 7 - 2023 - Paper 1
Question 7
7.1 Open the 7CapeTown word processing document.
7.1.1 Change the inside borders of the table to any blue colour.
7.1.2 Modify the heading row of the table to appe... show full transcript
Worked Solution & Example Answer:7.1 Open the 7CapeTown word processing document - NSC Computer Application Technology - Question 7 - 2023 - Paper 1
Step 1
7.1.1 Change the inside borders of the table to any blue colour.
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 inside borders, navigate to the table properties in the Word document, select the Borders and Shading option, and choose a blue colour for the inside borders.
Step 2
7.1.2 Modify the heading row of the table to appear as shown below.
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
Adjust the first cell of the heading row to merge into two cells: 'Tourist Name' and 'Tourist Surname', followed by adjusting the adjacent cells to display the corresponding headings and values from the example.
Step 3
7.1.3 Insert a formula to calculate the points for Allan Nel.
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 calculate points, use the formula:
extIF(SUM(LEFT))>5,1000,500
This checks the total visits calculated from cell data for 2020 and 2023. If the total is greater than 5, it displays 1000; otherwise, it displays 500.
Step 4
7.2.1 Apply a spreadsheet feature to column A to arrange the text into columns.
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 column A in the List worksheet and go to the Data tab, then click on 'Text to Columns'. Choose the appropriate delimiters (e.g., comma, space) to split the text.
Step 5
Find and replace all occurrences of the word 'Maybe' with the word 'No'.
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
Use the 'Find and Replace' feature in Excel by pressing Ctrl + H. Enter 'Maybe' in the 'Find what' field and 'No' in the 'Replace with' field. Set the text colour to red in the Format options and click 'Replace All'.
Step 6
7.2.2 Use a combination of functions in cell D2.
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 D2, enter the formula:
=DATE(YEAR(TODAY()),MONTH(C2)−1,DAY(C2))
This formula uses the current year based on TODAY(), takes the month from cell C2, subtracts 1 for the previous month to send the message before their birthday, and uses the day from C2.
