Transcript Excel

Excel Spreadsheets
Excel is software that lets you create tables, and calculate
and analyze data. This type of software is called spreadsheet
software. Excel lets you create tables that automatically
calculate the totals of numerical values you input, print out
tables in neat layouts, and create simple graphs.
1
Spreadsheets
• A Row is a group of cells that run horizontally. Rows are
numerically labeled
• A Column is a group of cells that run vertically. Columns
are alphabetically labeled.
• Cells are the intersection of a Row and Column
• Cells are identified by first stating the intersecting
column letter followed by the intersecting Row number
• For example, B2 is an example of a cell address
2
Excel Spreadsheet
Spreadsheets consist of columns (vertical) and rows
(horizontal)
A
B
C
D
1
2
ROW (Horizontal)
3
4
The intersection of
a row and column
is called a CELL
COLUMN
(vertical)
Letters indicate COLUMNS and Numbers indicate ROWS
3
Excel CHARTS
Charts are used to present information so that it can be
quickly and easily understood
Bar and Column Charts
- Show values of data and allow comparison between
categories
Pie Charts
- Show values of data and allow comparison to the whole
- The area of each slice represents the fraction of the
whole
Line Charts
- Show the relationship between values
- They can be used to show the rate of change
4
Types of Charts
Column or Bar
Graph
Line Graph
Pie Graph
5
Chart Components
Values
Axis
(Y–axis)
Chart Title
Legend
Category Axis
(X-axis)
Category
Labels
6
Excel 2010 Mac version instructions. For Excel
2010 (Microsoft PC version) refer to next slide.
Steps
1. Enter this data into Excel
2. Select all of the 8 cells
(Creating a chart)
3. Select the Charts Tab along the top
toolbar
Month
Sales
4. Select Line Graph
June
150
5. Excel will create the graph below
July
76
6. Edit the title by clicking on it and type
August
43
in Bike Sales
Bike Sales
Bike Sales
200
150
100
50
0
June
July
August
7
Excel 2010 Microsoft PC version Instructions
1. Highlight the 3 Numbers
2. Select Insert – Line
3. Excel will create a Line
(graph)
The next 3 slides will explore
several features in Chart Tools…
8
Chart Tools - Design
Change Chart Type,
Switch Row/Column and
change Styles
9
Chart Tools - Layout
Change/Add Chart Titles,
Axis Titles, Legend and
Data Labels
10
Chart Tools - Format
Format Fill, Line and Text
styles and colors on the graph
11
Creating a Bar, Line and Pie Graph
BestBuy Sales
January
iPad
February
March
70
120
90
130
90
60
Laptop Computer
15
22
28
Video Game
60
30
10
Cell phone
52
40
20
iPhone
1.
2.
3.
4.
Type the above information into Excel
Make a Bar Graph of iPad Sales
Make a Line Graph of Laptop Computer Sales
Make a Pie Graph representing all devices sold in March
12
Adding up numbers in cells
Craves
Candy
Company
Monday
Tuesday
Wednesday
Truffles
4
6
3
Fudge
2
2
1
Candy
6
5
9
Chocolate
Bars
9
8
9
Cookies
6
6
7
Steps
1. Select the cells you want to
add
2. Select Formulas from the top
toolbar
3. Select AutoSum
4. Select SUM
5. Excel will add the numbers in
the cells and display the total
in the appropriate cell
Note: you can also choose
Average, Max or Min under
AutoSum
Task: Type the above information into Excel and practice
adding up the total number of sales for each day
13
SUM, AVG, MAX, MIN
SUM
AVG
MAX
MIN
Adds all numbers in a range of cells
Calculates the Average of all
numbers in a range of cells
Gives the Largest number in the
range of cells
Gives the Smallest number in the
range of cells
14
Adding numbers in cells
Type this formula into
cell C7 to add cells
C4, C5 and C6
=sum(C4,C5,C6) then
press the enter key
15
Finding MAX, MIN and AVERAGE
To find the max, min and average of
cells C4, C5 and C6 use these
formulas…
=max(C4,C5,C6)
=min(C4,C5,C6)
=avg(C4,C5,C6)
16
Finding MAX, MIN and AVERAGE
Task
In cell C7 put the formula to
find the maximum number in
the range of the 3 numbers
In cell C8 put the formula to
find the minimum number in
the range of 3 numbers
In cell C9 put the formula to
find the average of the 3
numbers.
17