Common user interface, yet new stuff

1
Common user interface, yet new stuff

• Notice
• similar menus and buttons
• new menus Data
• new features
• name box
• Formula bar
• 3 sheets1 binder(more can be inserted)

2
New buttons

• New buttons
• The fx button is next to the formula bar. It
  contains pre-defined functions for formulas.

3
Excel View settings 1/3

• Tools ? Customize
• Try
• Investigate the options
• buttons on 1 or 2 rows
• show full menu

4
Excel View settings 2/3

• You can control how things look in the
• View Menu?
• try
• Click on and off
• a new toolbar,
• the Status bar,
• the formula bar,
• the task pane

5
Excel View settings 3/3

• Tools ?Options
• Here you can change many functions controlling
  how the Excel program acts.
• Try
• Press ltENTERgt several times and notice direction
  of move.
• Click Tools ? Options
• Click on tab called Edit and try changing the
  option called Move selection after ltENTERgt.
  Change the direction to the right.
• Click on another tab and see what you discover.
  Change something, test it out. You may want to
  change it back if you dont like it.

6
Moving around

• Recall, in the Excel grid
• columns go up and down,
• rows go across
• To move around try
• ltentergt key
• lttabgt key
• scroll and click
• the arrow keys

7
Editing in Excel 1/8

• Cell name cell reference
• The cell reference for the cell containing 4 is
  B1. When typing cell references, you can type
  them lowercase. (ex. b1)
• Active cell has border around it (C1).

8
Editing in Excel 2/8

• To enter info (or replace info)
• Click on cell
• Type
• Press ltentergt
• To edit
• Dbl-click in cell
• Edit
• Press ltentergt
• To delete
• Click in cell
• Press DELETE key.

9
Editing Exercise 3/8

• Try
• Type the following into the cells pictured 2, 4,
  a1b1, Joe.
• Replace Joe with Vanna (click and type and
  ltENTERgt)

10
Editing in Excel 4/8

• To enter info (or replace info)
• Click on cell
• Type
• Press ltentergt
• To edit
• Dbl-click in cell
• Edit
• Press ltentergt
• To delete
• Click in cell
• Press DELETE key.

11
Editing in Excel 5/8

• Note you can also edit from the Formula bar.
  Click the green check or press ltentergt afterward

12
Editing Exercise 6/8

• Try
• Edit Vanna into Evanna
• Edit Evanna into Evanna Jones
• Edit a1b1 into a1b14

13
Editing in Excel 7/8

• To enter info (or replace info)
• Click on cell
• Type
• Press ltentergt
• To edit
• Dbl-click in cell
• Edit
• Press ltentergt
• To delete
• Click in cell
• Press DELETE key.

14
Exercise Insert Delete columns and rows 8/8

• Try
• Delete all entries of your previous practice and
  type the enter the following
• Save as Excel Practice to A

15
You are now ready to do Chapter 1 Exercise 1
16
To Delete or Insert a row (or column)

• To Delete a row
• Click on row (or column)
• Click Edit ? delete, select
• row
• Column
• To Insert a row
• The Row you click on moves down. (Column moves to
  right)
• Click Insert?row (or column)

17
Exercise delete row

• Try
• Delete the Tom row.
• Before?after

18
To Delete or Insert a row (or column)

• To Delete a row
• Click on row (or column)
• Click Edit ? delete, select
• row
• Column
• To Insert a row
• The Row you click on moves down. (Column moves to
  right)
• Click Insert?row (or column)

19
Exercise insert row

• Insert an Oscar 85, 90 row in between Joe and
  Mary.(Save your work Click Save button)
• Before?after

20
Before printing, set up page

• File ? Page Setup
• Sheet tab
• Gridlines
• row/column headings (row 1, 2, 3/col. a, b, c,
  etc.)
• (see previous slide. Sheets there have gridlines
  and headings showing.)
• Page tab
• Landscape (long) vs. portrait
• Margins tab
• Center the spreadsheet horizontally vertically

21
Print Preview

• File ? Print Preview or before PRINTING!!
• Try
• Print with the various options. Use Print Preview
  to see the before and after selecting the
  options.
• You are ready to do Chapter 1 Exercise 2

22
Save and Close

• Try
• Click the Save Button.
• Close the Excel spreadsheet file only, not the
  program.
• Click File? New to open a new spreadsheet.
• Click File? Save As and save as Formula Practice
  to A

23
Formula Notes

• Always type an (equals sign) first. See
  example below
• Use constants - ex. 7
• cell references - ex. b2
• operations , -, /, ( is multiply)
• predefined functions - ex. sum(a1a5)
• What If If you change a that is used in a
  formula, the formula recalculates.
• An example 8c3c4

24
Formula exercise 1/3

• Retype 2, 4, and a1b1 into a1, b1 and c1.
• Click back on the cell c1 to see the formula in
  the formula bar. Its value is in cell.

25
Formula exercise 2/3

• Replace the 2 with a 7 in a1.Observe the
  automatic recalculation.
• Type in cell d1 a1b1
• Click back on the cell to see the formula in the
  formula bar. Its value is in cell.
• Type in cell e1 a110.
• Repeat step 3.
• Type in cell f1 sum(a1b1).
• Repeat step 3.
• Save.

26
formulas
27
Formula exercise 3/3

• Enter 3 more small numbers into column A, in A2,
  A3 and A4.
• Enter 3 more small numbers into column B, in B2,
  B3 and B4.
• Type in cell a5 sum(a1a4). Click back on the
  cell to see the formula in the formula bar. Its
  value is in cell. Check your math.
• Save.

28
Ctrl shows formulas

• Hold down the ctrl key and then tap the key
  (its above lttabgt) to get formulas to show. Do
  again to hide formulas.
• Narrow the columns by dragging on their borders
  inside the gray column headings.

29
Important menu format

• When we get to formatting the spreadsheet, to
  look nice, you will find all formatting tools in
  Format ? Cells menu.
• Much of what you find here will be buttons as
  well. Many of those buttons are the same as in
  Word B, I, U, etc.
• After the lesson on formatting, you are ready to
  do Chapter 1 Exercise 4