For each constituency, design a spreadsheet that accepts the candidate's name, party acronym, rating, % of votes, and number of votes received. The rating is a value from 1 to 4 and is determined by the results of a recent poll conducted in each constituency by a noted pollster. Apart from the candidate's ratings, the pollster also supplies the % of votes each candidate is likely to receive, based on the popularity rating. The actual number of votes received is that percentage of the General votes.
You must enter data for each candidate in each of the eight constituencies.