| A | B |
|---|
| Excel Formulas | Allow you to perform calculations on data entered into a spreadsheet. |
| Data | Information (values, or numbers; labels, or text; and date/time that is stored in a spreadsheet program. |
| Spreadsheet: | A table used to store various types of data. |
| Cells: | The basic storage unit for data in a spreadsheet, and the intersection point of a column and a row. In Excel, each rectangular box is referred to as a cell. |
| Rows: | Rows run horizontally in Ecel and are identified by a number in the row header. |
| Columns | Columns run vertically in Excel and are identified by a letter in the column header. |
| Cell Reference | The cell reference identifies the location of a cell, and consists of the column letter and row number that intersect all the cells location. |
| Relative Cell Reference | Default for all Excel cell references. It identifies the location of a cell, and changes when the formula is copied to other cells. In other words, it's relative to where it is in the spreadsheet. |
| Absolute Cell Reference | In contrast to relative cell references, an absolute cell reference does not change when it is copied and pasted to other cells. in other words, it will absolutely reference the same cell no matter where it is in the spreadsheet. |
| For what reasons are spreadsheets used? | Spreadsheets are an accurate and easy way to keep track of money, statistics, and information, analyze information, and present it in a way that makes sense to someone else. |
| What are some “everyday uses” for spreadsheets? | Ex. Sports statistics, grades, budgets, inventory, buying a car etc. |
| What are some businesses that might use spreadsheets? | Accounting and finance...to record and project financials and modeling financial (what if scenarios, etc) |
| What is an Excel formula? | An excel formula allows you to perform calculations on data entered into a spreadsheet. |
| What’s the difference between a row and a column? | A row runs horizontally and is identified by a number, and a column runs vertically and is identified by a letter. |
| What does the intersection of a row and a column tell us? | The location of a cell. Ex. Cell A1 is Column A, Row 1. This is called the cell reference |
| What’s the difference between a relative and an absolute cell reference? | A relative cell reference identifies the location of a cell and changes when the formula is copied to other cells. In contrast, an absolute cell reference does not change when it is copied and pasted to other cells. |
