Lesson 17 Getting Started with Excel Essentials
Download
Report
Transcript Lesson 17 Getting Started with Excel Essentials
Lesson 12
Getting Started with Excel Essentials
Computer Literacy
BASICS: A
Comprehensive Guide
to IC3, 3rd Edition
1
Morrison / Wells
Objectives
Lesson 17
2
Identify the parts of the Excel screen.
Navigate through a worksheet and a workbook.
Change views and magnification in the worksheet
window.
Enter data.
Insert and delete rows and change column width
and row height.
Copy, clear, move, and delete data.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Objectives (continued)
Lesson 17
Use the Undo and Redo features.
Use the AutoFill feature to copy and enter data
into a range of cells.
3
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Vocabulary
Lesson 17
4
active cell
AutoFill
cell
cell reference
column heading
range
row heading
Morrison / Wells
spreadsheet
value
workbook
worksheet
CLB: A Comp Guide to IC3 3E
Introduction
Lesson 17
5
A spreadsheet is a grid of rows and columns
into which you enter text data (e.g., surnames,
cities, states) and numerical data (e.g., dates,
currency, percentages).
Excel is an electronic application designed to
replace the paper spreadsheet.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Identifying the Parts of the Excel
Screen
Lesson 17
Excel refers to a spreadsheet as a worksheet.
The worksheet is always stored in a workbook.
6
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Identifying the Parts of the Excel
Screen (continued)
Lesson 17
7
Columns appear vertically and are identified by
letters at the top of the worksheet.
Rows appear horizontally and are identified by
numbers on the left side of the worksheet.
The intersection of a single row and a single
column is called a cell.
The cell reference is the column letter followed by
the row number (for example, A1 or B4).
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Navigating a Worksheet
Lesson 17
8
Before you can enter data into a cell, you must first
select the cell.
When the cell is selected, a dark border appears
around the cell, and the column and row headings
for the selected cell are highlighted.
You can select a cell using either the mouse or the
keyboard.
A selected cell is called the active cell.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Navigating a Worksheet
(continued)
Lesson 17
Moving through a Workbook:
To move around in a worksheet, you can use the scroll
bars or keyboard shortcuts.
9
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Changing the Workbook View and
Magnification
You can change the view by selecting options
from the Workbook Views group on the View
tab or by clicking the window.
Lesson 17
10
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Changing the Workbook View and
Magnification (continued)
You can also change the zoom settings to
adjust the view on the screen.
Lesson 17
11
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Entering Data
You add data to the cells by entering text or
numbers in the active cell. The text and
numbers are often referred to as a value.
Lesson 17
12
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Entering Data (continued)
Lesson 17
Inserting Data:
As you enter text, you see the insertion point indicating
where the next character will appear.
13
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Entering Data (continued)
Lesson 17
14
Using the AutoCorrect and AutoComplete
Features:
The AutoCorrect feature corrects common mistakes as
you enter data.
With the AutoComplete feature, Excel compares the
first few characters you enter in a cell with existing
entries in the same column. If the characters match an
existing entry, Excel proposes the existing entry. Press
enter to accept or continue entering text.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Modifying the Worksheet Structure
Lesson 17
15
Selecting Multiple Cells in the Worksheet:
To select an entire row in a worksheet, click the
row heading, which is the number at the left of the
row.
To select an entire column, click the column
heading, which is the letter at the top of the
column.
When you select a group of cells, the group is
called a range.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Modifying the Worksheet Structure
(continued)
Lesson 17
16
Inserting and Deleting Rows and Columns:
When you insert or delete a row or a column in
Excel, all existing data is shifted in some direction.
To add or delete rows and columns, use the
buttons in the Cells group on the Home tab.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Modifying the Worksheet Structure
(continued)
Lesson 17
Changing Column Width and Row Height:
To accommodate data, you can widen the column
and change the height of a row.
17
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Editing the Worksheet Data
Lesson 17
18
Clearing, Replacing, and Copying Existing Data:
To replace cell contents, you can select the cell and
enter new data.
You can use the Delete or Backspace keys to delete
data.
Moving data is similar to copying data, except that you
cut the data from one location and paste it in the
destination location.
When you past data to a cell that already contains data,
the existing data in the cell is replaced.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Editing the Worksheet Data
(continued)
Lesson 17
Using AutoFill to Copy Data:
AutoFill enables you to repeat the same data in a column or
row.
19
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Editing the Worksheet Data
(continued)
Lesson 17
20
Using AutoFill to Fill in a Series:
You can use AutoFill to quickly fill in a series of numbers and
dates.
To fill in a series, a pattern must be established in the initial
selection of cells. When you drag the fill handle, the pattern
is continued.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Lesson 17
Summary
21
In this lesson, you learned:
Excel uses the Microsoft Office Fluent user
interface, and the Excel application window shows
the Quick Access Toolbar, status bar, task bar,
and other similar features. The Excel document
window shows the worksheet.
To navigate the workbook, you can use keyboard
shortcuts and the scroll bars.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Summary (continued)
Lesson 17
22
You can choose from several options to view the
worksheet, and you can change the zoom settings to
specify the level of magnification.
To enter data in a cell, the cell must be active.
As you enter data, the AutoCorrect feature
automatically corrects some of your keyboarding errors.
If the data you are entering matches characters of
existing entries in the column, the AutoComplete
feature proposes the existing entry to save you time.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Summary (continued)
Lesson 17
23
When you insert or delete cells, rows, and
columns, all existing data is shifted up, down, left,
or right.
To reorganize a worksheet, you can add and delete
columns and rows; and you can delete, clear, copy,
or move the data.
There are several options for changing the column
width. You can drag a column boundary, use the
AutoFit feature, or specify an exact measurement.
Morrison / Wells
CLB: A Comp Guide to IC3 3E
Summary (continued)
Lesson 17
24
Copying and pasting data in Excel is similar to
copying and pasting text in Word.
The AutoFill feature enables you to copy data
from one cell to another, and it can save you
time by quickly filling in a series of data.
Morrison / Wells
CLB: A Comp Guide to IC3 3E