excel terms 4-8
Terms in this set (50)
Absolute cell reference:
Does not change when copied or moved to a new cell.
The equation used to calculate values in a cell
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.
Allows you to point and click each cell in a formula rather than typing
Relative cell reference
Adjusts to its new location when copied or moved
Makes adding long columns or rows of numbers simple to do
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.
Highlights worksheet data by changing the look of cells that meet a
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
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.
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
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
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.
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
The entire chart and all other chart elements.
Specifies which elements are included in a chart and where they are placed
separate sheet in the workbook that stores a chart.
Formats the chart based on the colors, fonts, and effects associated with the
Chart that uses bars of varying heights to illustrate values in a worksheet.
Text or numbers that provide additional information about a data marker.
A symbol that represents a single data point or value from the corresponding
A group of related information in a column or row of a worksheet that is plotted on
A grid that displays the data plotted in the 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
A list that identifies patterns, symbols, or colors used in a chart
Chart that is similar to a column chart, but where columns are replaced by points
connected by a line
Chart that shows the relationship of a part to a whole
graphical representation of all of the data series
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
Mini charts that you can insert into a cell.