Photo AI
Open the 6_Spotted By & Scientific Info spreadsheet and work in the Spotted By & Scientific Info worksheet - NSC Computer Application Technology - Question 6 - 2017 - Paper 1
Question 6
Open the 6_Spotted By & Scientific Info spreadsheet and work in the Spotted By & Scientific Info worksheet. 6.1 Hide the worksheets 2 and 3 as it is no longer neede... show full transcript
Worked Solution & Example Answer:Open the 6_Spotted By & Scientific Info spreadsheet and work in the Spotted By & Scientific Info worksheet - NSC Computer Application Technology - Question 6 - 2017 - Paper 1
Step 1
Step 2
6.2 Column D contains the name of the different turtles. Replace all the occurrences of the word turtle with uppercase TURTLE.
Answer
To replace occurrences of the word "turtle" with "TURTLE":
- Select Column D.
- Use the 'Find and Replace' feature (Ctrl + H).
- In the 'Find what' box, enter "turtle".
- In the 'Replace with' box, enter "TURTLE".
- Click 'Replace All' to apply the change.
Step 3
6.3 Column B contains the name of the person who spotted different turtles. Use any appropriate method to find the name that is not repeated the second time.
Answer
To find the unique name in Column B:
- Select Column B.
- Use 'Conditional Formatting' > 'Highlight Cells Rules' > 'Duplicate Values'.
- This will show duplicates. The name that is not highlighted is the unique name.
- The unique name to enter in cell G3 is 'Taylor'.
Step 4
6.4 Sort the contents of the worksheet first by Scientific Name in the descending order and then by Spotted By in the ascending order.
Answer
To sort the worksheet:
- Select any cell in the data range.
- Go to the 'Data' tab, click on 'Sort'.
- In the Sort dialog, choose 'Scientific Name' from the 'Sort by' dropdown and select 'Largest to Smallest'.
- Click 'Add Level', then choose 'Spotted By' and select 'A to Z'.
- Click 'OK' to apply the sorting.
- The name of the turtle in the first row after sorting can be found in cell G9, which should be 'Black Marsh Turtle'.
Step 5
6.5 Protect the cells A1:D1 with the password 2017.
Answer
To protect specific cells:
- Select cells A1:D1.
- Right-click and choose 'Format Cells'.
- Go to the 'Protection' tab and ensure 'Locked' is checked.
- Protect the sheet by going to the 'Review' tab and selecting 'Protect Sheet'.
- Enter the password '2017' and ensure only A1:D1 remains protected.