INTRODUCTORY MICROSOFT EXCEL Part 1 Excel Basics

1
INTRODUCTORY MICROSOFT EXCELPart 1 Excel
Basics
2
Objectives

• Open a spreadsheet.
• Identify parts of the worksheet.
• Save the workbook using a different name.
• Move in a spreadsheet.
• Insert a column.

3
Objectives (continued)

• Enter data.
• Insert a row.
• Change and verify data in a cell.
• Preview and print worksheets.
• Create a new spreadsheet file.

4
Terms Used in This Part

• Active cell
• Cell
• Column
• Formula bar
• Highlight
• Name box

• Range
• Row
• Spreadsheet
• Workbook
• Worksheet

5
Define Spreadsheet and Worksheet

• Spreadsheet - grid of rows and columns containing
  numbers, text, and formulas.
• The purpose of a spreadsheet is to solve problems
  that involve numbers.

6
Define Spreadsheet and Worksheet

• Worksheet a computerized spreadsheet.
• Workbook collection of related worksheets.

7
Identify Parts of the Worksheet

• Title bar
• Menu bar
• Standard toolbar
• Formatting toolbar
• Formula bar

• Columns
• Rows
• Highlight
• Status box

8
Move the Highlight in the Worksheet
9
Move the Highlight in the Worksheet

• The fastest way to move to an off-screen cell is
  to choose Go To on the Edit menu.
• Pressing the shortcut key F5 will also access the
  Go To dialog box.

10
Select Cells and Enter Data

• Enter data by keying text or numbers in a cell
  and pressing Enter.
• If you choose not to enter the data you have
  keyed, press Esc and the keyed data will not be
  entered.
• Click the Undo button on the Standard toolbar to
  reverse the last entry.

11
Edit Cells

• Data is edited in the Formula bar by pressing F2
  and making changes at the insertion point.
• To replace cell contents, key the new data and
  press Enter.
• To clear an active cell, press Delete.

12
Zoom In and Out of a Worksheet

• The view of your worksheet may be magnified or
  reduced by using the Zoom button on the Standard
  toolbar.
• You may key your desired magnification percentage
  directly in the Zoom box.

13
Summary

• The purpose of a spreadsheet is to solve problems
  involving numbers.
• A worksheet consists of columns and rows
  intersecting to form cells, which are identified
  by cell references.
• You can move to different cells of the worksheet
  by clicking on the cell with the mouse pointer,
  using a series of keystrokes, or by scrolling
  with the mouse.

14
Summary (continued)

• Both text and numerical data may be entered in
  the worksheet.
• You can alter data by editing, replacing, or
  deleting.
• The Zoom box enlarges or reduces the view of a
  worksheet on the screen.
• Changes in a worksheet are saved using the Save
  command on the File menu.
• A worksheet may be printed to provide a hard
  copy.