Term
|
Definition
| A file containing related worksheets |
|
|
Term
|
Definition
| A spreadsheet that contains formuals, values, text, and visual aids |
|
|
Term
|
Definition
| A range of cells containing values for variables used in formulas |
|
|
Term
|
Definition
| A range of cells containing results based on manipulating the variables |
|
|
Term
|
Definition
| Identifies the address of the current cell |
|
|
Term
|
Definition
| Displays the content (text, value, date, or formula) in the active cell. |
|
|
Term
|
Definition
| Displays the name of a worksheet within a workbook |
|
|
Term
|
Definition
| The intersection of a column and row |
|
|
Term
|
Definition
| Includes letters, numbers, symbols, and spaces |
|
|
Term
|
Definition
| A number that represents a quantity or an amount |
|
|
Term
|
Definition
| Rules that control the sequence in which excel performs arithmetic operations |
|
|
Term
|
Definition
| Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells |
|
|
Term
|
Definition
| A small green square at the bottom-right corner of a cell |
|
|
Term
|
Definition
| The horizontal measurement of a column |
|
|
Term
|
Definition
| The vertical measurement of a row |
|
|
Term
|
Definition
| A rectangular group of cells |
|
|
Term
|
Definition
| The position of data between the cell margins |
|
|
Term
|
Definition
| Formatting that enables a label to appear on multiple lines within the current cell |
|
|
Term
|
Definition
| The background color appearing behind data in a cell |
|
|
Term
|
Definition
| A combination of cell references, operators, values, and/or functions used to perform a calculation. |
|
|
Term
| What is the first step in planning an effective worksheet? |
|
Definition
| State the purpose of a worksheet |
|
|
Term
| What excel interface item displays the address of the current cell? |
|
Definition
|
|
Term
| Why would you press Ctrl + ` in Excel? |
|
Definition
|
|
Term
| Which of the following is a nonadjacent range? |
|
Definition
| A1:A10, D1:D10 ---(w/comma) |
|
|
Term
| If you want to balance a title over several columns, what do you do? |
|
Definition
| Merge and center the data over all columns |
|
|
Term
| What should you do if you see a column of pound signs (###) instead of values or results of formulas? |
|
Definition
| Increase the column width |
|
|
Term
|
Definition
| Chart type to compare multiple categories of data vertically. |
|
|
Term
|
Definition
| Miniature chart contained in a single cell |
|
|
Term
|
Definition
| Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time. |
|
|
Term
|
Definition
| Label that describes the chart |
|
|
Term
|
Definition
| Label that describes either the category axis or the value axis |
|
|
Term
|
Definition
| Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. |
|
|
Term
|
Definition
| Chart type that compares categories of data horizontally |
|
|
Term
|
Definition
| Chart that shows each data point in proportion to the whole data series |
|
|
Term
|
Definition
| Numeric value that describes a single value on a chart |
|
|
Term
|
Definition
| Chart that shows the high, low, and close prices for individual stocks over time |
|
|
Term
|
Definition
| Indicators that enable you to adjust the height and width of a selected chart |
|
|
Term
|
Definition
| Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area |
|
|
Term
|
Definition
| Chart type that shows the relationship between two variables |
|
|
Term
|
Definition
| Group of related data points that display in row(s) or column(s) in a worksheet |
|
|
Term
|
Definition
| Window of options to format and customize chart elements |
|
|
Term
|
Definition
| Provides descriptive group names for subdividing a data series |
|
|
Term
|
Definition
| Section of a chart that contains graphical representation of the values in a data series |
|
|
Term
|
Definition
| Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels |
|
|
Term
|
Definition
| Descriptive label that shows the exact value of the data points on the value axis. |
|
|
Term
|
Definition
| Displays incremental numbers to identify approx. values, such as dollars or units, of data points in a chart |
|
|
Term
|
Definition
| Defines containers, positioning, and formatting for all of the content that appears on a slide |
|
|
Term
|
Definition
| The default PowerPoint view, containing two panes that provide maximum flexibility in working with the presentation |
|
|
Term
|
Definition
| A container that holds content |
|
|
Term
|
Definition
| The movement applied to an object or objects on a slide |
|
|
Term
|
Definition
| The most basic element of PowerPoint, analogous to a page in a word doc. |
|
|
Term
|
Definition
| A note or drawing added to a slide during a presentation |
|
|
Term
|
Definition
| Located at the bottom of the screen, this contains the slide number, a spell check button, and options that control the view of your presentation |
|
|
Term
|
Definition
| Used to view a slide show full screen, one slide at a time. |
|
|
Term
|
Definition
| A presentation saved with a .ppTx extension |
|
|
Term
|
Definition
| A method to deliver your message in a variety of ways using multiple slides. |
|
|
Term
|
Definition
| Used if the speaker needs to enter and edit large amounts of text for references in the presentation |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A specialty view that delivers a presentation on two monitors simultaneously |
|
|
Term
|
Definition
| A variation of the theme you have chosen, using different color palettes and font families |
|
|
Term
|
Definition
| Used to deliver a completed presentation full screen to an audience, one slide at a time. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A specific animation that is applied when a previous slide is replaced by a new slide. |
|
|
Term
|
Definition
| Displays thumbnails of your presentation slides, allowing you to view multiple slides simultaneously |
|
|
Term
|
Definition
| A visual design that helps you plan the direction of your presentation slides |
|
|
Term
|
Definition
| A collection of formatting choices that include colors, fonts, and special effects |
|
|
Term
| Which of the following will display a list of shortcuts for navigating when presenting a slide show |
|
Definition
|
|
Term
| What is the name for PowerPoint's predefined slide arrangements? |
|
Definition
|
|
Term
| What is the term for a variation of the theme using different color palettes and font families? |
|
Definition
|
|
Term
| When making a presentation that includes a large detailed table, which print method should you use? |
|
Definition
|
|
Term
| Which of the following components are contained in Normal View? |
|
Definition
| Thumbnails pane and Slide pane |
|
|
Term
| What view is the best choice if you want to reorder the slides in a presentation? |
|
Definition
|
|
Term
| Regarding themes, which of the following is a TRUE statement? |
|
Definition
| The theme can be changed after all of the slides have been created |
|
|
Term
| In reference to content development, which of the following points is not in active voice and is not parallel to the others? |
|
Definition
| Storyboards are used to sketch out thoughts |
|
|
Term
| The animation effect that controls how one slide changes to another slide is called? |
|
Definition
|
|
Term
| During a slide show, which of the following would best be used to focus audience attention on a specific object? |
|
Definition
| Use the pen tool to circle the object |
|
|
Term
| The 1st step in planning a Presentation? |
|
Definition
|
|
Term
| A title slide should include how many words? |
|
Definition
|
|
Term
| How do you choose a layout? |
|
Definition
| The new slides on the home tab |
|
|
Term
| To create a chart in Excel? |
|
Definition
|
|
Term
|
Definition
|
|
Term
| When delivering a slide show presentation, enhance the slides to next slide by pushing? |
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Font sizes are measured in? |
|
Definition
|
|
Term
|
Definition
|
|
