Term
|
Definition
| Equal sign preceding a formula |
|
|
Term
|
Definition
|
|
Term
|
Definition
| part of the excel program window that displays the active cell address |
|
|
Term
|
Definition
| intersection of a column and a row |
|
|
Term
|
Definition
| direction in which contenets of page will print |
|
|
Term
|
Definition
| file consisting of one or more worksheets |
|
|
Term
|
Definition
| maximum number of worksheets you can include in a workbook |
|
|
Term
|
Definition
| using a cell address in a formula is known as this |
|
|
Term
|
Definition
| feature used to print a very long worksheet on a single sheet of paper |
|
|
Term
|
Definition
| a selection of multiple cells |
|
|
Term
|
Definition
| the worksheet view that shows how your worksheet will look when printed |
|
|
Term
|
Definition
| key you press to switch to Edit mode |
|
|
Term
|
Definition
| view that shows you a reduced view of each page of your worksheet |
|
|
Term
|
Definition
| area where you see a preview of your worksheet |
|
|
Term
|
Definition
| view where you can see the header and footer areas of a worksheet |
|
|
Term
|
Definition
| lets you copy cell contents or continue a series of data into a range of selected cells |
|
|
Term
|
Definition
| lets you copy cell contents or continue a series of data into a range of selected cells |
|
|
Term
|
Definition
| item on the ribbon that opens a dialog box or task pane |
|
|
Term
|
Definition
| lets you move or copy data from one cell to another without using the clipboard |
|
|
Term
|
Definition
| clears the contents of selected cells |
|
|
Term
|
Definition
| displays an alphabetical list of functions from which you can choose |
|
|
Term
|
Definition
| key to press to copy while dragging and dropping selected cells |
|
|
Term
|
Definition
|
|
Term
|
Definition
| type of cell reference that changes when it is copied |
|
|
Term
|
Definition
| key to convert a relative cell reference to an absolute cell reference |
|
|
Term
|
Definition
| a temporary window storage area that holds the selections you copy or cut. can not enter a function here |
|
|
Term
|
Definition
| chages formatting of a cell that meets a certain rule |
|
|
Term
| button with arrow each way and center line |
|
Definition
| centers cell contents over multiple cells |
|
|
Term
|
Definition
| checks for apparent misspellings in a worksheet |
|
|
Term
|
Definition
| moves cell pointer back to cellA1 |
|
|
Term
|
Definition
| displays background color options in a cell |
|
|
Term
|
Definition
| adds dollar signs and 2 decimal places to selected data |
|
|
Term
| example of accounting number format |
|
Definition
|
|
Term
| Conditional Formatting Rules Manager |
|
Definition
| feature used to delete a conditional formatting rule |
|
|
Term
|
Definition
| button uses to remove the italic font style from selected cells |
|
|
Term
|
Definition
| the feature used to resize a column to accommodate its widest entry |
|
|
Term
| button with arrow.0 first row and .00 in second row. arrow points left |
|
Definition
| button that increases the number of decimal places in selected cells |
|
|
Term
|
Definition
| button that copies multiple formats from selected cells to other cells |
|
|
Term
|
Definition
| compares data using columns |
|
|
Term
|
Definition
| compares trends over even time intervals |
|
|
Term
|
Definition
| displays a column and line chart using different scales of measurement |
|
|
Term
|
Definition
| compares data as parts of a whole |
|
|
Term
|
Definition
| compares data as parts of a whole |
|
|
Term
|
Definition
| shows how volume changes over time |
|
|
Term
| 2 point arrow going up down |
|
Definition
| pointer used to resize a chart |
|
|
Term
|
Definition
| object in a chart that identifies the colors used for each data series |
|
|
Term
|
Definition
| the tab that appears only when a chart is selected |
|
|
Term
| how to move an embedded chart to a chart sheet |
|
Definition
| click a button on the Charts Tools Design tab |
|
|
Term
|
Definition
| tab on ribbon used to create a chart |
|
|
Term
|
Definition
| a collection of related data points in a chart |
|
|
Term
|
Definition
| function used to determine the future amount of an investment |
|
|
Term
|
Definition
| part of the PMT function that represents the loan amount |
|
|
Term
|
Definition
| function used to conditionally total cells |
|
|
Term
|
Definition
| function used to change the first letter of a string to uppercase |
|
|
Term
|
Definition
| part of the IF function that the conditions are stated in |
|
|
Term
| required when you enter rate & nper arguments in a PMT function |
|
Definition
| consistency in the units used |
|
|
Term
|
Definition
| used to express conditions such as less than or equal to |
|
|
Term
|
Definition
| adjusted automatically when rows and columns are inserted or deleted |
|
|
Term
|
Definition
| web page format hypertext markup language |
|
|
Term
|
Definition
| translucent background design on a printed worksheet |
|
|
Term
|
Definition
| an object that when clicked displays another worksheet or a web page |
|
|
Term
|
Definition
| portion of a worksheet that can be changed |
|
|
Term
|
Definition
| when added it is used to establish the validity of a workbook |
|
|
Term
|
Definition
| used to group several workbooks so that they can be opened together rather than individually |
|
|
Term
|
Definition
| arrange records in a particular sequence |
|
|
Term
|
Definition
|
|
Term
|
Definition
| organized collection of related information in excel |
|
|
Term
|
Definition
|
|
Term
|
Definition
| first row of a table containing field names |
|
|
Term
|
Definition
| the sorting options you use to sort a table of employee names in order from z to a |
|
|
Term
|
Definition
| a series in descending order |
|
|
Term
|
Definition
| way to add formatting to a table |
|
|
Term
| to print on multiple pages, you can define a print title to: |
|
Definition
| include field names at the top of each printed page |
|
|
Term
|
Definition
| cell range when advanced filter results are copied to another location |
|
|
Term
|
Definition
| name of the table searced in a VLOOKUP function |
|
|
Term
|
Definition
| range in which search conditions are set |
|
|
Term
|
Definition
| restricts table entries to specified options |
|
|
Term
|
Definition
| function used to total table values that meet specified criteria |
|
|
Term
|
Definition
| the logical condition finds records matching both listed criteria |
|
|
Term
|
Definition
| either criterion can be true to find a match |
|
|
