EXCEL GRAPHING

Short Description
formula in Excel, you must start with an =. This tells Excel that what … If you copy this formula to a new location, Excel will change the …

Website: www.sunyacc.edu | Filesize: 88kb

Content
FORMULA BASICS FOR EXCEL
Microsoft Excel 2003
Spreadsheet Terminology
Spreadsheet: Spreadsheets are basically tables, which are designed to also do extra things for you, like automatically perform calculations, or make graphs.
Columns: Vertical collections of information. (Up and down, like the columns on a porch.) Referenced by letters.
Rows: Information that is arranged horizontally. (Side to side, like the rows on lined paper.) Referenced by numbers.
Cells: The point at which a row meets a column.
Cell Reference: The cell where the second column meets the second row would be referenced (called) B2, shown here outlined in black. Always use column letter followed by row number to reference a cell.
Range of Cells: When you refer to a range of cells, use a colon (:) between the start and end values. For example to include the cells in columns B & C, rows 3-5, the range you list would be B3:C5.
Starting a Formula
You can enter a formula (a mathematical equation to perform calculations,) in Excel to automatically calculate for you. When typing in a formula in Excel, you must start with an =. This tells Excel that what follows is a formula,…