unit E Flashcards
convert text columns
breaks data fields in one column into separate columns
delimiter
separate such as a space comma or semicolon used to separate data elements
proper function
capitalizes the first letter of a word in a column example = PROPER (a1)
data tab
lets you work with conversions
UPPER
converts text to all caps
Lower
converts text to all lowercase
if commands
are used based on different conditions
consolidate
summarizes similar data that exists in different sheets
link
allows you to reference data in other sheets or in other workbooks
External reference indicator
cells referenced are outside the active sheet
IF error
displays a message or value that you specify rather than the one automatically generated by Excel
Circular reference
contains a formula that refers to its own cell location
DIV/0!:
a number is divided by 0
NA
a value in a formula is not available
3-D reference
reference other sheets- which creates another dimension
NUM!
invalid use of a number in a formula
VALUE!
wrong type of formula argument or operand
NAME!
formula contains text error
NULL!
invalid intersection of areas
REF!
invalid cell reference
#####
column is not wide enough to display data
Scope
Worksheets where it can. be used
Logical formula
makes calculations based on criteria
Stated conditions
criteria you create
logical test
a condition that can be answered with a true or false response
<
less than
>
greater than
=
equal too
<=
less than or equal to
> =
greater than or equal to
<>
not equal to
returns
displays
AND function
evaluates all of its arguments and returns
PMT
financial function that calculates the periodic payment amount for money borrowed9 car payment) = rate, per, pv)
FV
future value of money given for monthly investment
