PowerPoint and Excel - Spring Final - Bus. Tech.

Rate

= amount of increase/base

Percent for new value

= base percent + percent of increase

Slide pane

A PowerPoint screen element that displays a large image of the active slide.

Outline View

A PowerPoint view that displays the presentation outline to the left of the Slide pane

Placeholder

A box on a slide with dotted or dashed borders that holds title and body text or other content such as charts, tables, and pictures.

Absolute Cell Reference

A cell reference that refers to cells by their fixed position in a worksheet

Legend

A chart element that identifies the patterns or colors that are assigned to the categories in the chart.

Pie chart

A chart that shows the relationship of each part to a whole

Line chart

A chart type that displays trends over time

Rotation handle

A circular arrow that provides a way to rotate a selected image

Style

A collection of formatting options that you can apply to a picture, text, or an object

Data marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.

Axis

A line that serves as a frame of reference for measurement and which borders the chart plot area.

Value axis

A numerical scale on the left side of a chart that shows the range of numbers for the data points. Y-axis.

Slide

A presentation page that can contain text, pictures, tables, charts, and other multimedia or graphic objects.

Slide Sorter view

A presentation view that displays thumbnails of all of the slides in a presentation.

Notes page

A printout that contains the slide image on the top half of the page and notes that you have created on the Notes pane in the lower half of the page.

Theme

A set of unified design elements that provides a look for your presentation by applying colors, fonts, and effects.

Bevel

A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled

Title slide

A slide layout that provides an introduction to the presentation topic

Black slide

A slide that displays after the last slide in a presentation indicating that the presentation is over.

Split button

A type of button in which clicking the main part of the button performs a command and clicking the arrow opens a menu, list or gallery

Section header

A type of slide layout that changes the look and flow of a presentation by providing text placeholders that do not contain bullet points.

Data point

A value that originates in a worksheet cell and that is represented by data markers

Variant

A variation on the presentation theme style and color.

Reading view

A view in PowerPoint that displays a presentation in a manner similar to a slide show but in which the taskbar, title bar, and status bar remain available in the presentation window.

Goal seek

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell

Formula AutoComplete

An Excel feature which, after typing an = and the beginning letter of a function name

Notes pane

An area of the Normal view window that displays below the slide pane with space to type notes regarding the active slide

List level

An outline level in a presentation represented by a bullet symbol and identified in a slide by the indentation and the size of the text

y-axis

Another name for the value axis. Vertical axis.

x-axis

Category axis. Horizontal axis

Artistic Effects

Formats applied to images that make pictures resemble sketches or paintings

Relative cell reference

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to

Thumbnails

Miniature images of presentation slides

Slide transitions

Motion effects that occur in slide show view when you move from one slide to the next during a presentation

Order of Operations

PEMDAS

Slide handout

Printed images of slides on a sheet of paper

Contiguous slides

Slides that are adjacent to each other in a presentation

Noncontiguous slides

Slides that are not adjacent to each other in a presentation

Sizing handles

Small squares surrounding a picture that indicate that the picture is selected.

Footer

Text that displays at the bottom of every slide or that prints at the bottom of a sheet of slide handouts or notes pages

Header

Text that prints at the top of each sheet of slide handouts or notes pages

Explode

The action of pulling out one or more pie slices from a pie chart or emphasis

Collaboration

The action of working with others as a team in an intellectual endeavor to complete a shared task

Category Axis

The area along the bottom of a chart that identifies the categories of data. The x-axis

Plot area

The area bounded by the axes of a chart, including all the data series

Layout

The arrangement of elements, such as title and subtitle text, lists, pictures, tables, charts, shapes, and movies, on a slide.

Chart area

The entire chart and all of its elements

Text alignment

The horizontal placement of text within a placeholder

Percentage rate of increase

The percent by which one number increases over another number

Normal view

The primary editing view in PowerPoint where you write and design your presentations

Formatting

The process of changing the appearance of the text, layout, and design of a slide

What if analysis

The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet

Editing

The process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides

Aspect ratio

The ratio of the width of a display to the height of the display

Base

The starting point when you divide the amount of increase by it to calculate the rate of increase.

Major unit

The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area.