excel
select all box
a box in the upper left corner of the worksheet grid that selects all the cells in a worksheet
line chart
a chart that displays trends over time
freeze panes
a command that enables you to select one or more rows or columns and lock them in place
quick analysis tool
a feature that displays in the lower right corner of a selected range with which you can analyze your data by using excel tools such as charts, color-coding, and formulas
range finder
a feature that outlines cells in color to indicate which cells are used in a formula
conditional format
a format that changes the appearance of a cell based on a condition
if function
a 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
logical functions
a group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false
row
a horizontal group of cells in a worksheet
SUM function
a predefined formula that adds all the numbers in a selected range
function
a predefined formula that performs calculations by using specific values in a particular order or structure
table
a series of rows and columns that contains related data and that is managed independently from other data
data bar
a shaded bar that provides a visual cue about the value of a cell relative to other cells
countif function
a statistical function that counts the number of cells within a range that meet the given condition and which has two arguments - the range of cells to check and the criteria
point
a value that originates in a worksheet cell and that is represented in a chart by a data marker
column
a vertical group of cells in a worksheet
summary sheet
a worksheet where totals from other worksheets are displayed and summarized
formula bar
an element in the excel window that displays the value or formula contained in the active cell
name box
an element of the excel window that displays the name of the selected cell, table, chart, or object
formula
an equation that performs mathematical calculations on values in a worksheet
average function
an excel feature that adds a group of values and then divides the result by the number of values in the group
autofit
an excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column
workbook
an excel file that contains one or more worksheets
max function
an excel function that determines the largest value in a range
min function
an excel function that determines the smallest value in a range
median function
an excel function that finds the middle value that has as many values above it in the group as are below it
value
another name for a constant value
spreadsheet
another name for a worksheet
cell address
another name for cell reference
logical test
any value or expression that can be evaluated as being true or false
cell content
anything typed into a cell
criteria
conditions that you specify in a logical function
statistical functions
excel functions , such as average, that are useful to analyze a group of measurements
constant value
numbers, text, dates, or times of day that you type into a cell
data series
related data points represented by data markers
comparison operator
symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria
data
text or numbers in a cell
paste
the action of placing cell contents that have been copied or moved to the clipboard into another location
explode
the action of pulling out a pie slice from a pie chart for emphasis
category axis
the area along the bottom of a chart that identifies the categories of data
plot area
the area bounded by the axes of a chart, including all the data series
underlying value
the data that displays in the formula bar
general format
the default format that excel applies to numbers
print titles
the excel command that enables you to specify rows and columns to repeat on each printed page
flash fill
the excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output
auto fill
the excel feature that generates and extends values into adjacent cells based on the values of selected cells
now function
the function that retrieves and then displays the date and time from your computer
chart
the graphic representation of data in a worksheet
cell
the intersection of a column and a row
sheet tabs
the labels along the lower border of the excel window that identify each worksheet
sorting
the process of arranging data in a specific order based on the value in each field
filtering
the process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify
navigate
the process of moving within a worksheet or workbook
fill handle
the small black square in the lower right corner of a selected cell
operators
the symbols with which you can specify the type of calculation you want to perform in an excel formula
volatile
the term used to describe an excel function that is subject to change each time the workbook is opened
absolute
the type of cell referee that refers to cells by their fixed position in a worksheet
major unit
the value in a chart's value axis that determines the spacing between tick marks and between gridlines in the plot area
arguments
the value that an excel function uses to perform calculations or operations
detail sheets
the worksheets that contain the details of the information summarized on a summary sheet
sparklines
tiny charts embedded in a cell that gives a visual trend summary alongside your data