Multiple Choice
A student is using a spreadsheet model to track monthly income and expenses and also to calculate his annual income. After pressing Ctrl+~, the formula view of the spreadsheet (shown below) was visible. What spreadsheet construction error did the student commit?
A) Using an advanced Excel formula instead of a simpler mathematical calculation.
B) Entering data in more than one place.
C) Failure to adequately use labels to identify cells.
D) Incorrect formula.
E) There are no errors in the spreadsheet.
Correct Answer:

Verified
Correct Answer:
Verified
Q14: When an analyst uses Solver to find
Q15: A spreadsheet developer enters the formula "=$B$9*B10"
Q16: Numbers should be included directly in formulas
Q17: The toggle feature in Excel switches back
Q18: In the spreadsheet shown below, which of
Q20: When developing a new spreadsheet model, it
Q21: The data is the first thing that
Q22: Which of the following statements about a
Q23: A spreadsheet modeler is creating a spreadsheet
Q24: A spreadsheet modeler is creating a spreadsheet