A circular reference
A) is a predefined formula that performs a calculation.
B) is a rule that governs the structure and components for functions.
C) occurs when a formula directly or indirectly refers to the cell containing the formula.
D) is an input such as a cell reference or a value needed to complete a function.
Correct Answer:
Verified
Q1: Formula AutoComplete
A) results in formulas such as
Q2: A function is a
A) predefined formula that
Q3: The COUNTBLANK function
A) tallies the number of
Q4: The AVERAGE function
A) calculates the arithmetic mean
Q5: A function Screen Tip
A) automatically inserts functions
Q7: The MAX function
A) tallies the number of
Q8: The MIN function
A) identifies the highest value
Q9: The COUNT function
A) tallies the number of
Q10: Syntax (as it applies to Excel 2010)
A)
Q11: Excel displays a green arrow in the
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