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 the existing data changes.
- Should you need to use building blocks, use the allocated space in the spreadsheet.

Open the 4Famous spreadsheet, which contains the details of famous Impressionist artists.

Work in the Art_Kuns worksheet.

4.1 Centre the row headings in row 7 vertically.

4.2 The number of artworks created by each artist is stored in column K.
Insert a function in cell H3 to determine the total number of artworks that were painted.

4.3 The nationality of an artist is stored in column H.
Insert a formula in cell H4 to determine what percentage of artists is NOT of French nationality (column H). Refer to the formula below.

Number of non-French artists/Total number of artists x 100

4.4 The art forms practised by each artist are stored as an art form code in column I.
The first letter of the art form code refers to the preferred art form of the artist.
Insert a VLOOKUP function in cell J8 to display the preferred art form of an artist using the first letter of the art form code in column I and the lookup table in the Code_Kode worksheet.

4.5 Column L shows the number of 'for' votes an artist receives for his/her work.
Insert a function in cell N8 to determine which the artists are in the top three highest 'Votes For' counts (column L).

Display the message 'Top3' if the artist is in the top three, or otherwise leave the cell empty.

Ensure that the function can be copied down the other cells in the range.

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

Centre the row headings in row 7 vertically.

Insert a function in cell H3 to determine the total number of artworks that were painted.

Insert a formula in cell H4 to determine what percentage of artists is NOT of French nationality.

Insert a VLOOKUP function in cell J8 to display the preferred art form of an artist.

Insert a function in cell N8 to determine the top three artists based on 'Votes For'.

Join the NSC students using SimpleStudy...