Page 1032 - SUBSEC October 2017_Neat

constituency by a noted pollster. Each candidate in a given constituency has a unique
rating.)
 Party name

You must enter data for each candidate in each of the seven constituencies. Use the Percentage Voter
Turnout data to determine the number of votes cast (number of voters * percentage voter turnout).

Rename the worksheet as Elections Data
Save your spreadsheet as Elections

Task 2

Duplicate the Elections Data worksheet. Rename the duplicate as Elections Data Backup.

Modify the Elections Data worksheet as follows:

1. (Insert a column before the one which displays the name of the political party. Using an
appropriate column title, determine the votes received by each candidate in a given
constituency. The candidate’s rating represents the percentage of votes received by the
candidate in a given constituency. For example, given that 6400 votes were cast and a
candidate has a rating of 20, the votes received by the candidate would be 20/100*6400.

Format the votes received by each candidate to zero decimal places.

2. Sort the data first on party (ascending order) and secondly on votes received (descending

order).

3. The Trinbarjam Elections Commission needs to determine the following:
 Whether or not a refund is due to a candidate. Use an appropriately labelled column
to state “Refund Due” or “No Refund” for each candidate. A refund is due if the
candidate’s votes received equals or exceeds 20 per cent of the votes cast in the
constituency.
 A list of all candidates who should receive a refund. Extract the data to the bottom of
the worksheet.
 A table with summary data for the elections

Elections Data
Party Total Votes Received Percentage of Votes Cast

Total Votes Cast
Constituency No. of Voters Votes Cast Abstention

CXC 30/G/SYLL 17 55