# Shared Flashcard Set

Excel
Chapter 1
86
Education
12/15/2014

## Additional Education Flashcards

Term
 Workbook
Definition
 A file containing related worksheets
Term
 Worksheet
Definition
 A spreadsheet that contains formuals, values, text, and visual aids
Term
 Input Area
Definition
 A range of cells containing values for variables used in formulas
Term
 Output Area
Definition
 A range of cells containing results based on manipulating the variables
Term
 Name box
Definition
 Identifies the address of the current cell
Term
 Formula Bar
Definition
 Displays the content (text, value, date, or formula) in the active cell.
Term
 Sheet Tab
Definition
 Displays the name of a worksheet within a workbook
Term
 Cell
Definition
 The intersection of a column and row
Term
 Text
Definition
 Includes letters, numbers, symbols, and spaces
Term
 Value
Definition
 A number that represents a quantity or an amount
Term
 Order of precedence
Definition
 Rules that control the sequence in which excel performs arithmetic operations
Term
 Autofill
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
 Fill handle
Definition
 A small green square at the bottom-right corner of a cell
Term
 Column Width
Definition
 The horizontal measurement of a column
Term
 Row height
Definition
 The vertical measurement of a row
Term
 Range
Definition
 A rectangular group of cells
Term
 Alignment
Definition
 The position of data between the cell margins
Term
 Wrap Text
Definition
 Formatting that enables a label to appear on multiple lines within the current cell
Term
 Fill color
Definition
 The background color appearing behind data in a cell
Term
 Formula
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
 Name box
Term
 Why would you press Ctrl + ` in Excel?
Definition
 To display cell formulas
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
 Clustered Column Chart
Definition
 Chart type to compare multiple categories of data vertically.
Term
 Sparkline
Definition
 Miniature chart contained in a single cell
Term
 Line Chart
Definition
 Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time.
Term
 Chart Title
Definition
 Label that describes the chart
Term
 Axis Title
Definition
 Label that describes either the category axis or the value axis
Term
 Legend
Definition
 Key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
Term
 Bar Chart
Definition
 Chart type that compares categories of data horizontally
Term
 Pie Chart
Definition
 Chart that shows each data point in proportion to the whole data series
Term
 Data Point
Definition
 Numeric value that describes a single value on a chart
Term
 Stock Chart
Definition
 Chart that shows the high, low, and close prices for individual stocks over time
Term
 Sizing Handle
Definition
 Indicators that enable you to adjust the height and width of a selected chart
Term
 Gridline
Definition
 Horizontal or vertical line that extends from the horizontal or vertical axis through the plot area
Term
 X Y (scatter) Chart
Definition
 Chart type that shows the relationship between two variables
Term
 Data Series
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
 Category Axis
Definition
 Provides descriptive group names for subdividing a data series
Term
 Plot Area
Definition
 Section of a chart that contains graphical representation of the values in a data series
Term
 Chart Area
Definition
 Boundary that contains the entire chart and all of its elements, including the plot area, titles, legends, and labels
Term
 Data Label
Definition
 Descriptive label that shows the exact value of the data points on the value axis.
Term
 Value Axis
Definition
 Displays incremental numbers to identify approx. values, such as dollars or units, of data points in a chart
Term
 Layout
Definition
 Defines containers, positioning, and formatting for all of the content that appears on a slide
Term
 Normal View
Definition
 The default PowerPoint view, containing two panes that provide maximum flexibility in working with the presentation
Term
 Placeholder
Definition
 A container that holds content
Term
 Animation
Definition
 The movement applied to an object or objects on a slide
Term
 Slide
Definition
 The most basic element of PowerPoint, analogous to a page in a word doc.
Term
 Annotation
Definition
 A note or drawing added to a slide during a presentation
Term
 Status Bar
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
 PowerPoint Presentation
Definition
 A presentation saved with a .ppTx extension
Term
 Slide Show
Definition
 A method to deliver your message in a variety of ways using multiple slides.
Term
 Notes Page View
Definition
 Used if the speaker needs to enter and edit large amounts of text for references in the presentation
Term
 PowerPoint Show
Definition
 Uses a .ppSx extension
Term
 Presenter view
Definition
 A specialty view that delivers a presentation on two monitors simultaneously
Term
 Variant
Definition
 A variation of the theme you have chosen, using different color palettes and font families
Term
 Slide show view
Definition
 Used to deliver a completed presentation full screen to an audience, one slide at a time.
Term
 Thumbnail
Definition
 A slide miniature
Term
 Transition
Definition
 A specific animation that is applied when a previous slide is replaced by a new slide.
Term
 Slide Sorter View
Definition
 Displays thumbnails of your presentation slides, allowing you to view multiple slides simultaneously
Term
 Storyboard
Definition
 A visual design that helps you plan the direction of your presentation slides
Term
 Theme
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
 F1
Term
 What is the name for PowerPoint's predefined slide arrangements?
Definition
 Slide Layouts
Term
 What is the term for a variation of the theme using different color palettes and font families?
Definition
 Varient
Term
 When making a presentation that includes a large detailed table, which print method should you use?
Definition
 Full page slide
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
 Slide Sorter View
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
 Transition
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
 Goal
Term
 A title slide should include how many words?
Definition
 A min. of 2-5 words
Term
 How do you choose a layout?
Definition
 The new slides on the home tab
Term
 To create a chart in Excel?
Definition
 Quick Analysis
Term
 To start the slide show?
Definition
 f5
Term
 When delivering a slide show presentation, enhance the slides to next slide by pushing?
Definition
 Spacebar
Term
 Zoom bar is located?
Definition
 On the status bar
Term
 In 2013 for help, use?
Definition
 F1
Term
 Font sizes are measured in?
Definition
 Points
Term
 Undo shortcut?
Definition
 Ctrl + Z
Supporting users have an ad free experience!