Instructor’s Manual Materials to Accompany EXPLORING MICROSOFT® OFFICE 2013, VOLUME 2 EXCEL CHAPTER 5: SUBTOTALS, PIVOTTABLES AND PIVOTCHARTS Available Instructor Resources Resource File Name Found Student Data Files various Online Instructor Resource Center Solution Files various Online Instructor Resource Center Answer Keys Online Instructor Resource Center Matching e05_answerkey_match Multiple Choice e05_answerkey_mc Concepts Checks e05_answerkey_concepts Scorecards e05b1Tips_scorecard Online Instructor Resource Center Scoring Rubrics e05b1Tips_rubric Online Instructor Resource Center Annotated Solution File e05b1Tips_annsolution Online Instructor Resource Center Scripted Lecture (Script) e05_script Online Instructor Resource Center Scripted Lecture Solution e05_script_solution Scripted Lecture Data e05_script_data PowerPoint Presentation e05_powerpoints Online Instructor Resource Center Testbank e05_testbank Online Instructor Resource Center Instructor's Manual (lesson plans incl.) e05_instructormanual Online Instructor Resource Center Assignment Sheet e05_assignsheet Online Instructor Resource Center Prepared Exam (Chapter & App) Online Instructor Resource Center Prepared Exam-Chap instruction e05_exam_chap_instruction Prepared Exam-Chap solution e05_exam_chap_solution Prepared Exam-Chap Data e05_exam_chap_data Prepared Exam-Chap Annotated Sol. e05_exam_chap_annsolution Prepared Exam-Chap Scorecard e05_exam_chap_scorecard Prepared Exam-App instruction e05_cumexam_instruction Prepared Exam-App solution e05_cumexam_solution
KEY TERMS Calculated field – A user-defined field that performs an arithmetic calculation based on other fields in a PivotTable. Columns area – The region in which to place a field that will display labels to organize data vertically in a PivotTable. Data mining – The process of analyzing large volumes of data to identify patterns and trends. Filters area – The region in which to place a field so that the user can then filter the data by that field in a PivotTable or PivotChart. Grouping – (1) The process of joining rows or columns of related data into a single entity so that groups can be collapsed or expanded for data analysis. (2) The process of selecting worksheets to perform the same action at the same time. Outline – A hierarchal structure of data organized so that groups can be expanded to show details or collapsed to show high-level structure. PivotChart – A graphical representation of data in a PivotTable. PivotTable – An interactive organization of data that consolidates and aggregates data by categories that can be sorted, filtered, and calculated. PivotTable Fields task pane – A window that enables a user to specify what fields are used from a dataset and how to organize the data in columns, rows, values, and filters. PowerPivot – A PivotTable functionality in which two or more related tables can be used to extract data into a PivotTable. Relationship – A connection between two or more tables using a common field, such as an ID field. Rows area – The region in which to place a field that will display labels to organize data horizontally in a PivotTable. Slicer – A window listing all items in a field so that the user can click a button to filter data by that particular item or value. Slicer caption – The text or field name that appears as a header or title at the top of a slicer to identify the data in that field. Subtotal – An aggregate calculation, such as SUM or AVERAGE, that applies to a subcategory of related data within a larger dataset. SUBTOTAL function – A math or trig function that calculates the total of values contained in two or more cells.