click below
click below
Normal Size Small Size show me how
excel
| Term | Definition |
|---|---|
| used for storing, organizing and manipulating data. | Spreadsheet |
| an Excel file that contains one or more worksheets. | Workbook |
| an Excel worksheet is a single spreadsheet that contains cells organized by rows and columns. | worksheet |
| a single unit on excel | cell |
| tabs where you select for worksheet and changes their names | name tab |
| worksheet that you are currently using | active worksheet |
| the unit that you selected | work space |
| units in the same lines going up-down | columns |
| units in the same lines going left-right | Rows |
| the name for the document | Headings |
| coordination for the cell. | Cell reference |
| boxes that contain the name for the worksheet | Name Box |
| When you put in formula, it shows the list of formula | Formula bar |
| start with an = and automatically do calculation on numbers and fractions | Formula |
| the coordination on the formula with out a $ | Relative reference |
| the coordination on the formula with one $ | mixed reference |
| the coordination on the formula with 2 $ | absolute reference |
| cell that were highlighted | Active cell |
| the difference between two numbers | range |
| lines that separate cells | Grid lines |
| Is this a absolutes location ? ($A$2) | True |
| is this a mixed location? (A$2) | True |
| Is this the formula for adding? =Sum | True |
| Is this the formula for dividing? =Quotation | False |
| Is this the formula for multiplying? =Produce | False |
| Bar graph is the best for comparing various data | True |
| circle graph is the best for showing percentage | True |
| Line graph is best for showing the changes over time | True |
| In order to change a graph you must start over again | False |
| The graph will change with the changes in data | True |