click below
click below
Normal Size Small Size show me how
Spreadsheet Basics
Spreadsheet term
| Term | Definition |
|---|---|
| Spreadsheet/ Worksheet | an arrangement of cells in column and rows used to organize, analyze, calculate, and report information, usually in numerical form. |
| Workbook | a file which contains one or more spreadsheets. |
| Cell | individual locations on a spreadsheet where a column and row intersect. |
| Column | a vertical range of cells identified by letters of the alphabet. |
| Row | a horizontal range of cells identified by numbers. |
| Cell Address/ Reference | the column letter and row number for a cell. |
| Cell Range | a group of adjacent cells( a block of cells). |
| Active Cell | the cell that is selected and ready to receive information. |
| Labels | text or numbers that will not be used in calculations (will be aligned on left side of cell). Ex: John Jones( text) |
| Values | numbers that will be used in calculations( will be aligned on right side of cell). Ex: 150 |
| Formula | instructions for the software to perform a calculation. Ex: =a2+a3+a4+a5 =d4-d3 =b5/c5 =c7*c8 |
| Function | a shortcut for a formula. Ex: =sum(a2:a5) =avg(b3:b8) |