If you wanted to create a PivotTable based on a spreadsheet of data, what step should you conduct first to ensure that the PivotTable will automatically update to include any new data that is subsequently added to your spreadsheet? Freeze the top row the spreadsheet Create a data validation rule Sort the spreadsheet by the first column Format the spreadsheet as an Excel Table Create a filter for the spreadsheet Continuing with the previous example, suppose you have created the following PivotTable (shown below). However, instead of showing the number injuries in each cell, you want to show the percentage of injuries in each year that is attributable to each of the ministry program areas (i.e. you want the percentages in each year to add to 100% ). To do this, you will need to change the "Value Field Settings" of the data by right clicking in any cell in the table. Which "Show value as" option would you select to make the desired change? % of Column Total % of Grand Total Average each of the ministry program areas (i.e. you want the percentages in each year to add to 100% ). To do this, you will need to change the "Value Field Settings" of the data by right clicking in any cell in the table. Which "Show value as" option would you select to make the desired change? % of Column Total % of Grand Total Average Count % of Row Total