Microsoft Office

Thursday, August 6, 2009

Excel Tips

• Absolute cell reference: Cell contents will not change when copied or moved to another cell.
• Active cell: Cell on which the cell pointer is located.
• AutoFormat: Pre-designed formats that add a professional look to spreadsheets.
• Cell: Point at which a column and row meet.
• Cell reference: Cell’s name.
• Chart: Visual representation that shows statistical information.
• Footer: Information that appears at the bottom of every page.
• Formula: Statement that performs a calculation.
• Formula prefix: Equal sign (=) that is entered before a formula.
• Function: Built-in formula that is a shortcut for common calculations, such as addition and average.
• Header: Information that appears at the top of every page.
• Label: Alphabetical text.
• Order of evaluation: Sequence of calculation.
• Range: Group of cells.
• Relative cell reference: Contents of the cell will not change when copied or moved to another cell.
• Spreadsheet: Row and column arrangement of data used to enter, calculate, manipulate, and analyze numbers.
• Value: Numeric text.
• Workbook: Group of related spreadsheets.
• Worksheet: Grid with columns and rows. The term worksheet is used interchangeably with spreadsheet.