CPT 101 Final Exam

Ace your homework & exams now with Quizwiz!

Template

A preformatted document that you can use as a starting point and then change to suit your needs.

cover letter

a document that you send with your resume to provide additional information about your skills and experience

template

a file with a predefined document structure and defined settings, such as fonts, margins, and available styles

row

a horizontal group of cells

Thumbnail

a miniature image

creative commas

a nonprofit organization that enables use of images.

pane

a portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars.

function

a prewritten formula that looks at one or more values, performs an operation, and then returns a value.

dot leader

a series of dots that display between columns of a list

Theme

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

clip

a single media file such as art, sound, animation, or a movie

fill handle

a small square in the lower right corner of a selected cell

Median function

a statistical function that describes a group of data; it finds the middle value that has as many values above it in the group as are below it.

Column

a vertical group of cells in a worksheet

summary sheet

a worksheet where totals from other worksheets are displayed and summarized.

Average function

adds a group of values, and then divides the result by the number of values in the group.

Right alignment

aligned at the right margin with an uneven left margin

Table

an arrangement of information organized into rows and columns

Slide transitions

are the motion effects that occur in Slide Show view when you move from one slide to the next during a presentation

One-click Row/Column Insertion

button on the left edge or top of a table can be used to easily and quickly insert a row or column in a table.

Center alignment

centered between the left and right margins

freeze panes

command enables you to select one or more rows or columns and then freeze or lock them into place

leader character

creates a solid, dotted, or dashed line that fills the space to the left of a tab character and draws the reader's eyes across the page from one item to the next.

Smart guides

dashed lines that display on your slide when you are moving an object to assist you with alignment

row heading

designated by a unique number

Slide pane

displays a larger image of the active slide

Reading View

displays a presentation in a manner similar to a slide show but the taskbar, title bar, and status bar remain available in the presentation window

Rotation handles

displays at the top

Black slide

displays indicating that the show is over.

Outline view

displays the presentation outline to the left of the Slide pane and can be used to easily edit presentation text

Chart elements

enables you to add, remove, or change chart elements such as the title, legend, gridlines, and data labels.

Chart filters

enables you to change which data displays in the chart.

Office presentation service

enables you to present your Word document to others who can watch in a web browser

Chart styles

enables you to set a style or color scheme for your chart.

Picture effects

enhance a picture with effects such as a shadow, glow, reflection, or 3-D rotation.

worksheet/spreadsheet

formatted as a pattern of uniformly spaced horizontal rows and vertical columns

Auto Fill

generates and extends a series of values into adjacent cells based on the value of other cells.

SmartArt

graphics are designer-quality visual representations of information

Sheet tabs

identify each worksheet in a workbook and display along the lower left edge of the workbook window.

Picture styles

include shapes, shadows, frames, borders, and other special effects

Split button

inserts a slide automatically from the top half of the button and opens the Layout gallery from the lower half of the button

comma style

inserts a thousand comma separator where appropriate and applies two decimal places.

Embed code

is a code that creates a link to a video, picture, or other type of rich media content

Text box

is a movable, resizable container for text or graphics.

Section header

is a slide layout that looks slightly different than most other slides in a presentation with the intent of signaling a slight change of theme or topic

Merge and center

joins selected cells into one larger cell and centers the contents in the merged cell.

List levels

list levels are identified by the bullet style, indentation, and the size of the text

tab stops

mark specific locations on a line of text.

First Line Indent

marker on the ruler indicates the indent location in the document

Graphics

pictures, online pictures, charts, and drawing objects (shapes, diagrams, lines, etc.)—add visual interest to a document.

Flash fill

recognizes a pattern in your data, and then automatically fills in values when you enter examples of the output that you want

Absolute cell reference

refers to a cell by its fixed position in the worksheet.

Relative cell refrence

refers to a cell by its position relative to the cell that contains the formula

formatting

refers to changing the appearance of the text, layout, and design of a slide.

Rich media/Interactive media

refers to computer interaction that responds to your actions; for example, by presenting text, graphics, animation, video, audio, or games.

Text alignment

refers to the horizontal placement of text within a placeholder

Presenter View

shows the full-screen slide show on one monitor or projection screen for the audience to see, while enabling the presenter to view a preview of the next slide, notes, and a timer on another monitor.

Slides

similar to a page in a document that contains text, pictures, tables, charts, or other multimedia or graphic objects.

Contiguous

slides that are adjacent to each other in a presentation

Noncontiguous slide

slides that are not adjacent to each other in a presentation.

Sizing handles

small circles that indicate that it is selected and can be edited or moved

Justified alignment

text aligned evenly at both the left and right margins

workbook

the Excel document that stores your data

Layout

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

Line spacing

the distance between lines of text in a paragraph

fill color

the inside color of text or of an object

cell reference

the intersection column letter and row number.

letterhead

the personal or company information that displays at the top of a letter, and which commonly includes a name, address, and contact information.

Alignment

the placement of paragraph text relative to the left and right margins

Margins

the space between the text and the top, bottom, left, and right edge of the paper.

Sparklines

tiny charts embedded in a cell that give a visual trend summary alongside your data.

Range

two or more cells on a worksheet that are adjacent or nonadjacent

detail sheets

uses formulas constructed from other sheets in the workbook

variant

variations on the theme style and color

normal template

which serves as a starting point for all blank Word documents

Placeholder

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

Style

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

cell style

a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Tags

A document property that help identify a file

Formula

An equation that performs mathematical calculations on values in your worksheet

Layout options

Can be changed to control the manner in which text wraps around an object

rotation handle

Can be used to rotate the object to any angle.

underlying value

Data that displays in the Formula Bar

Operators

Symbols with which you can specify the type of calculation you want to perform in a formula.

Cell

The intersection of a row and a column in a table

Inline object

The picture is positioned directly in the text at the insertion point.


Related study sets

ENVS 1126 Practice exam 2 + questions from slides

View Set

Consent with Subjects Who Do Not Speak English

View Set