Embedded Files
Here's the Deal...
Here's the Deal...
Like Word Processing, there is a lot you may not know about Presentation software and its capabilities!
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.
Example: Excel, Google Sheets, LibreOffice Calc
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.
Why does this matter?
Why does this matter?
Spreadsheets are a powerful tool for organizing, analyzing, and communicating data in almost any field.
Organize Data Efficiently – Track numbers, text, or lists clearly.
Perform Calculations Quickly – Use formulas and functions to save time.
Visualize Information – Create charts, tables, and dashboards.
Boost Career Skills – Many jobs list Excel or Google Sheets as a required skill.
Mastering spreadsheets gives you a practical, transferable skill that makes school projects and workplace tasks faster, easier, and more professional.
Page updated
Google Sites
Report abuse