HIM computer essentials/Excel Study guide

insertion point

A blinking vertical line that indicates where the next character typed character will appear

Names a cell

A cell address or cell reference

Workbook

A file containing related worksheets

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.

A header

Content that appears on the top of each printed page.

Chart

Conveys a visual representation of data

Planning Structure of Worksheets

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

Left-Aligned

Excel automatically positions text

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

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

AutoSum

Function adds all of the numbers in a range of cells

Chart elements

Objects that make up a chart.

Chart area

The entire chart and all its elements.

cell

The intersection of a row and a column

Right-Align

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

embedded

a chart ----when it is drawn on the same worksheet as the data

Theme template

a collection of cell styles and other styles that have common characteristics

WordArt

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

Excel Functions

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 operations, 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

Auto Fill

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

Category Axis

horizontal axis of a chart is called the x-axis or this:

Range

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

Text

is used to place titles on a worksheet

Copying Worksheets

makes a duplicate sheet at the new location

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

Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

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

Format Menu

presents sheet commands

Add "!"

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

source area

the cell being copied

F9 key

to redraw a chart when you change data you can press the:

active

to select a cell is to make it:

Paste Special command

used to paste data from the clipboard using a different format

lie vertically

worksheet columns

lie horizontally

worksheet rows

black border

you know a cell is selected when a ---surrounds the cell