Using a $ sign before both the row and column labels keeps the reference to that cell fixed no matter where the formula is copied.
Correct Answer:
Verified
Q24: In a MATCH function, if match_type =
Q25: Describe the method of calculating the net
Q26: The function returns a value or reference
Q27: To use the VLOOKUP(lookup_value, table_array, col_index_num), the
Q28: If cell G7 contains the function ,
Q30: A positive NPV means that the investment
Q31: The easiest way to locate a particular
Q32: Identify the equation for calculating the
Q33: For which of the following MATCH functions
Q34: Explain the different Lookup functions in Excel.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents