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