Northeastern University
Excel Lab 2 Guide Sheet
Data Plotting and Curve-FItting
GEU 110 S. Freeman (BKJ)
❑ Reading: Chapters 4 and 5. All topics are not included on the Guide Sheet.
❑ Review: The 3-way convention of accomplishing tasks in Microsoft (sometimes only 2 ways):
-
-
-
❑ Common Chart Types (know applications):
- C - S
- B - A
- L - H
- P - Custom
❑ Selecting Regions of data; Selected regions of data:
❑ Creating a chart - the 3-way convention w/ F11:
❑ Chart Location:
❑ Chart Objects & Formatting a Chart:
o Titles
o Legend
o Plot Area
o Gridlines
o Data Labels
o Axes
❑ Data Series / Series of Data:
❑ Source Data:
o Data Range
o Identifying
o Selecting
o Editing
❑ Selecting Non Adjacent Data Cells:
❑ Selecting the Labels (or not):
❑ Multiple Series of Data:
❑ Connecting the Dots: Adding Connecting Lines, Selecting a Line Chart, or adding a Trendline:
❑ Trendlines:
o Displaying Equation on Chart
o Formatting Line & Equation.
o Displaying R2
❑ Correlation & R2:
❑ R2 - The Bigger the Better?:
❑ Inserting Text Boxes:
❑ Drawing Objects and the Drawing Toolbar:
❑ Histograms
❑ Data - Automatic Updates:
❑ Using the Function Key – fx:
❑ Writing Formulae - even more tips that someday you might thank me for:
o Precedents vs. Dependents
o Relative vs. Absolute referencing
o Providing variable names for single cells or ranges
❑ Text Formatting in the Cells (again):
o 2 lines of text in one cell
o Writing, but not calculating equations & functions
❑ More Axis Formatting in the Charts:
o Number of Decimal Places
o Major Units & Minor Units
o Relocating the Axis
❑ Viewing the Worksheet:
o Normal
o Page Break
❑ Preparing to Print:
o Page Setup
o Preview
❑ Default Charts - OK, I’ve fixed this chart the way I like it, let’s make more just like it:
❑ Creating Histograms – Data Analysis under Tools, data, bins, Chart
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- university city education foundation
- city university high school memphis
- why this university essay sample
- university city schools mo
- university of minnesota education department
- university school district jobs
- university city high school mo
- university city public schools
- university city st louis
- northeastern europe
- northeastern europe map
- northeastern europe dna