GO with Microsoft Excel 2016 Comprehensive First Edition
- Slides: 27
GO! with Microsoft Excel 2016 Comprehensive First Edition Chapter 3 Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Learning Objectives • Chart Data with a Pie Chart • Format a Pie Chart • Edit a Workbook and Update a Chart • Use Goal Seek to Perform What-If Analysis • Design a Worksheet for What-If Analysis • Answer What-If Questions by Changing Values in a Worksheet • Chart Data with a Line Chart Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Pie Chart (1 of 4) • Absolute cell reference – Refers to a cell by its fixed position in the worksheet – Reference will not change when you copy the formula – Dollar signs ($) indicate that a cell reference is absolute • Relative cell reference – Refers to a cell that changes when you copy the formula and paste it to another location Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Pie Chart (2 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Pie Chart (3 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Pie Chart (4 of 4) • Data point – A value that originates in a worksheet cell and that is represented in a chart by a data marker • Data marker – In a pie chart, each pie slice is a data marker • Data series – Related data points represented by data markers – Determine the size of each pie slice • Legend – Chart element that identifies the patterns or colors assigned to the categories in the chart – Identifies the pie slices Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Format a Pie Chart (1 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Format a Pie Chart (2 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Format a Pie Chart (3 of 3) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Edit a Workbook and Update a Chart Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Use Goal Seek to Perform What-If Analysis (1 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Use Goal Seek to Perform What-If Analysis (2 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Design a Worksheet for What-If Analysis (1 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Design a Worksheet for What-If Analysis (2 of 2) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Answer What-If Questions by Changing Values in a Worksheet (1 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Answer What-If Questions by Changing Values in a Worksheet (2 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Answer What-If Questions by Changing Values in a Worksheet (3 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Answer What-If Questions by Changing Values in a Worksheet (4 of 4) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (1 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (2 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (3 of 7) • Axis – A line that serves as a frame of reference for measurement – It borders the chart plot area • Plot area – The area bounded by the axes, including all the data series • Category axis – Also known as the x-axis – The area along the bottom of a chart that identifies the categories of data • Value axis – Also known as the y-axis – Area along the left side of a chart that shows the range of numbers for the data points Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (4 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (5 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (6 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Chart Data with a Line Chart (7 of 7) Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Questions Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
Copyright © 2017 Pearson Education, Inc. All Rights Reserved.
- Exploring microsoft office excel 2016 comprehensive
- Microsoft official academic course microsoft excel 2016
- Excel lesson 4 vocabulary
- Microsoft excel 2016 basics vocabulary
- Microsoft official academic course microsoft word 2016
- Microsoft official academic course microsoft word 2016
- Microsoft+excel+merupakan+program+aplikasi
- Using mis (10th edition) 10th edition
- Mis
- Backstage word 2016
- Dashboard excel online
- Www.gcflearnfree.org/excel 2016
- One variable data table excel 2016
- Exploring microsoft office 2016
- Microsoft office 2016 in practice
- Free threat modeling tools
- Visual basic 10 express
- Sqlceer
- Kinder- und hausmärchen first edition
- Emergency medical responder: first on scene
- Cardiopulmonary
- Emergency medical responder first on scene 11th edition
- El software utilitario microsoft excel es:
- Fasilitas di microsoft excel yang dimaksud adalah ....
- Pengenalan microsoft excel
- Microsoft excel logical functions
- Excel vocabulary words
- Pengenalan ms excel