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) |