When Excel detects an error in a formula:
A) the cell containing the formula is surrounded in a green border.
B) a green triangle is displayed in the top-left corner of the cell containing the formula.
C) the cell containing the formula is displayed with a light green fill.
D) the text in the cell containing the formula is displayed in bold green.
Correct Answer:
Verified
Q6: A hyperlink to a worksheet always references
Q7: When creating a data validation rule,you can
Q8: You would use _ to monitor data
Q9: Which of the following references is written
Q10: When using Trace Precedents and Trace Dependents,tracer
Q11: When referencing a worksheet in another workbook,the
Q12: In a 3-D reference,worksheets references are separated
Q13: To ungroup worksheets,right-click any one of the
Q14: To group adjacent worksheets,you:
A)click the first worksheet
Q15: A formula that references itself is called
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