cis_105_appendix_e

# cis_105_appendix_e - Axia College Material Appendix E Excel...

This preview shows pages 1–3. Sign up to view the full content.

Axia College Material Appendix E Excel Charts and Graphs This tutorial explains how to create column, line, and pie charts as well as the purposes of each. Throughout the lesson, notice that the same data can be used to create several charts that analyze the data in multiple ways. Developing Questions The following spreadsheet shows an individual’s monthly expenses for 2008 This information will be used to create various charts. One of the first steps in creating a chart is developing questions that can be answered from the data. What are some questions that you might ask about this data? The following are some examples: How do utility expenses compare to grocery expenses month to month? How did utility expenses vary month to month? What percentage of 2008 expenditures does each expense category comprise? CIS 105

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Selecting Data Now that you have generated a few questions about the data, look at what data would need to be selected in the spreadsheet to create charts that help answer each question. Question 1: How do utility expenses compare to grocery expenses month to month? Question 2: How did utility expenses vary month to month? CIS 105 To compare Utilities and Groceries , select those two rows. Note that the row of Months is also selected to compare the values for all twelve months. Note also that the totals are not selected. To select non-adjacent rows, select the first row,
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 09/10/2010 for the course CJS AAAF0PR0P7 taught by Professor Jones during the Spring '10 term at University of Phoenix.

### Page1 / 11

cis_105_appendix_e - Axia College Material Appendix E Excel...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online