Which of the following is FALSE about a function in Excel?
A) A function is a predefined formula that performs a calculation.
B) There are more than 400 functions in Excel 2013.
C) Functions are organized into two categories in Excel.
D) Functions in Excel must adhere to correct syntax.
Correct Answer:
Verified
Q1: Formula AutoComplete
A) results in formulas such as
Q6: A circular reference
A) is a predefined formula
Q15: An absolute cell reference:
A)causes a potential error.
B)indicates
Q18: How many arguments are required for the
Q21: To simplify entering ranges in formulas you
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
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