UNH MIS Exam 2 KIM |Questions
Solved 100% Correct| Verified Solutions
TODAY - ANSWER Returns the current date
DAY - ANSWER Extracts the day value from a date
MONTH - ANSWER Extracts the month value from a date
YEAR - ANSWER Extracts the year value from a date
What tab is freezing rows - ANSWER View
NestedIF - ANSWER Allows you to preform logical tests and return values based on
those results
SUMIF - ANSWER This function adds up the values in a range that meet a specific
condition
COUNTIF - ANSWER This function counts the number of cells within a range that meet
a specific condition
AVERAGEIF - ANSWER This function calculates the average of values in a range
that meet a specific condition
Solved 100% Correct| Verified Solutions
TODAY - ANSWER Returns the current date
DAY - ANSWER Extracts the day value from a date
MONTH - ANSWER Extracts the month value from a date
YEAR - ANSWER Extracts the year value from a date
What tab is freezing rows - ANSWER View
NestedIF - ANSWER Allows you to preform logical tests and return values based on
those results
SUMIF - ANSWER This function adds up the values in a range that meet a specific
condition
COUNTIF - ANSWER This function counts the number of cells within a range that meet
a specific condition
AVERAGEIF - ANSWER This function calculates the average of values in a range
that meet a specific condition