Introduction to Excel

1. Excel is a spreadsheet software developed by Microsoft.

2. Excel can only be used for basic arithmetic calculations.

3. Excel allows users to organize, analyze, and visualize data efficiently.

Let's Play (Two Truths and a Lie)

1. Small businesses often use Excel for accounting and financial management due to its affordability and flexibility.

2. Graphic designers typically use specialized software like Adobe Photoshop or Illustrator for image editing, not Excel.

3. Hospitals may use Excel for various administrative purposes, but it's not specific to patient care.

Let's Play (Two Truths and a Lie)

Lesson Objectives

​At the end of this lesson students should be able to:

1. Differentiate between worksheets and workbook

2. Identify and explain Rows and Columns in reference to a spreadsheet

3. Define the terms cell reference/cell address , cell

4. Explain types of data stored in a spreadsheet (labels, values, labels, formula and functions)

5. Perform basic calculations using the application

6. Show an appreciation through discussion the benefits of Microsoft Excel

Multiple Choice

What is Microsoft Excel?

• A graphical word processing program that users can type with. It is made by the computer company Microsoft. Its purpose is to allow users to type and save documents. Similar to other word processors, it has helpful tools to make documents.

• An information management tool, or relational database, that helps you store information for reference, reporting and analysis.

• A software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system.

• A powerful slide show presentation program.

Multiple Choice

What is a work book ?

• A collection of one or more spreadsheets, also called worksheets, in a single file.

• A collection of cells organized in rows and columns. It is the working surface you interact with to enter data.

• An intersection of a column and row.

• Shows the address of the current selection or active cell.

Multiple Choice

Each Excel worksheet is made up of more Excel Worksheets.

• True

• False

Poll

How familiar are you with the parts of an Excel Sheet?

• Very familiar

• Somewhat Familiar

• I do not know what it is

• I am an expert

What are Rows, Cells and Columns in Microsoft Excel ?

Rows:

Cells:

Columns:

Cell address

Multiple Choice

The columns in an Excel sheet are named through the use of letters or combination of letters

• True

• False

Multiple Choice

Each row is named by a number.

• True

• False

Lets Identify Cell Address

Multiple Choice

Which of the following displays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar.

• Formula Bar

• Tool Bar

• Name Box

• Cell

Multiple Choice

The heavy border around the selected cell is called the _________________.

• Cell Pointer

• Bolded Section

• Selected Cell

• Cell

Types of Data stored in a spreadsheet (Ms. Excel)

Values:

Labels:

Formula:

Functions:

Multiple Choice

The __________ cell is the cell that receives data and commands you give it.

• Passive

• Active

• Intersected

• Pointed

Activity Time!!!!!!

Listen carefully to the instructions and follow accordingly.