MIS Exam 1 UNH Kim |Questions
Solved 100% Correct| Verified Solutions
What is relative referencing - ANSWER a system of referring to cells using letters
for columns and numbers for rows
Absolute Referencing - ANSWER Placing $ around column letter so cell reference will
not change when filled down (F4)
Min reference - ANSWER Funds lowest number in the range
Count function - ANSWER Counts the number of cells in a given range
COUNTA - ANSWER Gives number of cells that is counted for and does not count
the error or empty cells brahhh
COUNTBLANK function - ANSWER Counts number of cells that are blank
VLOOKUP function - ANSWER looks up a value in a vertical lookup table and returns a
related result from the lookup table
VLOOK UP - ANSWER (Lookup value,,search in the range,,return match number,,exact
match)
Today function - ANSWER displays the current date
Solved 100% Correct| Verified Solutions
What is relative referencing - ANSWER a system of referring to cells using letters
for columns and numbers for rows
Absolute Referencing - ANSWER Placing $ around column letter so cell reference will
not change when filled down (F4)
Min reference - ANSWER Funds lowest number in the range
Count function - ANSWER Counts the number of cells in a given range
COUNTA - ANSWER Gives number of cells that is counted for and does not count
the error or empty cells brahhh
COUNTBLANK function - ANSWER Counts number of cells that are blank
VLOOKUP function - ANSWER looks up a value in a vertical lookup table and returns a
related result from the lookup table
VLOOK UP - ANSWER (Lookup value,,search in the range,,return match number,,exact
match)
Today function - ANSWER displays the current date