A function Screen Tip
A) automatically inserts functions such as SUM (B4:C4) .
B) calculates the total of values contained in two or more cells.
C) automatically inserts formulas such as =B4+C4.
D) is a small pop-up description that displays the arguments for a function as you enter it.
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
Q6: A circular reference
A) is a predefined formula
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