UNH MIS Exam 2 KIM |Questions
Solved 100% Correct| Verified Solutions
What do dollar signs mean in a function - ANSWER This locks the rows or Collums your
data is in
A$2 - ANSWER The row does not change when copied
$A2 - ANSWER The column does not change when copied
$A$2 - ANSWER The column and the row do not change when copied
MIN - ANSWER Returns the smallest value in a set of numbers
MAX - ANSWER Returns the largest value in a set of numbers
AVERAGE - ANSWER Calculates the arithmetic mean of a set of numbers, which is
the sum of all numbers divided by the count of numbers
SUM - ANSWER Adds up all the numbers in a set
COUNT - ANSWER This function counts the number of cells that contain numbers
within a specified range
COUNTA - ANSWER It counts the number of cells within a specified range that are
not empty. It includes cells containing text, numbers, logical values, or error values
Solved 100% Correct| Verified Solutions
What do dollar signs mean in a function - ANSWER This locks the rows or Collums your
data is in
A$2 - ANSWER The row does not change when copied
$A2 - ANSWER The column does not change when copied
$A$2 - ANSWER The column and the row do not change when copied
MIN - ANSWER Returns the smallest value in a set of numbers
MAX - ANSWER Returns the largest value in a set of numbers
AVERAGE - ANSWER Calculates the arithmetic mean of a set of numbers, which is
the sum of all numbers divided by the count of numbers
SUM - ANSWER Adds up all the numbers in a set
COUNT - ANSWER This function counts the number of cells that contain numbers
within a specified range
COUNTA - ANSWER It counts the number of cells within a specified range that are
not empty. It includes cells containing text, numbers, logical values, or error values