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
