LESSON 3: Using Spreadsheet Software

Using Spreadsheet

Software

LESSON 3

Multiple Choice

What is spreadsheet software primarily used for?

• Editing videos and photos

• Organizing and analyzing data

• Designing websites

• Creating presentations

Multiple Choice

Which of the following is a feature of spreadsheet software?

• Uses layers for design editing

• Includes tools for writing essays

• Creates a grid with rows and columns

• Provides animation effects for slides

What is Spreadsheet Software?

● Computer programs for organizing and

analyzing data.

● Uses rows and columns to create a grid.
● Examples: Microsoft Excel and OpenOffice

Calc

● Great for projects with lots of calculations.
● Helps with budgeting and tracking spending.

Cool Things Spreadsheets Can Do

● Create charts and graphs from your data.
● Perform "what-if" analysis to explore different

scenarios.

● Make electronic worksheets for easy data entry.
● Automatically update calculations when you change

numbers.

● Help you understand patterns in your information.

Parts of a Spreadsheet

● Cells: The building blocks of a spreadsheet
● Columns: Vertical groups of cells (labeled with

letters)

● Rows: Horizontal groups of cells (labeled with

numbers)

● Formulas: Special instructions that do math for you
● Functions: Pre-made formulas that make work

easier

Conditional Formatting

● A way to make important information stand out.
● Changes how cells look based on what's inside

them.

● Helps you spot patterns or unusual data quickly.
● Example: Make all numbers over 100 turn red
● Useful for grades, temperatures, or money

amounts.

How to Use Conditional Formatting

1. Select the cells you want to format.

2. Click "Conditional Formatting" in the Home tab.

3. Choose "Highlight Cells Rules".

4. Pick a rule (like "Text That Contains").

5. Type what you're looking for.

6. Choose how you want it to look.

7. Click OK and watch your data light up!

Data Analysis: Asking Your Spreadsheet
Questions
● A tool that helps you understand your data better.
● Uses regular language to answer questions about

your information.

● Creates visual summaries to show trends and

patterns.

● Helps you explore "what-if" scenarios.
● Makes complicated data easier to understand.

Using Data Analysis in Excel

1. Click on a cell in your data range.

2. Find "Analyze Data" in the Home tab and click it.

3. Look at the cool visuals Excel creates for you.

4. Want to know more? Type a question in the box at the top.

5. Excel will answer with charts, tables, or graphs.

6. You can add these to your spreadsheet if you like them.

Real-Life Uses for Spreadsheets

● Planning a class party budget
● Tracking your homework grades
● Making a schedule for a sports team
● Calculating how long it will take to save for a new

bike

● Creating a chart of the most popular lunch items

Spreadsheet Tips for 7th Graders

● Start with simple projects and build up.
● Use built-in templates to get started quickly.
● Don't be afraid to experiment – you can always

undo!

● Ask for help from teachers or classmates.
● Remember: Practice makes perfect!