BIS 155 Experience Tradition / tutorialrank.com BIS 155 Experience Tradition / tutorialrank.com | Page 81

want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a( n) _____ cell reference.
abtract 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