Microsoft Excel

Chart

A ____ conveys a visual representation of data.

Theme/Template

A ____ is a collection of cell styles and other styles that have common characteristics.

Range

A ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

Embedded

A chart is ____ when it is drawn on the same worksheet as the data.

WordArt

A feature that transforms text into a stylized image that you can use to create a distinctive logo or heading.

equal sign =

A formula begins with

Trendline

A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.

Chart sheet

A separate worksheet used to display an entire chart.

Column chart

A type of chart that shows comparisons among related data.

Left-Aligned

Excel automatically positions text ____ in a cell

Absolute ($A$1), Relative (A1), Mixed ($A1 or A$1)

Excel offers three types of cell references for use when a formula is copied

Chart elements

Objects that make up a chart.

Parentheses, Exponentiation, Multiplication and Division, Addition and Subtraction

Order of precedence (operations) controls the sequence in which math operators are computed

Enter the labels, values, and formulas; Format the numerical values, Format the descriptive titles and labels, Document the worksheet, Save the completed workbook

Planning Structure of Worksheets

AutoSum

The ____ function adds all of the numbers in a range of cells.

source area

The cell being copied is called the

Chart area

The entire chart and all its elements.

Category Axis

The horizontal axis for a chart is called the x-axis, or this

F9 key

To redraw a chart when you change data, you can press the

active

To select a cell is to make it

Insertion Point

What is a vertical blinking line that indicates where the next typed character will appear?

Right-Aligned

When you type numeric data in a cell, Excel automatically positions the entry ____ in a cell.

Black Border

You know a cell is selected when a ____ surrounds the cell.

Text

____is used to place titles on a worksheet.

workbook

a file containing related worksheets

Excel function

a predefined formula that performs a calculation

range

a rectangular group of cells

worksheet

a spreadsheet that contains formulas, values, text, and visual aids

Formatting

accentuates and draws attention to meaningful portions of a worksheet

Spreadsheet

an electronic file used to organize related data and perform calculations

Moving a worksheet

changes its order among sheet tabs

Formulas

combinations of cell addresses, math operators, values and/or functions

A nonadjacent range

contains a group of ranges that are not next to each other

Page Setup Dialog Box Launcher

contains many common print-related options

A footer

content appearing at the bottom of each printed page

A header

content appearing at the top of each printed page

Auto fill

enables you to copy the contents of a cell or cell range or to continue a series using the fill handle

Worksheet rows

lie horizontally

Worksheet columns

lie vertically

Copying a worksheet

makes a duplicate sheet at the new location

A cell address or call reference

names a cell

circular reference

occurs if a formula refers to itself

Insert command

offers several techniques to insert rows, columns, and cells

Delete command

offers several techniques to remove rows, columns, and cells

Format Menu

presents sheet commands

Add "!"

prior to the page name of a formula to indicate the page from which the value is referred

cell

the intersection of a row and column

Paste Special command

used to paste data from the clipboard using a different format