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 |