All Units
Help!
|
|
||||
|---|---|---|---|---|---|
| show | A variation on a theme color
🗑
|
||||
| show | A line that prints along the side of a table cell or around the outside of selected text
🗑
|
||||
| Conditional format | show 🗑
|
||||
| show | A color you specify as a mixture of red, blue, and green color values, which makes available 17.7 million custom colors – more than the eye can distinguish
🗑
|
||||
| show | A set of characters that uses the same typeface, style and size
🗑
|
||||
| Font size | show 🗑
|
||||
| show | Various ways that fonts can be displayed, such as regular, italic, bold or bold italic, a special attribute applies to the characters of a font
🗑
|
||||
| show | A button that when selected copies a format from one cell range to another
🗑
|
||||
| Formatting | show 🗑
|
||||
| show | Default number format that automatically displays numbers, for the most part, the same way as you enter them
🗑
|
||||
| Header | show 🗑
|
||||
| show | A page break you insert anywhere on a page
🗑
|
||||
| show | To combine the main document with a data source
🗑
|
||||
| show | Location in a worksheet that determines where a new page begins
🗑
|
||||
| Print area | show 🗑
|
||||
| Print title | show 🗑
|
||||
| Standard color | show 🗑
|
||||
| Style | show 🗑
|
||||
| Table | show 🗑
|
||||
| show | A setting that applies styles to four table elements (header row, first column, last column, and totals row)
🗑
|
||||
| Theme | show 🗑
|
||||
| show | The 12 colors that belong to a workbook's theme
🗑
|
||||
| show | A font associated with a particular design theme and used for headings and body text
🗑
|
||||
| Footer | show 🗑
|
||||
| Absolute reference | show 🗑
|
||||
| Argument | show 🗑
|
||||
| AutoFill | show 🗑
|
||||
| Date function | show 🗑
|
||||
| show | A category of functions that calculate values from loans and investments
🗑
|
||||
| IF function | show 🗑
|
||||
| Interest | show 🗑
|
||||
| Logical function | show 🗑
|
||||
| Mixed reference | show 🗑
|
||||
| show | Functions or other parts of a formula placed inside another function
🗑
|
||||
| show | The financial function to calculate the amount paid into an investment or loan during each payment period
🗑
|
||||
| show | The amount of money being loaned
🗑
|
||||
| Relative reference | show 🗑
|
||||
| Simple interest | show 🗑
|
||||
| show | A column chart turned on its side so each bar length is based on its value
🗑
|
||||
| show | The group or category to which a series value belongs
🗑
|
||||
| Chart | show 🗑
|
||||
| Chart area | show 🗑
|
||||
| show | A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart
🗑
|
||||
| Chart title | show 🗑
|
||||
| show | A type of chart that displays values in different categories as columns; the height of each column is based on its value
🗑
|
||||
| show | A chart that combines two or more chart types into a single graph
🗑
|
||||
| show | Text associated with a data value
🗑
|
||||
| Data marker | show 🗑
|
||||
| show | A range of data values that is plotted as a unit on the chart
🗑
|
||||
| Data source | show 🗑
|
||||
| Embedded chart | show 🗑
|
||||
| show | A chart with one slice moved away from the pie as if someone were taking the piece out of the pie
🗑
|
||||
| show | Another name for chart
🗑
|
||||
| Gridlines | show 🗑
|
||||
| show | A collection of buttons for related commands; allows changes in one worksheet to affect other worksheets also; allows different shapes to be moved as one shape
🗑
|
||||
| show | On this axis, or x-axis, are the data series' category values, or x values
🗑
|
||||
| show | In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force data labels far from its slice
🗑
|
||||
| show | A table on a chart listing and explaining the symbols used
🗑
|
||||
| show | A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly-spaced intervals. The values are indicated by the height of the line.
🗑
|
||||
| show | The indication of the major units of increment on the x- or y-axis
🗑
|
||||
| Perspective | show 🗑
|
||||
| show | A chart in the shape of a circle that shows data values as percentage of the whole
🗑
|
||||
| Plot area | show 🗑
|
||||
| show | The axis in a column chart that displays the primary values associated with the heights of each column
🗑
|
||||
| show | A square or dot on a selecting box that lets you change an object's width and height
🗑
|
||||
| show | The range of values that spans along an axis
🗑
|
||||
| show | The axis in a column chart that displays the secondary values associated with the heights of each column
🗑
|
||||
| Series name | show 🗑
|
||||
| Series values | show 🗑
|
||||
| show | The y-axis where, for example, data values, such as sales values, are plotted
🗑
|
||||
| show | A chart that shows the patterns or relationship between two or more sets of values
🗑
|
||||
| show | Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest
🗑
|
||||
| Category field | show 🗑
|
||||
| Clear | show 🗑
|
||||
| Column header | show 🗑
|
||||
| Criteria filter | show 🗑
|
||||
| show | The sequence you specify to sort data
🗑
|
||||
| Data definition table | show 🗑
|
||||
| show | Sorts text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest
🗑
|
||||
| Field | show 🗑
|
||||
| Field name | show 🗑
|
||||
| Filter | show 🗑
|
||||
| show | The row of field names
🗑
|
||||
| PivotChart | show 🗑
|
||||
| show | An interactive table that enables you to group and summarize either a range of data or a table into a concise, tabular format for easier reporting and analysis
🗑
|
||||
| show | The first sort field
🗑
|
||||
| show | A collection of related fields that are grouped together, each row represents one
🗑
|
||||
| Refresh | show 🗑
|
||||
| Report filter | show 🗑
|
||||
| show | The second sort field
🗑
|
||||
| Sort field | show 🗑
|
||||
| show | A row at the end of a table that is used to calculate summary statistics for the columns in the table
🗑
|
||||
| Value field | show 🗑
|
||||
| 3-D reference | show 🗑
|
||||
| show | A workbook template you can create that is ready to run with the formulas for all calculations included as well as formatting
🗑
|
||||
| show | A template that creates the blank Book1 workbook that originally opens. The default template contains no text or formulas.
🗑
|
||||
| show | The workbook that receives the data when two files are linked
🗑
|
||||
| show | A reference to a cell or range in a worksheet in another workbook
🗑
|
||||
| HTML | show 🗑
|
||||
| show | A link in a file to information within that file or another file that, when clicked, switches to the file or portion of the file referenced by the link
🗑
|
||||
| show | A connection between the files that allows data to be transferred from one file to the other
🗑
|
||||
| Source file | show 🗑
|
||||
| show | A workbook that you can open with labels, formats and formulas already built into it from which you create new workbooks
🗑
|
||||
| show | A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group
🗑
|
||||
| Workspace | show 🗑
|
||||
| AND function | show 🗑
|
||||
| show | A function that calculates the average of values in a range that meet criteria you specify
🗑
|
||||
| AVERAGEIFS function | show 🗑
|
||||
| show | A column in a table that automatically fills with a formula after you enter or edit a formula in one cell of that column
🗑
|
||||
| show | A category for a lookup table that is located in the table's first column or row
🗑
|
||||
| show | A function that calculates the number of cells in a range that match criteria you specify
🗑
|
||||
| show | A function that counts the number of cells within a range that meet multiple criteria
🗑
|
||||
| show | An area in a worksheet, separate from the range of data or table, used to specify the criteria for the data to be displayed after the filter is applied to the table
🗑
|
||||
| Database function | show 🗑
|
||||
| show | Text displayed in a cell to indicate that some element in a formula or a cell referenced in that formula is preventing the return of a calculated value. Common ones are DIV/0!, N/A, and VALUE!
🗑
|
||||
| IFERROR function | show 🗑
|
||||
| show | A table that organizes data you want to retrieve into different categories
🗑
|
||||
| Lookup value | show 🗑
|
||||
| Nested IF function | show 🗑
|
||||
| show | A logical function that returns a TRUE value if any of the logical conditions are true or FALSE value if all the logical conditions are false
🗑
|
||||
| Rule | show 🗑
|
||||
| show | Table name or table column header that you can use in a formula in place of its cell or range reference
🗑
|
||||
| SUMIF function | show 🗑
|
||||
| SUMIFS function | show 🗑
|
||||
| show | A function that searches vertically down a lookup table to retrieve a value from that table; used when the compare values are stored in the first column of the lookup table
🗑
|
||||
| show | A text box that is attached to a specific cell in a worksheet; used for documentation or notes
🗑
|
||||
| Data validation | show 🗑
|
||||
| show | A word or string of characters associated with a single cell or range
🗑
|
||||
| Digital signature | show 🗑
|
||||
| Error alert message | show 🗑
|
||||
| Input message | show 🗑
|
||||
| Locked property | show 🗑
|
||||
| Macro | show 🗑
|
||||
| show | A setting that control how macros will be used when opening a workbook
🗑
|
||||
| show | A type of virus that uses a program's own macro programming language to distribute the virus
🗑
|
||||
| Module | show 🗑
|
||||
| Name | show 🗑
|
||||
| Personal macro workbook | show 🗑
|
||||
| Protect worksheet | show 🗑
|
||||
| show | In VBA, a macro procedure that performs an action on a project or workbook, such as formatting a cell or displaying a chart
🗑
|
||||
| Trust center | show 🗑
|
||||
| Validation rule | show 🗑
|
||||
| Visual basic editor | show 🗑
|
||||
| Visual Basic of Applications (VBA) | show 🗑
|
||||
| show | A file with details about each loan payment, specifying how much of the payment is devoted toward interest and how much toward repaying the principal
🗑
|
||||
| show | A file that shows what the company owns and how its assets are financed
🗑
|
||||
| show | The movement of cash assets into or out of an account
🗑
|
||||
| Cash inflow | show 🗑
|
||||
| show | Cash paid out of a business
🗑
|
||||
| Cost of goods sold | show 🗑
|
||||
| Declining balance depreciation | show 🗑
|
||||
| show | A cell whose value depends on the value of other cells
🗑
|
||||
| show | The process of allocating the original cost of the investment over the years of use
🗑
|
||||
| show | Time value of money, quoted as a percentage to indicate the value of future dollars
🗑
|
||||
| show | A green triangle in the upper-left corner of a cell that contains an error or potential error
🗑
|
||||
| show | To calculate a series of values from a starting point without a defined ending point
🗑
|
||||
| show | The financial function to calculate the future value of an investment or loan
🗑
|
||||
| Gross profit | show 🗑
|
||||
| Growth trend | show 🗑
|
||||
| Income statement | show 🗑
|
||||
| show | The point at which the net present value of an investment equals zero
🗑
|
||||
| show | To fill in missing values when you know the beginning and the ending values in a series and the series trend
🗑
|
||||
| show | When values change by a constant amount; when plotted, a linear trend appears as a straight line
🗑
|
||||
| Negative cash flow | show 🗑
|
||||
| Net income | show 🗑
|
||||
| Net present value | show 🗑
|
||||
| show | The financial function to calculate the number of payment periods in an investment or loan
🗑
|
||||
| Payback period | show 🗑
|
||||
| PMT function | show 🗑
|
||||
| Positive cash flow | show 🗑
|
||||
| show | A cell whose value is used to calculate the active cell's value
🗑
|
||||
| Profit and loss statement | show 🗑
|
||||
| show | The financial function to calculate the present value of an investment or loan
🗑
|
||||
| Tangible asset | show 🗑
|
||||
| RATE function | show 🗑
|
||||
| Rate of return | show 🗑
|
||||
| show | The possibility that an entire transaction will fail, resulting in a loss of the initial investment
🗑
|
||||
| Time value of money | show 🗑
|
||||
| Tracer arrow | show 🗑
|
||||
| show | The value of an asset at the end of its useful life
🗑
|
||||
| show | Depreciation of an asset by equal amounts each year of its lifetime until it reaches the salvage value
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
Jame Pearce
Popular Computers sets