Multiple Choice
What are the two main reasons why one should break up larger calculations into smaller ones in spreadsheet modeling?
A) to speed solution time and to determine intermediate values
B) to speed solution time and to avoid errors
C) so the formula can fit on the formula line and to speed solution time
D) to avoid errors and to determine intermediate values
E) so the formula can fit on the formula line and to avoid errors
Correct Answer:

Verified
Correct Answer:
Verified
Q27: Spreadsheet flexibility implies that the user should
Q28: In Excel, which function returns the square
Q29: The principle, "Do not hard-code an input
Q30: In Excel, _ references do not change
Q31: In Excel, when moving a formula to
Q33: In a spreadsheet, it is better to
Q34: In the Excel MATCH function, which "Match_type"
Q35: In Excel, you should delete unused worksheets
Q36: What are the most common useful numerical
Q37: In Excel, what is the shortcut to