An Excel file that contains single or multiple worksheets

1
Introduction to Spreadsheets

• Computer Technology

2
Terms you need to know(need to know these for
use in the program and on a test)

• Rows
• Columns
• Range
• Cells
• Active Cell
• Cell Address
• Workbook
• Worksheet

• Labels
• Numeric Labels
• Values
• Mathematical Operators
• Orders of Operation
• Equation Formula
• Function Formula

3
Microsoft Excel

• A program which allows your to perform complex
  mathematical operations in an organized manner
  without using a handheld calculator.

4
Microsoft Excel Layout
Ribbon
Tabs
Groups
5
What is a Spreadsheet?

• A Spreadsheet is a grid of rows and columns
  containing numbers and text.

Columns
Rows
6
The Size of the Spreadsheet

• Number of Rows
• 65536
• Number of Columns
• 256

7
Some terms

• Workbook
• An Excel file that contains single or multiple
  worksheets

• Worksheet
• One page in an Excel workbook

8
Rows vs. Columns

• Rows
• Identified by 1,2,3, etc. and goes across the
  spreadsheet horizontally

• Columns
• Identified by A,B,C and goes across the
  spreadsheet vertically.

9
Cell

• This is where a row and column meet. Each cell
  has a cell coordinate.(Isnt it romantic!)
  Examples of this are A1, C5, Z34

10
Label-Value-Range

• Label- Alphanumeric data that describes the
  values that follow and cannot be used in a
  calculation.
• Value - Numeric data that can be used in
  calculations
• Range-A rectangular group of adjacent cells.

11
Columns
Active Cell
Rows
Range (A3A6)
Range (A8C8)
12
Cell Address
Label
Numeric Label
1999-2000
13
Numeric Label
Label
Value
Label
Value
Label
Value
Label
Value
Value
14
What is this called?
15

• It is called the active cell...

16

• One page of your work in an Excel workbook is
  called..

17

• A Worksheet..

Notice that there are multiple worksheets in this
workbook. You should have 6 worksheets in one
workbook for CT-4.
18

• To Insert a new worksheet right click on the tab
  and choose Insert.

To change the name of a worksheet right click on
the tab and select Rename. Use the Insert tab to
add worksheets so there are 6.
19

• Last Question...

20

• Numeric data that can be used in calculations are
  called..

21

• Values

22
Mathematical Operators

• Addition
• Subtraction
• Multiplication
• Division /

23
Orders of Operation

• 1. Parenthesis
• 2. Exponents
• 3. Multiplication
• 4. Division
• 5. Addition
• 6. Subtraction

24
Two Types of Formulas

• A formula is an instruction to calculate a
  number.
• All Formulas begin with an equal sign
• Equation Formulas
• Use mathematical operators (, -, )
• Function Formulas
• Use function names (SUM, AVERAGE, MAX)

25
Equation Formulas

• To add
• cellcellcell
• To subtract
• cell-cell

• To multiply
• cellcell
• To Divide
• cell/cell

Or any combination of math operators Example
A110 Example (A1 B3)B710
A1 10 B3 2 B7 5
26
Function Formulas

• function name(cellcell)
• Function Names
• SUM - adds a range of cells
• AVERAGE - finds the average of a range of cells
• MIN - lowest value in a range
• MAX - highest value in a range
• COUNT - number of cells filled with a value
• COUNTA - number of cells filled with a label

27
Examples of Function Formulas

• To add a range of cells
• sum(A1A250)
• To find the average
• average(A1B25)
• To count a range of values
• count(B50H100)

28
How Do I

• Use function formulas?
• Add/delete columns or rows?
• Center my spreadsheet on a page and change
  margins?
• Insert a header or footer on my spreadsheet?
• Change Paper to Landscape and/or Change the Print
  size of my spreadsheet
• Turn on gridlines and set print area?
• Format cells?
• decimal places, currency, date, accounting,.
• Add Borders and Shading?
• Merge cells?
• Fill Down a column?

29
Function Formulas

• The first step to using formulas it to think
  about what mathematical operation you want to
  accomplish. It helps sometimes to write the math
  problem on paper first.
• Next click on the cell where you want the answer
  to the formula to appear.
• Choose the formula you want from the drop down
  menu next to the Sum icon.
• Select the cells you want to include in the
  operation. If Excel guesses the cells for you,
  MAKE SURE TO VERIFY THAT THOSE ARE THE CELLS YOU
  WANT! EXCEL IS NOT ALWAYS RIGHT!!

Back to How Do I?
30
Add/Delete Columns or Rows

• Select the column or row where youd like to add
  one or select the column you wish to delete.
• Use the following keyboard shortcuts.
• To add use Ctrl (hold control and strike the
  plus key its best to use the on the number
  pad)
• To delete use Ctrl- (hold control and strike the
  minus key)

Back to How Do I?
31
Center a Spreadsheet on a Page and Change Margins

• Page Layout tabgtPage Setup
• Change margins in designated boxes.
• Click the horizontally (if you want it centered
  between the left and right margins or vertically
  (if you want it centered between the top and
  bottom margins) box(es).

Back to How Do I?
32
Insert Header or Footer

• Choose Insert tabgt Header Footer
• Header/Footer tab
• Type the desired header in the section you want
  the header to appear.

Back to How Do I?
33
Portrait or Landscape
Portrait

• What is Portrait or Landscape?
• They are terms that describe the paper
  orientation.
• Choose Page Layout tab.
• On the Page Tab, you can choose portrait or
  landscape orientation

Landscape
Back to How Do I?
34
Gridlines and Print Area

• Page Layout tabgt Page Setup
• Check the gridlines box to turn them on.
• To set print area, click here, then drag to
  select the area you want to print.

Back to How Do I?
35
Format Cells

• Select the cells you wish to format
• Choose Home tabgt Number
• Choose the desired format.
• Select the additional desired options (number of
  decimals, 1000 separator) and click OK

Back to How Do I?
36
Merge Cells
1. Select the range needed
2. Click the Merge Cells button
Back to How Do I?
37
Entering Formulas using the Fill Handle
When you want to copy the contents of one cell
into the cells above or below or to the right or
left, you can drag the small black fill handle in
the bottom corner of the active cell. Use this
technique instead of typing the same formula many
times.
Click and Drag the Fill Handle in the bottom
corner of the activated cell with the correct
formula.
Back to How Do I?
38
Add Borders and Shading

• Activate the cells that you want borders around
• Select the Font Group and Border tab
• Select the Border, Style and Color of the lines
  you wish.
• For shading select the Fill tab.

Back to How Do I?
39
(No Transcript)