Unit 3 Presentations Flashcards
what do lookup functions do?
looks up data using a cross-referencing method
what is a lookup value?
the known variable, what you are looking up
what is the return value?
the answer you are looking for
what is the lookup table?
where you go to find the information
what are the arguments of a lookup function?
=VLOOKUP(Lookup_Value, Table_Array, Column_Index_Number, Range_Lookup)
what is the Lookup_Value?
cell address for the known variable
what is the Table_array
all cell addresses from lookup table, except headings, make them absolute
what is the Column_Index_Number?
Number that represents which column we need fro the lookup table
what is the Range_lookup?
optional
true- if an approximate match is ok
false- if an exact match is required
what are the function arguments?
=IF(Logial_Test, Value_if_True, Value_if_False)
what is the logical test?
the criteria you want to test
how many parts are in the logical test of the if function?
3
cell address, comparison symbol, value
what is an if function?
decides between two possible answers, bases the decision on the criteria provided
what is the logical test of an if function?
the criteria you want to test
=IF(B5>8
what is the value if true part of an if function?
the value that you want returned if the result if the result of logical_test is TRUE
=IF(B5>8, 10
what is the value if false part of an if function?
the value you want returned if the result of the logical_test is false
=IF(B5>8,10,5)
what are the arguments of the SUMIF function?
=SUMIF(range, criteria, SumRange)
what is the SUMIF function?
adds up numbers in a range based on a specific condition or rule
what is the range in a SUMIF function?
range of cells you want evaluated by criteria
what is the criteria of the SUMIF function?
the rule or condition that entries in the range need to meet to be added up
what is the SumRange of the SUMIF function?
what to add up, use if you want Excel to add up different cells than the ones selected for the range
ex. if you were looking for a certain name in the first range, you will need to select a second range that contains numbers to have some to add
The IF function has 3 function arguments: =IF(Logical Test, Value if True, Value if False) The Logical Test argument always has 3 parts… what are they?
A. Cell Address Comparison Symbol Value
B. Comparison Symbol Value True/False
C. Cell Address Dash Number
D. None of these are true. The logical test does not have 3 parts.
cell address comparison symbol value
Which function will return the current date and time?
=NOW()
=DAYS()
=TODAY()
=TIME()
=NOW()
When would it be appropriate to use the FALSE entry for the Range Lookup Argument in a VLOOKUP?
When you need an exact match.
When you need an approximate match (within a range)
Always, this is the only option for the Range Lookup argument.
Never, Range Lookup up is not entered as True/False
when you need an exact match