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 |