50 terms

excel terms 4-8

Absolute cell reference:
Does not change when copied or moved to a new cell.
The equation used to calculate values in a cell
Manual calculation:
Lets you determine when Excel calculates the formulas
Mixed cell reference:
Cell references that contain both relative and absolute references
A constant (text or number) or cell reference used in a formula.
A symbol that indicates the type of calculation to perform on operands
Order of evaluation
The sequence used to calculate the value of a formula.
Point-and-click method
Allows you to point and click each cell in a formula rather than typing
cell references.
Relative cell reference
Adjusts to its new location when copied or moved
Sum button
Makes adding long columns or rows of numbers simple to do
Ascending sort:
Data with letters arranged in alphabetical order (A to Z), data with numbers
arranged from lowest to highest, and data with dates arranged from earliest to latest.
A note attached to a cell that is usually used to explain or identify information
contained in the cell.
Conditional formatting
Highlights worksheet data by changing the look of cells that meet a
specified condition.
Descending sort:
Arranges data with letters from Z to A, data with numbers from highest to
lowest, and data with dates from oldest to newest.
Displays a subset of the data that meets certain criteria and temporarily hides the rows
that do not meet the specified criteria
Filter arrow
Appear in the lower-right corners of the column heading cells and are used to
access the AutoFilter menu for that column.
A cell in a worksheet that opens another file or page when you click it.
Anything that appears on the screen that you can select and work with as a whole
A digital photograph or other image file.
Research task pane
Provides access to information typically found in references such as
dictionaries, thesauruses, and encyclopedias.
Screen clipping
When you take a screenshot, you can include everything visible on your
monitor or a screen clipping, which is the area you choose to include
A picture of all or part of something you see on your monitor, such as a Word
document, an Excel workbook, a photograph, or a Web page.
Shapes, such as rectangles, circles, arrows, lines, flowchart symbols, and callouts, can
help make a worksheet more informative
SmartArt graphic
Enhance worksheets by providing a visual representation of information and
Rearranging the data in a more meaningful order.
A predesigned workbook file that you can use as the basis or model for a new
3-D reference:
A reference to the same cell or range in multiple worksheets that you use in a
The location where the data will appear after it is transferred
The location the data is being transferred from.
Worksheet range
A group of adjacent worksheets
A line that establishes a relationship between data in a chart; most charts have a
horizontal x-axis and a vertical y-axis.
A graphical representation of data
Chart area
The entire chart and all other chart elements.
Chart layout
Specifies which elements are included in a chart and where they are placed
Chart sheet
separate sheet in the workbook that stores a chart.
Chart style
Formats the chart based on the colors, fonts, and effects associated with the
workbook's theme
Column chart
Chart that uses bars of varying heights to illustrate values in a worksheet.
Data label
Text or numbers that provide additional information about a data marker.
Data marker
A symbol that represents a single data point or value from the corresponding
worksheet cell.
Data series
A group of related information in a column or row of a worksheet that is plotted on
the chart.
Data source
Chart data
Data table
A grid that displays the data plotted in the chart
Embedded chart
After you select a chart type and style, the chart is inserted as an embedded
chart in the center of the worksheet
Exploded pie chart
When you pull one or more slices away from the pie in a pie chart to
distinguish them
A list that identifies patterns, symbols, or colors used in a chart
Line chart
Chart that is similar to a column chart, but where columns are replaced by points
connected by a line
Pie chart:
Chart that shows the relationship of a part to a whole
Plot area
graphical representation of all of the data series
Scatter chart:
Chart that shows the relationship between two categories of data. The data
points are not connected by a line because they do not relate to each other the way they do in a
line chart
Mini charts that you can insert into a cell.