All Units
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Accent | show 🗑
|
||||
| show | A line that prints along the side of a table cell or around the outside of selected text
🗑
|
||||
| Conditional format | show 🗑
|
||||
| Custom color | show 🗑
|
||||
| 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
🗑
|
||||
| Format painter | show 🗑
|
||||
| show | To change the appearance, not the data, of a workbook
🗑
|
||||
| General number format | show 🗑
|
||||
| show | Text that appears at the top of every page in a document
🗑
|
||||
| Manual page break | show 🗑
|
||||
| Merge | show 🗑
|
||||
| Page break | show 🗑
|
||||
| show | Selected portion of a worksheet to be printed
🗑
|
||||
| Print title | show 🗑
|
||||
| Standard color | show 🗑
|
||||
| Style | show 🗑
|
||||
| Table | show 🗑
|
||||
| Table style | show 🗑
|
||||
| Theme | show 🗑
|
||||
| Theme color | show 🗑
|
||||
| Theme font | show 🗑
|
||||
| show | Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation
🗑
|
||||
| show | Cell reference that points to a specific cell and does not change when copied, appears with a dollar sign ($) before each column and row designation
🗑
|
||||
| Argument | show 🗑
|
||||
| show | A tool that enable you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the Copy and Paste commands.
🗑
|
||||
| Date function | show 🗑
|
||||
| Financial function | show 🗑
|
||||
| show | A logical function that returns one value if the statement is true and another value if the statement is false
🗑
|
||||
| show | The amount charged for lending money
🗑
|
||||
| show | A category of functions that tests, or evaluates, whether a condition, usually entered as an expression, is true or false
🗑
|
||||
| show | Cell reference that contains both relative and absolute references
🗑
|
||||
| Nested | show 🗑
|
||||
| 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 🗑
|
||||
| Bar chart | show 🗑
|
||||
| show | The group or category to which a series value belongs
🗑
|
||||
| Chart | show 🗑
|
||||
| show | The entire chart and all the elements contained in the chart or graph, such as the title and legend
🗑
|
||||
| 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
🗑
|
||||
| Data label | show 🗑
|
||||
| show | The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in a pie chart, and the points used in a XY scatter chart
🗑
|
||||
| Data series | show 🗑
|
||||
| show | Any file that contains the data you want to retrieve
🗑
|
||||
| show | A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart
🗑
|
||||
| Exploded pie chart | show 🗑
|
||||
| Graph | show 🗑
|
||||
| show | A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axes
🗑
|
||||
| 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
🗑
|
||||
| Horizontal (category) axis | show 🗑
|
||||
| Leader line | show 🗑
|
||||
| Legend | show 🗑
|
||||
| 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.
🗑
|
||||
| Major tick mark | show 🗑
|
||||
| show | The illusion that some parts of the 3-D chart are farther away from you than others
🗑
|
||||
| Pie chart | show 🗑
|
||||
| show | A rectangular area containing a graphical representation of the values in the data series
🗑
|
||||
| Primary value axis | show 🗑
|
||||
| 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
🗑
|
||||
| show | The name of the data series
🗑
|
||||
| show | The actual data displayed in a chart
🗑
|
||||
| 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
🗑
|
||||
| Ascending order | show 🗑
|
||||
| Category field | show 🗑
|
||||
| show | To remove
🗑
|
||||
| show | Field Name
🗑
|
||||
| show | Conditions that you specify for a filter
🗑
|
||||
| show | The sequence you specify to sort data
🗑
|
||||
| Data definition table | show 🗑
|
||||
| Descending order | show 🗑
|
||||
| Field | show 🗑
|
||||
| Field name | show 🗑
|
||||
| Filter | show 🗑
|
||||
| show | The row of field names
🗑
|
||||
| PivotChart | show 🗑
|
||||
| PivotTable | show 🗑
|
||||
| Primary sort field | show 🗑
|
||||
| Record | show 🗑
|
||||
| show | To update
🗑
|
||||
| Report filter | show 🗑
|
||||
| Secondary sort field | show 🗑
|
||||
| show | A field you use to order data
🗑
|
||||
| Total row | show 🗑
|
||||
| show | In a PivotTable, a field that contains summary data
🗑
|
||||
| show | The same cell or range in multiple worksheets in the same workbook
🗑
|
||||
| Custom template | show 🗑
|
||||
| show | A template that creates the blank Book1 workbook that originally opens. The default template contains no text or formulas.
🗑
|
||||
| Destination file | show 🗑
|
||||
| show | A reference to a cell or range in a worksheet in another workbook
🗑
|
||||
| show | A language that is used to create web pages
🗑
|
||||
| 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
🗑
|
||||
| show | The workbook that contains the data when two files are linked
🗑
|
||||
| Template | show 🗑
|
||||
| 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
🗑
|
||||
| Compare value | show 🗑
|
||||
| COUNTIF function | show 🗑
|
||||
| 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
🗑
|
||||
| show | A function that performs summary data analysis (SUM, AVERAGE, COUNT, etc.) on a table of values based on criteria you set
🗑
|
||||
| Error value | show 🗑
|
||||
| show | The function used to determine if a cell contains an error value and displays the message you chose rather than the default error value
🗑
|
||||
| show | A table that organizes data you want to retrieve into different categories
🗑
|
||||
| show | The value you are trying to find or retrieve from a lookup table
🗑
|
||||
| show | One IF function placed inside another IF function to test an additional condition
🗑
|
||||
| OR function | show 🗑
|
||||
| Rule | show 🗑
|
||||
| Structured reference | show 🗑
|
||||
| show | A function that adds the values in a range that meet criteria you specify; also called conditional sum
🗑
|
||||
| SUMIFS function | show 🗑
|
||||
| VLOOKUP function | show 🗑
|
||||
| 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 🗑
|
||||
| show | A message that appears if a user tries to enter a value in a cell that does not meet its validation rule
🗑
|
||||
| Input message | show 🗑
|
||||
| Locked property | show 🗑
|
||||
| Macro | show 🗑
|
||||
| show | A setting that control how macros will be used when opening a workbook
🗑
|
||||
| Macro virus | show 🗑
|
||||
| show | In VBA a collection of sub procedures
🗑
|
||||
| Name | show 🗑
|
||||
| Personal macro workbook | show 🗑
|
||||
| show | To limit user access to certain parts of a workbook and the ability to make changes in the workbook to reduce data entry errors
🗑
|
||||
| Sub procedure | show 🗑
|
||||
| show | A central location for all the security settings
🗑
|
||||
| show | A statement that defines criteria for the data that can be stored in a cell or range
🗑
|
||||
| Visual basic editor | show 🗑
|
||||
| show | A programming language
🗑
|
||||
| Amortization schedule | show 🗑
|
||||
| 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
🗑
|
||||
| show | Cash coming into a business from revenue
🗑
|
||||
| Cash outflow | show 🗑
|
||||
| show | Any costs directly related to production of a tangible item
🗑
|
||||
| show | Depreciation of an asset by a constant percentage each year rather than a constant amount
🗑
|
||||
| Dependent cell | show 🗑
|
||||
| Depreciation | show 🗑
|
||||
| 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
🗑
|
||||
| FV function | show 🗑
|
||||
| Gross profit | show 🗑
|
||||
| show | When values change not by a constant percentage; when plotted, a growth trend appears as a curve with the greatest increases occurring near the end of the series
🗑
|
||||
| Income statement | show 🗑
|
||||
| show | The point at which the net present value of an investment equals zero
🗑
|
||||
| Interpolate | show 🗑
|
||||
| show | When values change by a constant amount; when plotted, a linear trend appears as a straight line
🗑
|
||||
| Negative cash flow | show 🗑
|
||||
| show | Income after all expenses and taxes have been paid
🗑
|
||||
| Net present value | show 🗑
|
||||
| NPER function | show 🗑
|
||||
| show | The length of time required for an investment to recover its initial cost
🗑
|
||||
| PMT function | show 🗑
|
||||
| show | The movement of cash assets into an account, also called cash inflow
🗑
|
||||
| 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 🗑
|
||||
| Risk | show 🗑
|
||||
| show | The assumption that money received today is worth more than the same amount received later
🗑
|
||||
| Tracer arrow | show 🗑
|
||||
| Salvage value | show 🗑
|
||||
| Straight-Line Depreciation | show 🗑
|
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