Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Adv Spreadsheet All
All Units
| Question | Answer |
|---|---|
| Accent | A variation on a theme color |
| Border | A line that prints along the side of a table cell or around the outside of selected text |
| Conditional format | A setting that applies formatting only when a cell's value meets a specified condition |
| Custom color | 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 |
| Font | A set of characters that uses the same typeface, style and size |
| Font size | Determined by point size, which is a unit of measurement equal approximately to 1/72 of an inch |
| Font style | 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 | A button that when selected copies a format from one cell range to another |
| Formatting | To change the appearance, not the data, of a workbook |
| General number format | Default number format that automatically displays numbers, for the most part, the same way as you enter them |
| Header | Text that appears at the top of every page in a document |
| Manual page break | A page break you insert anywhere on a page |
| Merge | To combine the main document with a data source |
| Page break | Location in a worksheet that determines where a new page begins |
| Print area | Selected portion of a worksheet to be printed |
| Print title | Information that prints on each page |
| Standard color | A color that is always available regardless of the workbook's theme |
| Style | A saved collection of formatting options - number formats, text alignment, font sizes and colors, borders, and background fills - that can be applied to cells in a worksheet |
| Table | A collection of data arranged in rows and columns |
| Table style | A setting that applies styles to four table elements (header row, first column, last column, and totals row) |
| Theme | A designed collection of formatting options that include colors, graphics, and background images |
| Theme color | The 12 colors that belong to a workbook's theme |
| Theme font | A font associated with a particular design theme and used for headings and body text |
| Footer | Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation |
| Absolute reference | 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 | Specifies the numbers, text, or cell references used by the function to calculate a value |
| AutoFill | 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 | A category of functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900 |
| Financial function | A category of functions that calculate values from loans and investments |
| IF function | A logical function that returns one value if the statement is true and another value if the statement is false |
| Interest | The amount charged for lending money |
| Logical function | A category of functions that tests, or evaluates, whether a condition, usually entered as an expression, is true or false |
| Mixed reference | Cell reference that contains both relative and absolute references |
| Nested | Functions or other parts of a formula placed inside another function |
| PMT function | The financial function to calculate the amount paid into an investment or loan during each payment period |
| Principal | The amount of money being loaned |
| Relative reference | In a formula, the address of a cell range based on the position of the cell that contains the formula and the cell the formula refers to. When copied, the reference is adjusted to reflect the new location of the cell containing the formula |
| Simple interest | The type of interest in which the interest paid is equal to a percentage of principal for each period that the money has been lent |
| Bar chart | A column chart turned on its side so each bar length is based on its value |
| Category values | The group or category to which a series value belongs |
| Chart | graph that provides a visual representation for the workbook data |
| Chart area | The entire chart and all the elements contained in the chart or graph, such as the title and legend |
| Chart sheet | 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 | Term that appears above the plot area and describes the contents of the plot area and the data series |
| Column chart | A type of chart that displays values in different categories as columns; the height of each column is based on its value |
| Combination chart | A chart that combines two or more chart types into a single graph |
| Data label | Text associated with a data value |
| Data marker | 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 | A range of data values that is plotted as a unit on the chart |
| Data source | Any file that contains the data you want to retrieve |
| Embedded chart | 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 | A chart with one slice moved away from the pie as if someone were taking the piece out of the pie |
| Graph | Another name for chart |
| Gridlines | A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axes |
| Group | 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 | On this axis, or x-axis, are the data series' category values, or x values |
| Leader line | 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 |
| Legend | A table on a chart listing and explaining the symbols used |
| Line chart | 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 | The indication of the major units of increment on the x- or y-axis |
| Perspective | The illusion that some parts of the 3-D chart are farther away from you than others |
| Pie chart | A chart in the shape of a circle that shows data values as percentage of the whole |
| Plot area | A rectangular area containing a graphical representation of the values in the data series |
| Primary value axis | The axis in a column chart that displays the primary values associated with the heights of each column |
| Resizing handle | A square or dot on a selecting box that lets you change an object's width and height |
| Scale | The range of values that spans along an axis |
| Secondary value axis | The axis in a column chart that displays the secondary values associated with the heights of each column |
| Series name | The name of the data series |
| Series values | The actual data displayed in a chart |
| Vertical (Value) Axis | The y-axis where, for example, data values, such as sales values, are plotted |
| XY scatter chart | A chart that shows the patterns or relationship between two or more sets of values |
| Ascending order | Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest |
| Category field | A field used to group the values in a PivotTable |
| Clear | To remove |
| Column header | Field Name |
| Criteria filter | Conditions that you specify for a filter |
| Custom list | The sequence you specify to sort data |
| Data definition table | Documentation that lists the fields to be maintained for each record and description of the information each field will include |
| Descending order | Sorts text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest |
| Field | An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state) |
| Field name | A unique label that describes the contents of the data in a column; also called a column header |
| Filter | The process of temporarily hiding records that do not meet the specified criteria |
| Header row | The row of field names |
| PivotChart | A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields |
| PivotTable | 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 |
| Primary sort field | The first sort field |
| Record | A collection of related fields that are grouped together, each row represents one |
| Refresh | To update |
| Report filter | Filters the PivotTable to display summarized data for one or more field items or all field items area |
| Secondary sort field | The second sort field |
| Sort field | A field you use to order data |
| Total row | A row at the end of a table that is used to calculate summary statistics for the columns in the table |
| Value field | In a PivotTable, a field that contains summary data |
| 3-D reference | The same cell or range in multiple worksheets in the same workbook |
| Custom template | A workbook template you can create that is ready to run with the formulas for all calculations included as well as formatting |
| Default template | A template that creates the blank Book1 workbook that originally opens. The default template contains no text or formulas. |
| Destination file | The workbook that receives the data when two files are linked |
| External reference | A reference to a cell or range in a worksheet in another workbook |
| HTML | A language that is used to create web pages |
| Hyperlink | 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 |
| Link | A connection between the files that allows data to be transferred from one file to the other |
| Source file | The workbook that contains the data when two files are linked |
| Template | A workbook that you can open with labels, formats and formulas already built into it from which you create new workbooks |
| Worksheet group | 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 | A file that saves information about all of the currently opened workbooks, such as their locations, window size, zoom magnifications, and other settings |
| AND function | A logical function that returns a TRUE value if all the logical conditions are true a FALSE value if any or all of the logical conditions are false |
| AVERAGEIF function | A function that calculates the average of values in a range that meet criteria you specify |
| AVERAGEIFS function | A function that calculates the average of values within a range of cells that meet multiple conditions |
| Calculated column | 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 | A category for a lookup table that is located in the table's first column or row |
| COUNTIF function | A function that calculates the number of cells in a range that match criteria you specify |
| COUNTIFS function | A function that counts the number of cells within a range that meet multiple criteria |
| Criteria range | 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 | A function that performs summary data analysis (SUM, AVERAGE, COUNT, etc.) on a table of values based on criteria you set |
| Error value | 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 | The function used to determine if a cell contains an error value and displays the message you chose rather than the default error value |
| Lookup table | A table that organizes data you want to retrieve into different categories |
| Lookup value | The value you are trying to find or retrieve from a lookup table |
| Nested IF function | One IF function placed inside another IF function to test an additional condition |
| OR function | 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 | A statement that specifies the type of condition, the type of formatting when that condition occurs, and the cellular range the formatting is applied to |
| Structured reference | Table name or table column header that you can use in a formula in place of its cell or range reference |
| SUMIF function | A function that adds the values in a range that meet criteria you specify; also called conditional sum |
| SUMIFS function | A function that adds value in a range that meet multiple criteria |
| VLOOKUP function | 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 |
| Comment | A text box that is attached to a specific cell in a worksheet; used for documentation or notes |
| Data validation | A set of rules that determine what users can enter in a specific cell or range |
| Defined name | A word or string of characters associated with a single cell or range |
| Digital signature | An electronic version of a written signature that provides a way to authenticate a workbook |
| Error alert message | A message that appears if a user tries to enter a value in a cell that does not meet its validation rule |
| Input message | A message that appears when a user clicks a cell; can be used to specify the type of data to enter in the cell |
| Locked property | A setting that determines whether changes can be made to a cell |
| Macro | A series of stored commands that can be run whenever you need to perform the record task |
| Macro security | A setting that control how macros will be used when opening a workbook |
| Macro virus | A type of virus that uses a program's own macro programming language to distribute the virus |
| Module | In VBA a collection of sub procedures |
| Name | A word or string of characters associated with a single cell or range |
| Personal macro workbook | A hidden workbook named Personal.xlsb that opens and stores commonly used macros |
| Protect worksheet | 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 | 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 | A central location for all the security settings |
| Validation rule | A statement that defines criteria for the data that can be stored in a cell or range |
| Visual basic editor | A separate program that works with the products to edit and manage VBA code |
| Visual Basic of Applications (VBA) | A programming language |
| Amortization schedule | 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 |
| Balance sheet | A file that shows what the company owns and how its assets are financed |
| Cash flow | The movement of cash assets into or out of an account |
| Cash inflow | Cash coming into a business from revenue |
| Cash outflow | Cash paid out of a business |
| Cost of goods sold | Any costs directly related to production of a tangible item |
| Declining balance depreciation | Depreciation of an asset by a constant percentage each year rather than a constant amount |
| Dependent cell | A cell whose value depends on the value of other cells |
| Depreciation | The process of allocating the original cost of the investment over the years of use |
| Discount rate | Time value of money, quoted as a percentage to indicate the value of future dollars |
| Error indicator | A green triangle in the upper-left corner of a cell that contains an error or potential error |
| Extrapolate | To calculate a series of values from a starting point without a defined ending point |
| FV function | The financial function to calculate the future value of an investment or loan |
| Gross profit | The difference between the company's sales revenue and the cost of goods sold |
| Growth trend | 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 | A file that shows how much money a business makes or losses over a specified period of time |
| Internal rate or return (IRR) | The point at which the net present value of an investment equals zero |
| Interpolate | To fill in missing values when you know the beginning and the ending values in a series and the series trend |
| Linear trend | When values change by a constant amount; when plotted, a linear trend appears as a straight line |
| Negative cash flow | The movement of cash assets out of an account |
| Net income | Income after all expenses and taxes have been paid |
| Net present value | The current value of all the cash inflows and outflows in an investment adjusted by the time value of money |
| NPER function | The financial function to calculate the number of payment periods in an investment or loan |
| Payback period | The length of time required for an investment to recover its initial cost |
| PMT function | The financial function to calculate the amount paid into an investment or loan during each payment period |
| Positive cash flow | The movement of cash assets into an account, also called cash inflow |
| Precedent cell | A cell whose value is used to calculate the active cell's value |
| Profit and loss statement | A file that shows how much money a business makes or losses over a specified period of time |
| PV function | The financial function to calculate the present value of an investment or loan |
| Tangible asset | A long lasting material asset not intended for sale, such as equipment, land, buildings and delivery trucks |
| RATE function | The financial function to calculate the interest rate charged or received during each payment period |
| Rate of return | The time value of money, also known as the discount rate |
| Risk | The possibility that an entire transaction will fail, resulting in a loss of the initial investment |
| Time value of money | The assumption that money received today is worth more than the same amount received later |
| Tracer arrow | An arrow that provides visual clues to the relationship between two cells by pointing from the precedent cell to the dependent cell |
| Salvage value | The value of an asset at the end of its useful life |
| Straight-Line Depreciation | Depreciation of an asset by equal amounts each year of its lifetime until it reaches the salvage value |
Created by:
Jame Pearce
Popular Computers sets