Submitted by: Submitted by jordanhatesit
Views: 132
Words: 444
Pages: 2
Category: Other Topics
Date Submitted: 02/12/2013 03:42 AM
IF - Tests a condition and takes an alternative action depending on the result
AND - Test up to 30 conditions using logical And
OR - Test up to 30 conditions using logical Or
IFERROR - Performs a specified action if a formula evaluates to an error, and displays the formula result if not
Active Cell
The active cell is recognized by its black outline. Data is always entered into the active cell. Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard.
File Tab
The File tab is new to Excel 2010 - Sort of. It is a replacement for the Office Button in Excel 2007 which was a replacement for the file menu in earlier versions of Excel.
Like the old file menu, the File tab options are mostly related to file management such as opening new or existing worksheet files, saving, printing, and a new feature - saving and sending Excel files in PDF format.
Formula Bar
Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box
Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Column Letters
Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Row Numbers
Rows run horizontally in a worksheet and are identified by a number in the row header.
Together a column letter and a row number create a cell reference. Each cell in the worksheet can be identified by this combination of letters and numbers such as A1, F456, or AA34.
Sheet Tabs
By default there are three worksheets in an Excel file.
The tab at the bottom of a worksheet tells you the name of the worksheet - such as Sheet1, Sheet2 etc.
Switching between worksheets can be done by clicking on the tab of the sheet you wish to access.
Renaming a worksheet or changing the tab color can make it easier to keep track of data in large spreadsheet files.
Quick Access...