Multiple Choice
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
Correct Answer:
Verified
Q6: You would use _ to monitor data
Q7: When creating a data validation rule,you can
Q8: A formula that references itself is called
Q9: In a 3-D reference,worksheets references are separated
Q10: Which of the following references is written
Q11: To ungroup worksheets,right-click any one of the
Q12: When worksheets are grouped,[Group] is displayed in
Q13: A hyperlink to a worksheet always references
Q14: When referencing a worksheet in another workbook,the
Q16: To examine multiple worksheets in the same