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 it to other cells in a spreadsheet.
Insert formulae and/or functions in such a manner that the correct results will still be obtained even if values are changed in the existing data.
Should you need to use building blocks, use the space allocated for this in the spreadsheet data file.

Open the 4Excursions spreadsheet which contains the details of a school holiday programme where school groups visited the zoo in December 2023.

4.1 Move the Trip worksheet so that it appears before the Q4_6 worksheet.

(1)

Work in the Trip worksheet.

4.2 Insert a function in cell C3 to determine how many schools from the Eastern Cape (EC) visited the zoo during December.

(3)

4.3 Insert a function in cell G3 to determine the most frequent date on which schools visited the zoo.

(1)

4.4 Insert a combination of functions in cell D7 to display the contact numbers in the following format:

Contact number            Format
0871522635                +27 871522635
0729237425                +27 729237425

NOTE: There are two spaces between the country code (+27) and the number.

(5)

4.5 One teacher per group of 30 learners, or part thereof, must accompany school groups when they visit the zoo.

Use a formula in cell F13 to determine the number of teachers that accompanied the learners from the school in row 13.

(3)

4.6 Data validation has been applied to column H.

Modify the data validation rule for column H to accept only dates in December 2023.

Use a validation feature to circle invalid data.
Create a range of cells H5:H30 showing the created invalid data and paste the screenshot in the Q4_6 worksheet.

(2)

4.7 Learners that visited the zoo in a school group on 9 December and 16 December received the badge.

Insert a combination of IF and OR functions in cell I12 to display the message 'Badge' if the condition is true; otherwise, the cell must be left blank.

(5)

QUESTION 4: SPREADSHEET NOTE: Use formulae and/or functions for ALL calculations in the spreadsheet - NSC Computer Application Technology - Question 4 - 2024 - 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 - 2024 - Paper 1

Move the Trip worksheet so that it appears before the Q4_6 worksheet.

Insert a function in cell C3 to determine how many schools from the Eastern Cape (EC) visited the zoo during December.

Insert a function in cell G3 to determine the most frequent date on which schools visited the zoo.

Insert a combination of functions in cell D7 to display the contact numbers in the specified format.

Use a formula in cell F13 to determine the number of teachers that accompanied the learners from the school in row 13.

Modify the data validation rule for column H to accept only dates in December 2023.

Insert a combination of IF and OR functions in cell I12 to display 'Badge' if true.

Join the NSC students using SimpleStudy...