Embedded Files
Here's the Deal...
Here's the Deal...
Spreadsheets are probably the business software you have the least experience with, but they also have the most power!
Introduction
Introduction
A spreadsheet is a file made of rows and columns that helps you organize, analyze, and display data. Unlike other software, spreadsheets can calculate values automatically using formulas and functions. It's like a table in Word but on steroids!
Common Spreadsheet Software: Excel, Numbers, Google Sheets
How Important is Excel?
How Important is Excel?
Click here to search for jobs in Baltimore (25-mile radius) listing Excel as a desired skill.
What types of positions use spreadsheets?
Are they what you expected?
Can Excel be Fun?
Can Excel be Fun?
Shared Spreadsheet Terminology
Shared Spreadsheet Terminology
Worksheet - One “page” in a spreadsheet file.
Workbook - A file containing one or more worksheets.
Cell - The intersection of a row and column.
Row - Horizontal line of cells, numbered 1, 2, 3…
Column - Vertical line of cells, labeled A, B, C…
Range - A group of selected cells (e.g., B1:B10).
Gridlines - Lines separating cells on-screen (may not print).
Sheet Tabs - Tabs that let you switch between worksheets in a workbook.
Print Area - Specifies which cells to print, instead of the whole sheet.
Image and more info from: https://www.computerhope.com/jargon/s/spreadsheet.htm
Cell References
Cell References
Relative Reference: Changes when copied to another cell.
Example: C5 copied right becomes D5 - copied down becomes C6.
Absolute Reference: Does not change when copied. Uses the $ signs.
Example: $C$6 stays the same wherever you copy it.
Try It!
Try It!
In Column B, type 1–10 in rows 1–10.
In C5, type =B5 and hit Enter.
Copy C5 to C6, then to D5. What changes?
Add a $ sign in front of the row and column and try again.
Key Spreadsheet Features
Key Spreadsheet Features
Fill Handle - Quickly copy data or formulas to adjacent cells.
Formula - Calculates values using cell references (starts with =).
Function - Predefined formulas for common tasks (e.g., =SUM(B1:B15)).
Chart - Visualize data as bar, line, pie, etc.
Conditional Formatting - Highlight cells based on rules (e.g., values >100).
Try It!
Try It!
Use the Fill Handle to extend numbers or formulas.
Create a SUM function for a column of numbers.
Notebook ACTIVITY
Notebook ACTIVITY
Fun with Spreadsheets?
Choose three of the "Cool Things You Can Do" from the link above that surprised you and jot them down in your Notebook.
Which surprised you most? Why? Did it change how you think about what spreadsheets can do?
Why does this matter?
Why does this matter?
Spreadsheets are one of the most in-demand skills in the job market, and most people only know how to type numbers into cells. Whether you're tracking a budget, analyzing data for a class project, or managing inventory, spreadsheets are the tool. The students who know formulas, functions, and charts have more opportunities.
Don't believe me? Go back and look at those Indeed job listings again.
Spreadsheets > Tables
Page updated
Google Sites
Report abuse