Introduction to Spreadsheets: Vocabulary

Introduction to Spreadsheets: Vocabulary

A Grade 7 Office Productivity Course

Workbook Overview

•A workbook is a collection of spreadsheets.

•It acts as a container for
organizing related data and
calculations.

•Each spreadsheet within a
workbook is referred to as a
worksheet or a sheet.

What is a Spreadsheet?

•A spreadsheet is a software
tool that allows you to
organize, analyze, and
manipulate data in a
grid-like format.

•It consists of rows and
columns that intersect to
form cells, which can store
different types of data such
as numbers, text, or
formulas.

What are Cells?

•Cells are the building blocks
of spreadsheets.

•They are the individual units
within the grid that hold
data (boxes).

•You can think of cells as
small containers that can
store information.

Cell Addresses

•Each cell in a spreadsheet
has a unique address,
also known as a cell
reference.

•Cell addresses are
represented by the
combination of a letter
and a number, such as
A1, B2, or C3.

•The letter represents the
column, while the
number represents the
row.

Multiple Choice

True or False:

Cells are the building blocks of
spreadsheets.

• False
• True
• Maybe
• Sometimes

Exploring Cell Ranges

•A cell range is a group of
interconnected cells in a
spreadsheet.

•Ranges can be selected to
perform actions like
formatting or applying
formulas to multiple cells at
once.

•They are defined by the
starting and ending cell
addresses, separated by a
colon. For example, A1:B3
represents a range from cell
A1 to cell B3.

What are Spreadsheet Columns?

•Columns are vertical
arrangements of cells in a
spreadsheet.

•Each column is identified by
a letter at the top of the
spreadsheet, such as A, B, or
C.

•Columns are used to group
cells vertically and organize
data in a tabular format.

Multiple Choice

Which of the following is a
vertical arrangement of cells
in a spreadsheet?

• row
• table
• column
• cell

Discovering Rows

•Rows are horizontal
arrangements of cells in a
spreadsheet.

•Each row is identified by a
number on the left side of
the spreadsheet, such as 1,
2, or 3.

•Rows are used to group cells
horizontally and organize
data in a tabular format.

Did You Know Fact

Did you know that a
spreadsheet can have
thousands of rows and
columns?

Fun Fact

Did you know that the world's largest Excel spreadsheet had over 17 billion cells?

Poll

Would You Rather

Would you rather use a spreadsheet or a paper and pencil to organize data?

• Paper

• Pencil

Applying Spreadsheets in Everyday Life

•Spreadsheets are used in
various aspects of everyday
life, such as budgeting,
tracking expenses, and
organizing schedules.

•They can also be used for
scientific calculations, data
analysis, and project
management.

•Learning how to use
spreadsheets can greatly
enhance your productivity
and decision-making skills.

Multiple Choice

Each box on a spreadsheet is called a ...

• row
• column
• cell
• box

Multiple Choice

Rows on a spreadsheet are identified by a ...

• number
• letter
• symbol
• smiley face

Multiple Choice

Columns on a spreadsheet are identified by a ...

• number
• letter
• space
• smiley face

Multiple Choice

a file which contains one or more spreadsheets.

• Workbook
• Spreadsheet
• Cells
• Entry

Multiple Choice

an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information

• Workbook
• Spreadsheet
• Cell
• Entry

Multiple Choice

A4 is an example of...

• Cell Address
• Cell Range
• Formula
• Function

Multiple Choice

A1:A10 is an example of...

• Cell Address
• Cell Range
• Formula
• Function

Multiple Choice

What is displayed in cell A6?

• Monday
• Tuesday
• Wednesday
• Thursday

Multiple Choice

What is displayed in cell B1?

• 100
• Tickets Sold
• Day
• B1

Open Ended

Have you ever used a spreasheet?