Excel Formulas
AB
Allow you to perform calculations on data entered into a spreadsheet.

You are watching: What runs horizontally and is identified with numbers?

DataInformation (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.
ColumnsColumns run vertically in Excel and are identified by a letter in the column header.
Cell ReferenceThe 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 ReferenceDefault 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 ReferenceIn 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.

See more: What Is The Gcf Of 28 And 42 Is, Methods To Find Gcf Of 28 And 42

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.
*