Programs: Microsoft Excel: Lesson 5


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
  1. Spreadsheets
  2. Rows, Columns, Cells, Cell References
  3. Worksheets and Workbooks
  4. 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 


Programs: Microsoft Excel: Lesson 5