Search
Create
Log in
Sign up
Log in
Sign up
Spreadsheet Terms
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (42)

Subtract
*
Multiply
/
Divide
+
Add
=
Must start every formula
Active Cell
cell you are working in; outlined in black
Alignment
labels will align on the left and values will align on the right
Cell
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
Column
Begin with letters; are vertical (up and down)
Formula bar
Displays the formula in the current cell
Range
A group of adjacent cells that forms a rectangle in a worksheet
Range Address
Identifies the location of the selected range of cells (i.e.A1:D1)
Row
Start with numbers; are horizontal (across)
Spreadsheet
A program that allows you to use rows and columns of data to manage, predict, and present information.
Title bar
Displays the name of the workbook; ie"Book1."
Value
A number entered into a spreadsheet cell that will be used for calculations.
Worksheet
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
Sum
the function used to find the total of a range of cells
Argument
the values (enclosed within parentheses) in a function used to perform operations
fill handle
small black dot located in the lower right corner of the heavy border around the active cell
fill
shortcut used to copy formulas to new locations
average
function used to find the average of a range of cells
formulas
EQUATIONs used to solve calculations
max
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
min
function used to find the lowest value in a range of cells
function
the builtin formulas that do not require operators to calculate a result
$
symbol used to indicate an absolute cell reference
count
function used to count the entries in a range of cells (i.e.the number of students who turned in a research paper)
sorting
feature of spreadsheets and databases that will place data into a specific order
sort alphanumerically
arrange the order of data alphabetically
sort chronologically
arrange the order of data by date
xls or xlsx
file extension for Excel documents
line chart
chart to show progress over time
pie chart
chart to show parts to whole
bar chart
chart to compare sets of quantities
ascending
AZ, 110
descending
ZA, 101
;