Term
|
Definition
| Electronic spreadsheet you work in, (excel) |
|
|
Term
|
Definition
| is where a worksheet is contained, and it uses file extension .xlsx. |
|
|
Term
| In Excel what do formulas begin with? |
|
Definition
|
|
Term
| Excel recognizes an entry as a value if? |
|
Definition
| it is a number or it begins with one of the following symbols.+,-,=,@,#,$ |
|
|
Term
| what are ways to move around in excel? |
|
Definition
| arrow keys for one cell at a time, Page up or down to move a screen at a time, alt page up, to move a screen to the left.Alt page down, moves a screen to the right.Ctrl Home takes u back to A1, Ctrl end takes u to the end |
|
|
Term
| what does the autosum button on the ribbon do? |
|
Definition
| quickly inserts SUM function,the arrow will allow other functions such as Average |
|
|
Term
| When u click insert function button? |
|
Definition
| equal sign appears, and insert function dialouge box appears |
|
|
Term
|
Definition
| click the insert button list arrow in the cells group on the home tab, then click insert cells. Dialogue box appears to verify. |
|
|
Term
| how do u create an absolute cell reference? |
|
Definition
| Placing a dollar sign in front of both the column letter and row number of the cell address |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| What does the format of a cell determine? |
|
Definition
| how the labels and values look |
|
|
Term
| how do u format a cell or range? |
|
Definition
| Select it, then apply formatting by using the ribbon or a keyboard shortcut |
|
|
Term
| when can u apply formatting? |
|
Definition
| before or after u enter data |
|
|
Term
| what adds dollar signs and two decimal places to data? |
|
Definition
| default Accounting Number |
|
|
Term
| how do u apply attributes and alignment options? |
|
Definition
| using home tab, Format Cells dialog box, or mini toolbar |
|
|
Term
| A small red triangle appears in corner |
|
Definition
| adding and editing comments |
|
|
Term
| how do u add enhancements? |
|
Definition
| use border and fill color, and front group on the home tab of the ribbon and on the mini toolbar |
|
|
Term
| predesigned combinations of formatting attributes? |
|
Definition
|
|
Term
|
Definition
| Click home tab,click find and select in editing, then replace |
|
|
Term
| what info goes on x-axis? |
|
Definition
|
|
Term
| what goes on y-axis?(vertical) |
|
Definition
|
|
Term
|
Definition
|
|
Term
| value in a cell u select? |
|
Definition
|
|
Term
|
Definition
| verticle format, excel default, sometimes referred to as a bar chart |
|
|
Term
|
Definition
| campares trends over even time intervals,and looks similar to an area chart |
|
|
Term
|
Definition
| Compares sizes of pieces as part of a whole,single series number |
|
|
Term
|
Definition
|
|
Term
|
Definition
| shows individual volume changes over time in relation to total volume |
|
|
Term
|
Definition
| Compares trends over uneven time.used in scientific and engineering |
|
|
Term
| how do u change the chart type in type group? |
|
Definition
| modify the data range and configure in the data group, change layout.choose colors,and location |
|
|
Term
| if u create a pie chart how can u emphasize one data point? |
|
Definition
|
|
