Microsoft Excel 2003: Skill Set 1 Notes

1
Microsoft Excel 2003Skill Set 1 Notes

• Unit 3 Spreadsheets
• BTT 1O5

2
What is Spreadsheet Software?

• A computer application designed to perform
  mathematical calculations
  
• A spreadsheet stores and analyzes data
• Used for
• Personal budgets
• Cost calculations
• Business payroll
• Business inventory
• Data collection
• The spreadsheet software we will use is Microsoft
  Excel 2003
  

3
The Excel Window
4
The Excel Window
5
The Excel Window
6
The Excel Window
7
The Excel Window
8
The Excel Window
9
The Excel Window
10
The Excel Window
11
The Excel Window
12
The Excel Window
13
The Excel Window
14
The Excel Window
15
The Excel Window
16
The Excel Window
17
Important Excel Terms

• Workbook
• The type of file that is created in Excel
• A file is temporarily saved as Book1 until we
  save it with a new name
  
• Has the file extension .xls
• Worksheet
• Like a page in a workbook
• Each workbook automatically has 3 worksheets
• Switch between worksheets by clicking on the
  Sheet Tabs
  
• Data is entered in cells

18
Important Excel Terms

• Column Headers
• Columns go up down
• Labeled with letters (A to Z, then AA to IV)
• There can be 256 columns in a worksheet
• Row Headers
• Rows go across
• Labeled with numbers
• There can be 65,536 rows in a worksheet
• Cell
• The intersection of a row and a column

19
Important Excel Terms

• Cell Reference or Cell Name
• The column letter and row number that identify a
  single cell
  
• Active Cell
• The selected cell
• Displayed with a bold border around it
• When you type, the data will appear in the active
  cell
  
• Name Box
• Shows the cell reference of the active cell

20
Important Excel Terms

• Cell Range
• A reference to a group of cells
• Eg. A1D1 includes A1, B1, C1, D1
• Eg. F1 F4 includes F1, F2, F3, F4
• Formula Bar
• Shows the contents of the active cell
• If you type in the formula bar, the data will
  show up in the active cell
  

21
Types of Data in Excel

• Labels
• Text entries
• By default, these are left-aligned in the cell
• Values
• Numeric entries
• These entries will have calculations performed on
  them
  
• By default, these are right-aligned in the cell

22
Types of Data in Excel

• Formulas
• Mathematical statements used to calculate values
• Uses mathematical operators (eg. -)
• Functions
• Pre-defined formulas that perform special
  calculations
  

23
Using Formulas In Excel

• Must begin with an equals sign ()
• Mathematical operators
• Multiplication
• Division /
• Addition
• Subtraction -
• Follows BEDMAS order of operations

24
Using Formulas In Excel

• The formulas will appear in the formula bar
• The results of the formulas will appear in the
  cells
  
• To display the actual formulas in the cells,
  press Ctrl
  
• Press Ctrl again to return to seeing the
  resulting values in the cells
  

25
Common Functions In Excel

• SUM(cellcell) Adds the specified cells
• AVERAGE(cellcell) Finds the average of the
  specified cells
  
• MIN(cellcell) Finds the lowest value in
  the specified cells
  

26
Common Functions In Excel

• MAX(cellcell) Finds the highest value in
  the specified cells
  
• COUNT(cellcell) Counts the number of
  cells in the specified range
  

27
Common Error Values

• DIV/0 The formula is trying to divide by
  zero
  
• REF The formula contains a cell reference
  that isnt valid
  
• The result of the formula is too wide
  to fit in the column