The following assignment scenario has a task and a mark scheme. The spreadsheet has been worked on already and below is the main bulk of the tasks.
Mail merger for ‘AWARD certificate for prize winners’ to produce individual certificates for each winner. The columns that need to be used are first name of winners surname and subject successfully complete from the student list and prizes worksheet
Simple macro that sets the print area and print preview before printing a list of the following columns first name, surname and awards in the prizeData and budget
The countif function which must produce a list showing how many books tokens of each monetary value is needed to be brought. To do this, need to refer to student list and prizes worksheet and the student list and prizes worksheet to count the particular book token amount e.g. £10 = 4 token required to be brought to the prize ceremony.
Calculate the total amount of the tokens give on the student list and prizes.