answer questions 1-10. Microsoft excel 2016 was not an option in the subject bar, but that is what this is

create rivottapres 1. To create a PivotTable, the user must start with a blank table and add fields. A. True B. False 2. Excel automatically refreshes a PivotTable when its source data changes. A. True B. False 3. Which of the following statements about Pivot Tables is/are true? A. Your data can be arranged in different ways. B. PivotTables combine some features of a table and an outline. C. Fields can be used to subtotal, compare, or count your data. D. All of these statements about Pivot Tables are true. 4. Match these PivotTable Field List areas to their purposes: . Report filter 1. Where Excel initially places all number columns B. Column labels 2. Where Excel initially places all text columns C. Row labels 3. Where you can drag fields to be displayed across the D. Values top of the PivotTable 4. Where you drag fields in which you wish to display4. Match these PivotTable Field List areas to their purposes: A. Report filter 1. Where Excel initially places all number columns B. Column labels 2. Where Excel initially places all text columns C. Row labels 3. Where you can drag fields to be displayed across the D. Values top of the PivotTable 4. Where you drag fields in which you wish to display only selected data Modify and Format PivotTables 5. Number formatting automatically transfers from the source data to the PivotTable. Excel 2016 Page = of 5 Test Bank A. True B. False6. Hana is working on a spreadsheet to track average GPAs in different chosen programs of study at her school. She's created a PivotTable, and she'd like it to sort the student information by major and then by student, but it's currently showing the opposite. What should Hana do to display the information by major and then by student? Low Likely Dung fetch between men below Columns Chemistry Thestrom Acting Theatre . Musical Avenge of GPA - Business Tech H A. Place Major above Class in the PivotTable Fields Rows box B. Move Major to the Columns box C. Change the Values function from Average to Sum D. Move Class to the Columns box 7. Margo is working with a PivotTable she's created in a spreadsheet. She's not very familiar with how PivotTables work and is experimenting by clicking on a few different things. If Margo clicks the checkbox in the PivotTable Field List corresponding to a column of textual information, in which of the 4 PivotTable boxes will Excel place the Field by default? A. FiltersHeading 1 B U A . A . 7. Margo is working with a PivotTable she's created in a spreadsheet. She's not very familiar with how PivotTables work and is experimenting by clicking on a few different things. If Margo clicks the checkbox in the PivotTable Field List corresponding to a column of textual information, in which of the 4 PivotTable boxes will Excel place the Field by default? A. Filters B. Columns C. Rows D. Values Apply a Filter to a Pivot Table 8. PivotTables are only able to filter one category of data at a time. A. True B. False 9. The AutoFilter button in Pivot Tables provides the same sorting and filtering options that are available in regular tables. A. True Excel 2016 Page 3 ol 5LA Help Heading 1 A A 9. The AutoFilter button in PivotTables provides the same sorting and filtering options that are available in regular tables. A. True Excel 2016 Page 3 of 5 Test Bank B. FalseTest Bank 10. Axel is working on a spreadsheet to track patient information at the hospital. He uses a PivotTable to show patients' names and immunization records. He'd like to add a filter to show only patients who have received the polio vaccine. Which of the following methods will allow Axel to do this? A. He can create a slicer using the immunization records field and select only the polio box. B. He can move the immunization records field to the Filters box and check only the polio box. C. He can use the AutoFilter button to check only the polio box. D. Any of these options will work Insert a Slicer to Filter a PivotTable