Lesson 5: In this
lesson, we will learn key terminology that is essential to
understanding the basics of Microsoft Excel 

Lesson 5:
Objectives
 Understanding key terms and definitions
 Spreadsheets
 Rows, Columns, Cells, Cell References
 Worksheets and Workbooks
 Formulas and Constants

Lesson 5:
Understanding Key Terminology: 
Objective
# 1  Spreadsheets 
What is a spreadsheet? 

Spreadsheets are computerized versions
of accountants’ ledgers. Spreadsheets are used by accountants to record
financial transactions.

Microsoft Excel’s
spreadsheets are called worksheets. 
Spreadsheets allow
accountants to analyze data to form conclusions based on observations from the
spreadsheets.
Spreadsheets allow users to input data into a table that
is very easy to read and analyze.

Microsoft Excel uses a
grid of rows and columns to create its worksheets. 

Objective
# 2  Rows, Columns, Cells, Cell References 
What do these terms mean? 

Excel Terminology
Rows are the
horizontal boxes throughout a worksheet.
Rows are labeled with
numbers.


Columns are the vertical
boxes that permeate a worksheet.
Columns are labeled
with letters.


Cells refer to the
intersection of a column and a row.
Cell reference is the
name of the Column letter and the row name, such as A9, or F8.



Objective
# 3  Worksheets and Workbooks 
What is the difference between a worksheet and a
workbook? 

The Difference Between
Worksheets and Workbooks
Worksheets are the spreadsheets that combine to
make workbooks.
An example of a worksheet is a teacher's grade
book that contains the grades of one particular class. A workbook is a
teacher's grade book that contains the grades of all the classes that the
teacher teaches.





Objective
# 4  Formulas versus Constants 
What is the difference between a formula and a
constant? 

Formulas vs. Constants
 The difference between a formula and a constant
is that a formula will change based upon changing the data in the cells that are
used to calculate the formula.
 Constants will never change regardless of
changing the data in cells that surround the particular cell reference.


 Formulas always contain an equal sign.
 An example of a formula is the Average
Function.
 The Average Function calculates the average of
specified rows or columns.
 An example of the Average Function to sum the
numbers in Row A1 to A6 would be =(A1:A6).


 Another example of a formula is the Sum
Function.
 The Sum Function sums all of the data in a
specified row or column.



Objective
# 5  The Basketball Problem 
You think that you know the difference between a
formula and a constant. Test yourself 

The following
problem has been taken from a dream of Sabdo  who
has been dreaming of visiting the United States to
see his favorite athlete Michael Jordan. 

The Basketball Problem 



Lesson Review 
In this lesson we covered the following:
 Essential terminology located within Excel
 What is a spreadsheet?
 How rows differ from columns and cells
 Worksheets encompass workbooks
 How to use formulas and constants

Back to lesson 4 
Continue to
Quiz

Back to
Lessons 