MS Excel Quiz 2 on Pivot Tables Question Title * 1. What is your name? (First, Last) Question Title * 2. What is your location? Winnipeg, MB Regina, SK Saskatoon, SK Itasca, IL Tukwila, WA Vaughan, ON Other Question Title * 3. What is your role/job title/department? Question Title * 4. What characteristics are required in the source data to create a Pivot Table? The data is housed in an Excel table or covered by a named range A list or table with values in it A contiguous data range with headers None of the above Question Title * 5. Which of the following is (are) not a PivotTable field? Filters Sort Columns Values Formula Question Title * 6. Please select the Value field settings: Select all that apply: Sum Count Average Percentage Question Title * 7. True or false? When inserting a Pivot Table does Excel provide a recommended Pivot Table option? True False Question Title * 8. Please select the Show Values As settings: Select all that apply: % of Column Total Row Total Rank Largest to Smallest Rank Smallest to Largest Rows Columns Question Title * 9. How do you remove an item from a Pivot Table? Delete it from the source data, and then refresh the Pivot Table Drag it back from the Pivot fields into the field well - Answer Right click the item in the field list and select Remove None of the above Question Title * 10. Suppose you change something in your Pivot Table's source data. What are the implications? You must manually refresh your Pivot Table in order to see the change show up there The Pivot Table will update automatically You must close your workbook and re-open it to get the Pivot Table to update Question Title * 11. What is the first step for creating a Pivot Table? Clicking on the Insert Tab and inserting a Pivot Table. Create or select data that needs to be analyzed. Deciding on which fields (column and row labels) to use to analyze the data. None of the above Question Title * 12. After inserting a Pivot Table, the Pivot Table Field List does not automatically appear. How can you activate this area? Click on the Field List button in the Show group, under Options in the PivotTable Tools contextual tab. Click on the Insert Pivot Table button and select PivotTable Fields List. Go to the Backstage View and in the Options dialogue box, click on the PivotTable tab. Check the box for PivotTable Fields List. All of the options listed above are correct. Question Title * 13. How would you rate the relevance of this material to your day-to-day job? Extremely valuable Somewhat valuable Not valuable at all Question Title * 14. Did you learn anything about the position/topic that you didn’t know prior to this? Question Title * 15. How would you rate the relevance of this material to your day-to-day job? A great deal A moderate amount None at all Question Title * 16. If you gained new knowledge, be specific! Question Title * 17. What kind of content would you like to see in the future to help improve your day-to-day work life? Check all that apply: Current updates in the industry Step-by-step guides to using specific software/programs Shortcuts in the programs I currently use Other Question Title * 18. If you selected other material that you would like to see in the future, please be specific: Question Title * 19. Was there anything unclear in the material that you would like your manager or the Frontier-U team to expand on? Done