abstract relative mixed absolute
Question 4. Question:( TCO 2) In Excel, an argument would be best described by which of the following statements? Calculates the total of values contained in two or more cells Is an input, such as a cell reference or a value needed to complete a function Is a small pop-up description that displays the results of the cell
Question 5. Question:( TCO 2) Which of the following describes the AVERAGE function? Calculates the arithmetic mean of values in a range Identifies the midpoint value in a set of values Identifies the highest value in a range Displays the lowest value in a range
Question 6. Question:( TCO 2) The MIN function would identify the _____. highest value in a range Tallies of the number of blank cells in a range lowest value in a range midpoint value in a range
Question 7. Question:( TCO 2) The NOW function would perform which of the following? Contains another function embedded inside one or more of its arguments Evaluates a condition and returns one value if the condition is true and a different value if the condition is false Evaluates true or false Displays the current date and time