Go! 15/16
data marker
column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series
freeze panes
command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes
merge & center
command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell
autofit
Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column
auto fill
Excel feature that generates and extends values into adjacent cells based on the values of selected cells
workbook
Excel file that contains one or more worksheets
average function
Excel function that adds a group of values, and then divides the result by the number of values in the group
max function
Excel function that determines the largest value in a selected range of values
min function
Excel function that determines the smallest value in a selected range of values
median function
Excel function that finds the middle value that has as many values above it in the group as are below it
function
a formula that Excel has already built for you that performs calculations by using specific values in a particular order or structure
logical test
any value or expression that can be evaluated as being true or false
autosum
button that provides quick access to the SUM function
absolute cell reference
cell reference that refers to cells by their fixed position in a worksheet
legend
chart element that identifies the patterns or colors that are assigned to the categories in the chart
formula
equation that performs mathematical calculations on values in a worksheet
if function
function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false
chart
graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers
x-axis
horizontal (category) axis
row
horizontal group of cells in a worksheet
cell
intersection of a column and a row
sum function
predefined formula that adds all the numbers in a selected range of cells
worksheet
primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines
sort
process of arranging data in a specific order based on the value in each field
what-if analysis
process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
scaling
process of shrinking the width and/or height of printed output to fit a maximum number of pages
data series
related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.
data point
value that originates in a worksheet cell and that is represented in a chart by a data marker
y-axis
vertical (value) axis