Open the 3Stats spreadsheet, which contains information about foreign tourists who visited the Taj Mahal - NSC Computer Application Technology - Question 3 - 2019 - Paper 1
Question 3
Open the 3Stats spreadsheet, which contains information about foreign tourists who visited the Taj Mahal.
Work in the Foreign worksheet.
3.1 Format cells A1:13 as ... show full transcript
Worked Solution & Example Answer:Open the 3Stats spreadsheet, which contains information about foreign tourists who visited the Taj Mahal - NSC Computer Application Technology - Question 3 - 2019 - Paper 1
Step 1
3.1 Format cells A1:13 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 merge cells A1 to I3, select the cells, right-click, and choose 'Merge Cells.' For the font size, select the merged cell and set the font size to 26.
Step 2
3.2 Change the tab colour of the Foreign worksheet to the standard purple colour.
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
Right-click on the Foreign tab at the bottom of the worksheet and select 'Tab Color.' Choose a standard purple color from the color palette.
Step 3
3.3 Insert a formula in cell B17 to convert the amount in rupees in cell C17 to an amount in South African rand.
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
Insert the formula =C17/5 in cell B17 to convert Indian Rupees to South African Rand, assuming the exchange rate is 1 ZAR = 5 INR.
Step 4
3.4 Modify the function in cell C74 to correctly calculate the 'Grand Total' earned from tourism.
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
The function in cell C74 should be =SUM(C9:C15) to sum the total earnings from all relevant cells in column C.
Step 5
3.5 Insert a formula in cell D8 to determine how many tourists from the USA visited the Taj Mahal in 2016.
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 D8, enter the formula =D7 to capture the number of tourists from the USA, assuming it is in cell D7.
Step 6
3.6 Apply conditional formatting to only cells H17:H32.
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
Select cells H17:H32, then go to 'Conditional Formatting' > 'New Rule.' Use 'Format cells that contain' and set the condition to format the font in green if the value is greater than the corresponding cell in column G.
Step 7
3.7 Insert a nested IF function in cell I7.
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
In cell I7, enter the following nested IF function:
=IF(D7>D6,IF(F7>F6,"Regular","Strong"),"Strong")
This checks for the conditions specified for the advertising campaign based on tourist numbers.
Step 8
3.8 Change the chart/graph in the worksheet to appear as follows:
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
To adjust the chart, delete the 2017 series by selecting it and pressing delete. Then right-click on the gridlines and set transparency to 60%. Change the text in the legend from 'Series1' to '2016.' Finally, fill and stack the 2018 series with the external image stored from 3Taj.
