79 terms

# Microsoft Excel

#### Terms in this set (...)

workbook
a file which contains one or more spreadsheets
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form
cells
refers to one specific location; Cell A4
cell range
refers to a group of adjacent cells; A4:A16
label
classification is used for cells that contain text or for numbers that will not be used in calculations
value
classification indicates that the data has the potential to be used in calculations (numbers)
formula
instructs the software to perform a calculation
=
ALL formulas begin with an equal sign
+
division
/
multiplication
*
subtraction
-
order of operations
PEMDAS
function
shortcut for a formula
cell reference
indicates a cell's location and provides instructions for how cell data is copied or used in calculations; also known as the cell address
relative reference
cell value changes as the formula is copied
absolute reference
cell value remains static when copied to other locations
mixed reference
combination of an absolute and a relative cell
conditions or criteria
tell the function how to calculate the results and what data to use.
SUM function
for example, =Sum(C4:C18) adds the range of cells from C4 through C18
AVERAGE function
for example, =Average(C4:C18) determines the average of the range of cells from C4 through C18
MAXIMUM function
for example, =Max(C4:C18) finds the highest number in the range of cells from C4 through C18
MINIMUM function
for example, =Min(C4:C18) finds the lowest number in the range of cells from C4 through C18
left aligned
default formatting for labels
right aligned
default formatting for values
workbook
a file which contains one or more spreadsheets
(or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.
Cells
refers to one specific location
Cell range
refers to a group of adjacent cells
label
classification is used for cells that contain text or for numbers that will not be used in calculations
value
classification indicates that the data has the potential to be used in calculations
formula
instructs the software to perform a calculation
a. Formulas begin with an equal sign (=). When the equal sign (or in some cases a plus sign (+)) is keyed in a cell, the software "knows" that the data will be used in a calculation
Order of Operations
Parentheses
Exponents
Multiplication and division (from left to right)
Addition and subtraction (from left to right)
Basic Operators
Division
Multiplication
Subtraction
basic function
shortcut for a formula
Cell reference
indicates a cell's location and provides instructions for how cell data is copied or used in calculations
Relative Reference
cell value changes as the formula is copied
Absolute Reference
cell value remains static when copied to other locations
Mixed Reference
combination of an absolute and a relative cell
Parentheses
control the Order of Operations
Sum
for example, =Sum(C4:C18) adds the range of cells from C4 through C18
Average
for example, =Average(C4:C18) determines the average of the range of cells from C4 through C18
Maximum
for example, =Max(C4:C18) finds the highest number in the range of cells from C4 through C18
Minimum
for example, =Min(C4:C18) finds the lowest number in the range of cells from C4 through C18
cell
intersection of a column and row in a
active cell
the cell in which you are currently working
function
a mathematical operation that is built into a spreadsheet program to perform shortcut caluculations
application software that allows users to use calculations
label
alphanumeric text not intended or calculations entered into a spreadsheet cell
highlight the desired cell
to format a cell this must be done first
individual cell location on a spreadsheet
workbook
a file that contains one or more spreadsheets
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information in numerical form
label
classification used for cells that contain text or numbers that will not be used in calculations
value
indicates the data has the potential to be used in calculations
formula
instructs the software to perform a calculation
equal sign
formulas begin with this
cell reference
indicates a cell's position and how the cell data will be used or copied in calculations
relative
cell value changes as the formula is copied
absolute
cell value remains the same when copied to other locations
mixed
combination of absolute and mixed
parentheses
control the order of operations
sum
average
determines the average for a range of cells
maximum
finds the highest number in the range of cells
minimum
finds the lowest number in a range of cells
appears at the top of each page
footer
appears at the bottom on each page
wrap
used to align multiline text within a cell
merge
used to combine two or more cells
column width
adjusted to fit the longest entry
PEMDAS
parentheses, exponets, multiply, divide, add, subtract
column
appears vertically and is identified by letters at the top of the worksheet window
row
appears horizontally and is identified by numbers on the left side of the worksheet window
autosum
a function that automatically adds the values in the cells directly above or to the left of the active cell
name box
displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.
autofit
adjusts column width to fit the cell contents.