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
excel
midterm
| Question | Answer |
|---|---|
| active cell | The cell currently selected in the active worksheet. (EX 2) |
| active sheet | The sheet currently displayed in the workbook window. (EX 2) |
| arithmetic operator | An operator that performs addition, subtraction, multiplication, division, or exponentiation. (EX 32) |
| AutoComplete | The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier. (EX 20) |
| AutoFit | The feature that changes the column width or row height to display longest or tallest entry within the column or row. (EX 27) |
| AutoSum | The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range. (EX 31) |
| Backstage view | The FILE tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options. (EX 4) |
| border | A line you can add along an edge of cell that prints. (EX 30) |
| cell | The intersection of a row and a column. (EX 3) |
| cell range (range) | A group of cells in a rectangular block. (EX 2) |
| cell reference | The column and row location that identifies a cell within a worksheet. (EX 9) |
| chart sheet | A sheet that contains only a chart that provides a visual representation of worksheet data. (EX 7) |
| clearing | To remove the data from a row or column but leaves the blank row or column in the worksheet. (EX 45) |
| Clipboard | A temporary storage location for text and graphics. (EX 35) |
| column headings | The letters along the top of the worksheet window that identify the different columns in the worksheet. (EX 3) |
| date data | A value in a recognized date format. (EX 17) |
| delete | To remove the data from a row or column as well as the row or column itself. (EX 45) |
| drag and drop | The technique to move a cell or range by selecting it, dragging the selection by its bottom border to a new location, and then releasing the mouse button to drop the selection in the new location. (EX 40) |
| Edit mode | The mode in which you can edit cell contents. (EX 19) |
| Flash Fill | The feature that enters text based on patterns it finds in the data. (EX 48) |
| formatting | Changes to a worksheet’s appearance to make its content easier to read. (EX 49) |
| formula | A mathematical expression that returns a value. (EX 31) |
| formula bar | The bar located below the ribbon that displays the value or formula entered in the active cell. (EX 2) |
| font size | The size of text. (EX 30) |
| function | A named operation that replaces the action of an arithmetic expression in a formula. (EX 31) |
| group | A collection of buttons for related commands on a ribbon tab. (EX 3) |
| hide | To make a row, column, or worksheet not visible. (EX 48) |
| keyboard shortcut | A key or combination of keys that you press to access a feature or perform a command. (EX 6) |
| Key Tips | Labels that appear over each tab and command on the ribbon when you press the Alt key that specify the key or keys to click to access that tab, button, or command. (EX 6) |
| landscape orientation | The page orientation where the page is wider than it is tall. (EX 53) |
| Maximize button | The button that expands a window to fill the screen. (EX 3) |
| Microsoft Excel 2013 (Excel) | An application used to enter, analyze, and present quantitative data. (EX 1) |
| Minimize button | The button that hides a window so that only its program button is visible on the taskbar. (EX 3) |
| Name box | The box located at the left side of the formula bar that displays the cell reference of the active cell. (EX 2) |
| nonadjacent range | A collection of separate ranges. (EX 2) |
| Normal view | The Excel view that shows the contents of the active sheet in the workbook window. (EX 31) |
| numeric data | Any number that can be used in a mathematical calculation. (EX 17) |
| operator | A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. (EX 32) |
| order of operations | A set of predefined rules used to determine the sequence in which operators are applied in a calculation. (EX 32) |
| Page Break Preview | The Excel view that shows the location of page breaks in the printed sheet. (EX 31) |
| Page Layout view | The Excel view that shows how the sheet will appear when printed. (EX 31) |
| pixel | A single point on a computer monitor or printout. (EX 25) |
| planning analysis sheet | A series of questions that help you think about a workbook’s purpose and how to achieve your desired results. (EX 13) |
| point | A unit of measure equal to approximately 1/72 of an inch. (EX 28) |
| portrait orientation | The page orientation where the page is taller than it is wide. (EX 53) |
| range reference | The cell reference of the upper-left cell in the range and the cell reference of the lower-right cell separated by a colon that identifies the range. (EX 11) |
| Restore Down button | The button that returns a window to its previous size. (EX 3) |
| ribbon | The main set of commands organized into tabs and groups with buttons that you click to execute commands. (EX 2) |
| row headings | The numbers along the left side of the workbook window that identify the different rows of the worksheet. (EX 2) |
| scale | To change the size of the worksheet on the printed page. (EX 54) |
| ScreenTip | A box with descriptive text about a command that appears when you point to a button on the ribbon. (EX 6) |
| sheet | A page included in a workbook; can be a worksheet or a chart sheet. (EX 2) |
| sheet tab | The area at the bottom of the worksheet that identifies the sheet by name. (EX 2) |
| shortcut menu | A list of commands related to a selection that opens when you click the right mouse button. (EX 17) |
| spreadsheet | A grouping of text and numbers in a rectangular grid or table. (EX 4) |
| status bar | An area at the bottom of the Excel window that provides information about the workbook. (EX 2 |
| SUM | The function that adds values in a specified range. (EX 31) |
| syntax | A set of rules that specifies how a function should be written. (EX 36) |
| tab | The part of the ribbon that includes commands related to particular activities or tasks. (EX 2) |
| template | A preformatted workbook with many design features and some content already filled in. (EX 4) |
| text data | Any combination of letters, numbers, and symbols. (EX 17) |
| text string | A series of text characters (EX 17) |
| time data | A value in a recognized time format. (EX 17) |
| Touch Mode | The mode for use with a touchscreen; changes the ribbon to make it easier to use a finger or a stylus to tap a button. (EX 6) |
| unhide | To redisplay a hidden row, column, or worksheet. (EX 48) |
| workbook | An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets. (EX 2) |
| workbook window | The area of the Excel window that displays the contents of the workbook. (EX 3) |
| worksheet | A grid of rows and columns in which content is entered. (EX 3) |
| Zoom controls | The controls that increase or decrease the magnification of the worksheet content. (EX 3) |
| Accounting format | The number format that places a currency symbol at the left edge of the column, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their currency symbols and decimal points; negative numbers are encl |
| automatic page break | A page break Excel sets automatically when the page of the printout is full. (EX 97) |
| Average function | An Excel function that calculates the average value from a collection or numbers. (EX 98) |
| cell highlighting | A conditional format that changes a cell's font color or fill color based on the cell’s value. (EX 97) |
| cell style | Predefined formatting options that you can apply to cells in a worksheet. (EX 97) |
| Comma style | The number format that adds a thousands separator to numbers, adds two decimal places, and lines up values within a column by their decimal points. (EX 69) |
| conditional format | Formatting applied to a cell when its value meets a specified condition. (EX 108) |
| Currency format | The number format that places a currency symbol directly to the left of the first digit of the currency value, adds a thousands separator to the value, and shows two decimal places; lines up numbers within a column by their decimal points; negative numbe |
| fill color | A background color that can be added to cells to help differentiate parts of a worksheet or highlight data. (EX 69) |
| font | A set of characters that employ the same typeface, such as Arial, Times New Roman, and Courier. (EX 68) |
| font style | e Formats that can applied to a font such as italic, bold, bold italic, underline, strikethrough, and color. (EX 68) |
| footer | Information that appears at the bottom of each printed page. (EX 119) |
| Format Painter | A feature that copies and pastes formatting from one cell or range to another without duplicating any data. (EX 96) |
| gallery | A menu or grid that shows a visual representation of the options available or the selected button. (EX 70) |
| General format | The number format that, for the most part, displays values exactly as they are typed. (EX 82) |
| header | Information that appears at the top of each printed page. (EX 119) |
| legend | A key that identifies the colors or the shapes used in a worksheet or a chart. (EX 112) |
| Live Preview | A preview of how a workbook would be affected by an option in a gallery. (EX 70) |
| Long Date format | A format for dates that displays the day of the week and the full month in addition to the day of the month and the year. (EX 86) |
| manual page break | A page break you insert to indicate where a new page of the printout should start. (EX 96) |
| margin | The space between the page content and the edges of the page. (EX 121) |
| merge | To combine, such as several cells into one cell. (EX 68) |
| Mini toolbar | A toolbar that contains buttons to perform common formatting options for a selection. (EX 75) |
| non-theme font | A font that is not associated with a particular theme; non-theme fonts retain their appearance no matter what theme is used with the workbook. (EX 71) |
| Percent style | The number format for percentages that adds the % symbol after the number and no decimal places. (EX 68) |
| print area | The range or ranges in a worksheet that you specify to be printed. (EX 97) |
| print title | Information that appears on every printed page; specified as rows or columns to repeat on the top or left of each page. (EX 96) |
| Quick Analysis tool | A button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting for the selected range. (EX 110) |
| RGB Color model | A format used to create custom colors by specifying varying intensities of red, green, and blue. (EX 74) |
| sans serif font | A font that does not include extra strokes, such as Arial. (EX 71) |
| serif font | A font that has extra strokes at the end of each character, such as Times New Roman. (EX 71) |
| Short Date format | An abbreviated format for dates in the format mm/dd/yyyy. (EX 86) |
| standard colors | The 10 colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—that are always available regardless of the workbook’s theme. (EX 73) |
| style | A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. (EX 99) |
| theme | A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel. (EX 70) |
| theme colors | The 12 colors that belong to the workbook’s theme. (EX 73) |
| theme font | A font associated with a particular theme and used for headings and body text in the workbook; theme fonts change automatically when you change the theme applied to the workbook. (EX 71) |
| absolute reference | A cell reference that remains fixed when the cell formula is copied to a new location. (EX 133) |
| approximate match lookup | A lookup where the lookup value falls within a range of numbers in the compare values in the lookup table. (EX 176) |
| argument | The numbers, text, or cell references used by the function to return a value. (EX 133) |
| AutoFill | A feature that copies content (text, values, or formulas) and formats from a cell or range into an adjacent cell or range. (EX 162) |
| compare values | The categories used for matching to a specified lookup value in a lookup table. (EX 160) |
| comparison operator | A symbol that indicates the relationship between two values. (EX 172) |
| constant | A value in a formula that doesn’t change. (EX 135) |
| COUNT function | The Excel function that tallies how many cells in specified range contain numbers or dates. (EX 161) |
| COUNTA function | A function that tallies how many cells in specified range are not blank (contain numbers, dates, or text). (EX 161) |
| date function | A function that inserts or calculates dates and times. (EX 166) |
| error value | A message in a cell that indicates some part of a formula is preventing Excel from returning a calculated value. (EX 150) |
| exact match lookup | A lookup where the lookup value must match one of the compare values in the lookup table. (EX 176) |
| fill handle | A small black square in the lower-right corner of a selected cell or range that you drag over an adjacent cell or range to copy the original content and formatting into the selected range. (EX 162) |
| Goal Seek | A feature that automates the trial-and-error method by allowing you to specify a value for the calculated item, which Excel uses to determine the input value needed to reach that goal. (EX 180) |
| IF function | A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false. (EX 161) |
| logical function | A function that works with statements that are either true or false. (EX 161) |
| lookup function | A function that finds a value in a table of data and inserts it in another location in the worksheet, such as a cell or in a formula. (EX 176) |
| lookup table | A table that stores the data you want to retrieve with a lookup function in categories. (EX 160) |
| lookup value | The category you want to find in a lookup table. (EX 160) |
| MAX function | A function that displays the maximum value in a range. (EX 132) |
| Median function | A function that determines the middle value in a range. (EX 132) |
| median | The middle value in data. (EX 145) |
| MIN function | A function that displays the minimum value in the range. (EX 132) |
| mixed reference | A cell reference that contains both relative and absolute references; for example, the mixed reference for cell D2 can have an absolute row (such as $D6) or an absolute column (such as D$6). (EX 154) |
| nest | To place one thing inside another, such as a function inside another function. (EX 142) |
| optional argument | An argument that is not required for the function to return a value. (EX 133) |
| relative reference | A cell reference that is interpreted in relation to the location of the cell containing the formula. (EX 133) |
| required argument | An argument that is needed for the function to return a value. (EX133) |
| return values | The data values you want to retrieve from a lookup table. (EX 160) |
| significant digits | The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values. (EX 140) |
| TODAY function | A date function that displays the current date. (EX 167) |
| trial-and-error method | A way to perform what-if analysis by changing one or more of the input values to a value you estimate to see how it impacts the calculated results. (EX 179) |
| what-if analysis | A way to explore the impact that changing input values has on the calculated values in a workbook. (EX 179) |
| WORKDAY function | A function that displays the date of a weekday that is specified number of weekdays past a starting date. (EX 161) |
| VLOOKUP function | A function that returns values from a vertical lookup table. (EX 160) |
| 100% stacked column chart | A column chart that places the data series values within combined columns showing what percentage is contributed by each series. (EX 212) |
| axis title | Descriptive text that appears next to an axis. (EX 219) |
| bar chart | A column chart turned on its side so that the length of each bar is proportional to its value. (EX 211) |
| category values | The groups or categories that a series values belong to. (EX 190) |
| chart | A visual representation of a set of data values; also called a graph. (EX 190) |
| chart animation | A slowed down effect of changing data source values, making it easier to see how changing one value affects the chart. (EX 210) |
| chart area | The chart and all of the other chart elements. (EX 190) |
| chart element | An individual part of a chart, such as the title or the legend. (EX 191) |
| chart subtype | A variation of a chart type. (EX 199) |
| chart title | A descriptive label or name for the chart area. (EX 191) |
| clustered column chart | A column chart that displays the data values in separate columns side-by-side. (EX 212) |
| column chart | A chart that displays data values as columns with the height of each column proportional to its value. (EX 211 |
| combination chart | A chart that combines two or more Excel chart types into a single graph. (EX 219) |
| data bar | A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell’s value. (EX 218) |
| data callout | A data label that appears as a callout bubble pointing to a data marker. (EX 219) |
| data label | Text associated with an individual data marker. (EX 190) |
| data marker | A graphical representation of a value in a chart, such as a column or pie slice. (EX 191) |
| data series | The range that contains the values plotted on a chart. (EX 190) |
| data source | The range that contains the data displayed in a chart. (EX 190) |
| embedded chart | A chart object placed in a worksheet. (EX 190) |
| exploded pie chart | A pie chart that moves one slice away from the others as if someone were taking the piece away from the pie. (EX 209) |
| filter | The process of limiting data to a subset of the original values. (EX 210) |
| Format pane | An area that provides a collection of commands to format the selected chart element. (EX 191) |
| graph | A visual representation of a set of data values; also called a chart. (EX 190) |
| gridline | A line that extends the value of a major or minor tick mark across the plot area of a chart. (EX 219) |
| grouped sparklines | A set of sparklines that share a common format. (EX 219) |
| horizontal axis (category axis) | The axis that displays the category values from each data series. (EX 191) |
| interest | The amount added to the principal by the lender. (EX 192) |
| leader line | A line that connects a data label to its corresponding data marker. (EX 207) |
| line chart | A chart that displays data values using a connected line rather than columns or bars. (EX 219) |
| major tick marks | Lines that identify the main units on a chart axis. (EX 222) |
| minor tick marks | Lines that identify the smaller intervals between major tick marks on a chart axis. (EX 222) |
| pie chart | A chart in the shape of a circle divided into slices like a pie that show data values as a percentage of the whole. (EX 200) |
| plot area | The part of a chart that contains the graphical representation of the data series. (EX 219) |
| PMT function | The financial function that calculates the payment schedule required to repay a loan. (EX 192) |
| primary axis | The axis against which data series in a chart is plotted; usually appears along the left side of a chart. (EX 222) |
| principal | The amount of money being loaned. (EX 192) |
| scale | The range of values displayed on a chart axis. (EX 222) |
| secondary axis | An alternate axis in a chart against which other data series with a different scale is plotted; usually appears on the right side of a chart. (EX 222) |
| selection box | A box surrounding an object such as a chart that is used to move or resize the object. (EX 202) |
| sizing handle | A square or dot on the edge of a selection box that is used to change the object’s width and height. (EX 202) |
| sparkline | A chart that is displayed entirely within a worksheet cell. (EX 218 |
| stacked column chart | A column chart that places the data series values within combined columns showing how much is contributed by each series. (EX 212) |
| tick mark | A line that identifies the units at regular intervals on a chart axis. (EX 222) |
| ungrouped sparklines | A set of sparklines that can be formatted individually. (EX 219) |
| vertical axis (value, axis) | The axis that displays the series values from the data series. (EX 190) |
| watermark | Text or an image that appears in the background of each page behind other content. (EX 245) |
| XY scatter chart | A chart that shows the pattern or relationship between two or more sets of values. (EX 237) |
| ascending order | The arrangement of text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest. (EX 271) |
| Category field | A field that groups the values in a PivotTable; appears in a PivotTable as a row label, a column label, and a report filter. (EX 299) |
| clear | To remove, such as a filter. (EX 281) |
| criteria filter | Conditions you specify for a filter. (EX 282) |
| column header | A unique label that describes the contents of the data in a column; also called a field name. (EX 259) |
| custom list | The sequence you specify to sort data. (EX 274) |
| data definition table | Documentation that lists the fields to be maintained for each record, a description of the information each field will include, and the type of data stored in each field. (EX 261) |
| descending order | The arrangement of text in reverse alphabetical order from Z to A, numbers from largest to smallest, and dates from newest to oldest. (EX 271) |
| Excel table | A range of related data that is managed independently from other data in the worksheet. (EX 259) |
| field | A single piece of data that describes a characteristic of a person, place, or thing (such as a last name, a city, or a project); each column in an Excel table or structured range of data represents a field. (EX 259) |
| field name | A unique label that describes the contents of the data in a column; also called a column header. (EX 259) |
| filter | The process of displaying a subset of rows in an Excel table or structured range of data that meets the specified criteria. (EX 276) |
| freeze | The process of keeping rows and/or columns you select visible as you scroll the worksheet. (EX 262) |
| header row | The first row of the range or Excel table that contains field names. (EX 258) |
| pane | A section of a window; In Excel, you can split the worksheet window into two or four resizable panes. (EX 277) |
| PivotChart | A graphical representation of the data in a PivotTable. (EX 298) |
| PivotTable | An interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for reporting and analysis. (EX 298) |
| primary sort field | The first sort field. (EX 272) |
| record | A group of related fields; each row in an Excel table or structured range of data represents a record. (EX 258) |
| refresh | To update. (EX 312) |
| secondary sort field | The second sort field. (EX 272) |
| slicer | An object used to filter an Excel table, a PivotTable, or a PivotChart. (EX 277) |
| sort | The process of rearranging data such as the records in an Excel table or range based on one or more fields; data can be sorted in ascending or descending order. (EX 258) |
| sort field | A field that you use to order data. (EX 258) |
| split bar | A moveable bar that indicates the division between panes and that can be dragged to resize the panes. (EX 277) |
| Table style | A preset style used to quickly format an entire table. (EX 259) |
| Total row | A row at the end of an Excel table that is used to calculate summary statistics (such as sum, average, count, maximum, and minimum) for each column in the Excel table. (EX 276) |
| Value field | A field that contains summary data in a PivotTable. (EX 298) |
| 3-D reference | A reference to the same cell or range in multiple worksheets in the same workbook. (EX 329) |
| worksheet group | A collection of two or more selected worksheets. (EX 328) |
| comment | A text box that is attached to a specific cell in a worksheet in which you can enter notes. (EX 411) |
| data validation | A set of rules that determine what users can enter in a specific cell or range. (EX 410) |
| defined name (range name) | A word or string of characters assigned to a cell or range. (EX 391) |
| error alert | A message that appears if a user tries to enter a value in a cell that does not meet the validation rule. (EX 411) |
| Excel application | A spreadsheet written or tailored to meet specific needs; typically includes reports and charts, a data entry area, a custom interface, as well as instructions and documentation. (EX 390) |
| input message | A message that appears when the cell becomes active; can be used to specify the type of data the user should enter in that cell. (EX 410) |
| locked property | A setting that determines whether changes can be made to a cell. (EX 422) |
| validation criteria | The type of data as well as a list or range of acceptable values specified for a validation rule. (EX 412) |
| validation rule | A statement that defines criteria for the data that can be entered and stored in a cell or range. (EX 412) |
| WordArt | A text box in which you can enter stylized text (EX 392) |
| workbook protection | A setting that limits users’ ability to make changes to the workbook’s structure and windows. (EX 411) |
| worksheet protection | A setting that limits users’ ability to modify the worksheet’s contents, structure, or formatting. (EX 411) |
Created by:
hdgrizzly