NSC Computer Application Technology Uses of common applications: QUESTION 4: SPREADSHEET
NOTE:

-

Question

QUESTION 4: SPREADSHEET
NOTE:

- Use formulae and/or functions for ALL calculations in the spreadsheet.
- Use absolute cell references ONLY where necessary to ensure that formulae are correct when you copy them to other cells in the same column (copy down).
- Insert formulae and/or functions in such a manner that the correct results will still be obtained, even if changes are made to the existing data.
- Use the allocated space in the spreadsheet, should you need to use building blocks.

Open the 4Tourists spreadsheet. This spreadsheet contains data obtained from a survey completed by tourists who stay in Agra and visit the Taj Mahal.

Work in the Info worksheet.

4.1 Wrap the column headings in row 6.

4.2 Insert a function in cell E2 to determine the most days (column F) that any tourist stayed in Agra to visit the Taj Mahal.

4.3 Insert a function in cell E3 to determine the number of tourists who indicated the kind of reaction they had (column J) when they saw the Taj Mahal.

4.4 The gender code for a tourist is stored in column K as follows:
- 2 for female
- 3 for male

The amount each tourist spent is stored in column L.

Insert a function in cell E4 to determine the total amount spent by all female tourists.

4.5 Insert a function in cell E5 to determine how many tourists from Spain (column D) indicated that they would return (column M) to visit the Taj Mahal.

4.6 Use the HOUR function in cell I7 to display only the number of hours between the time tourists checked in (column H) and the arrival time (column G).

4.7 The results of the survey showed that tourists generally spent different amounts per person, depending on their gender and country of origin.

The lookup table in the Countries worksheet indicates the estimated amount male and female tourists spent per day based on their country of origin.

Insert a formula/function in cell L7 to calculate the total estimated amount spent by the tourist, Nelle Moran, for the number of days (column F) he stayed in Agra.

HINT: Use a VLOOKUP function to determine the estimated amount that male or female tourists spent per day, based on their country of origin.

The gender code for a tourist is stored in column K:
- 2 for female
- 3 for male

The formula must work correctly if it is copied down to the other cells.

4.8 Tourists to the Taj Mahal need to get permission to visit the three sites before their arrival.

The date of tour arrivals at the Taj Mahal appears in column E.

QUESTION 4: SPREADSHEET NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2019 - Paper 1

Worked Solution & Example Answer:QUESTION 4: SPREADSHEET NOTE: - Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2019 - Paper 1

Wrap the column headings in row 6.

Insert a function in cell E2 to determine the most days (column F) that any tourist stayed in Agra to visit the Taj Mahal.

Insert a function in cell E3 to determine the number of tourists who indicated the kind of reaction they had (column J) when they saw the Taj Mahal.

Insert a function in cell E4 to determine the total amount spent by all female tourists.

Insert a function in cell E5 to determine how many tourists from Spain indicated that they would return.

Use the HOUR function in cell I7 to display only the number of hours between the time tourists checked in and the arrival time.

Insert a formula/function in cell L7 to calculate the total estimated amount spent by the tourist, Nelle Moran.

The date of tour arrivals at the Taj Mahal appears in column E.

Join the NSC students using SimpleStudy...