INTRODUCTORY MICROSOFT EXCEL Lesson 1 Excel Basics

1
INTRODUCTORY MICROSOFT EXCELLesson 1 Excel
Basics
2
Objectives

• Define the terms spreadsheet and worksheet.
• Identify the parts of the worksheet.
• Move the highlight in the worksheet.
• Select cells and enter data in the worksheet.
• Edit cells.

3
Objectives (cont.)

• Find and replace data.
• Zoom in and out of a worksheet.
• Save a worksheet.
• Print a worksheet.

4
Terms Used in This Lesson

• 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 (cont.)

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

7
Identify the Parts of the Worksheet

• Title bar
• Menu bar
• Standard toolbar
• Formatting toolbar
• Formula bar
• Name box
• Columns

• Rows
• Highlight
• Status box

8
Move the Highlight in the Worksheet
9
Move the Highlight in the Worksheet (cont.)

• 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 the Enter key.
• Press Esc to keep from entering data.
• Click the Undo button on the toolbar to reverse
  the last entry.

11
Edit Cells

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

12
Find and Replace Data

• The Find command locates specific words or
  numbers in a worksheet.
• Replacement substitutes new data for data found.

13
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.
• Key your desired magnification percentage
  directly in the Zoom box.

14
Saving a Worksheet

• To save a worksheet for the first time, choose
  Save As from the File menu. Name the file in the
  Save As dialog box.
• Once a worksheet has been saved, you may save it
  by clicking the Save button on the Standard
  toolbar.

15
Printing a Worksheet

• You may print your worksheet by
• Clicking the Print button on the Standard
  toolbar.
• Choosing Print from the File menu.

16
Summary

• A worksheet consists of columns and rows
  intersecting to form cells.
• A cell is identified by a cell reference.
• 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.

17
Summary (cont.)

• Text and numerical data may be entered into the
  worksheet.
• You can alter data by editing, replacing, or
  deleting.
• You can search for specific characters in a
  worksheet and replace data with other characters.

18
Summary (cont.)

• The Zoom box enlarges the view of a worksheet on
  the screen.
• Changes in a worksheet are saved using the Save
  command in the File menu.
• A worksheet may be printed to provide a hard
  copy.