Spreadsheet Study Guide
Spreadsheet: A grid of rows and columns containing numbers and text that allows the user to manage, predict, and present information. An electronic spreadsheet is a computer application program that can also hold formulas in a cell that serve as a calculator. These formulas allow the electronic spreadsheet to perform calculations much faster and more accurately that spreadsheets created with pencil, paper, and calculator. An electronic spreadsheet is a computer application program that can also hold formulas in a cell that serve as a calculator. These formulas allow the electronic spreadsheet to perform calculations much faster and more accurately that spreadsheets created with pencil, paper, and calculator.
ROWS go horizontally--a side by side layout of boxes
COLUMNS go vertically--an up and down layout of boxes
CELL--the block created where a column and a row intersect each other
CELL ADDRESS--the location of a cell on the spreadsheet
FORMULA BAR or DATA ENTRY BAR--the bar at the top of the spreadsheet used to enter
data into the cell that you have selected
CELL RANGE—a group or block of cells in a spreadsheet. Operations can be performed on a range of cells. The range highlighted below is B3 through D4. It is written as B3:D4
There are 3 types of data that you can enter into a spreadsheet--
VALUES, LABELS, and FORMULAS.
Formula: Arthmetic equation with symbols(+-*/) for mathematical operations: A3+B3-C3*4
Function: fFunctions create shortcut formulas for the user
~
ROWS go horizontally--a side by side layout of boxes
COLUMNS go vertically--an up and down layout of boxes
CELL--the block created where a column and a row intersect each other
CELL ADDRESS--the location of a cell on the spreadsheet
FORMULA BAR or DATA ENTRY BAR--the bar at the top of the spreadsheet used to enter
data into the cell that you have selected
CELL RANGE—a group or block of cells in a spreadsheet. Operations can be performed on a range of cells. The range highlighted below is B3 through D4. It is written as B3:D4
There are 3 types of data that you can enter into a spreadsheet--
VALUES, LABELS, and FORMULAS.
- VALUES are numbers (like in cell B4);
- LABELS are text (like in cell A5); and
- FORMULAS are mathematical calculations (like what is
in the data entry bar to get the answer for cell E4)