Terms in this set (42)
Must start every formula
cell you are working in; outlined in black
labels will align on the left and values will align on the right
Intersection of a row and a column and identified by a cell reference.
Cell address or reference
Letter and number that identify a cell's location, Example: B12
Begin with letters; are vertical (up and down)
Displays the formula in the current cell
A group of adjacent cells that forms a rectangle in a worksheet
Identifies the location of the selected range of cells (i.e.--A1:D1)
Start with numbers; are horizontal (across)
A program that allows you to use rows and columns of data to manage, predict, and present information.
Displays the name of the workbook; ie--"Book1."
A number entered into a spreadsheet cell that will be used for calculations.
Area where you enter and work with data.
Sheet tabs or Worksheet tabs
Bottom of the file; used to move from one worksheet to another.
Absolute Cell Reference
a cell reference used in formulas that REMAINS CONSTANT when copied to a new location i.e. $B$4
the function used to find the total of a range of cells
the values (enclosed within parentheses) in a function used to perform operations
small black dot located in the lower right corner of the heavy border around the active cell
shortcut used to copy formulas to new locations
function used to find the average of a range of cells
EQUATIONs used to solve calculations
function used to find the highest value in a range of cells
order of operations
the SEQUENCE in which the computer solves an equation (i.e.-- Please Excuse My Dear Aunt Sally)
symbol that indicates a RANGE found between two cell references i.e. A2:B4
function used to find the lowest value in a range of cells
the built-in formulas that do not require operators to calculate a result
symbol used to indicate an absolute cell reference
function used to count the entries in a range of cells (i.e.--the number of students who turned in a research paper)
feature of spreadsheets and databases that will place data into a specific order
arrange the order of data alphabetically
arrange the order of data by date
xls or xlsx
file extension for Excel documents
chart to show progress over time
chart to show parts to whole
chart to compare sets of quantities