To simplify entering ranges in formulas you can use:
A) range names.
B) a cell's relative location.
C) both an absolute and a relative cell reference.
D) a cell's absolute location.
Correct Answer:
Verified
Q1: Formula AutoComplete
A) results in formulas such as
Q6: A circular reference
A) is a predefined formula
Q18: How many arguments are required for the
Q20: Which of the following is FALSE about
Q23: A nested function
A) contains data for the
Q23: What is a lookup table used for?
A)It
Q25: In Excel 2013,the function name describes the
Q26: An argument is an operator such as
Q36: The breakpoint
A) looks up a value and
Q59: A circular reference occurs when a formula
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