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