Multiple Choice
Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?
A) A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label.
B) A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference.
C) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.
D) A relative address uses only the column label in the cell reference; an absolute address uses the row.
Correct Answer:
Verified
Correct Answer:
Verified
Q26: The Excel function of is used to
Q27: To find the number of orders with
Q28: Using a $ sign before a column
Q29: In a MATCH function, if the match_type
Q30: Which of the following functions is a
Q32: Give the logical function for the following:
Q33: is a logical function that returns one
Q34: The reflects the opportunity costs of spending
Q35: Using a $ sign before both the
Q36: measures the worth of a stream of