BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / 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