Multiple Choice
To reduce the chance of messing up range specifications and minimize the likelihood that errors will creep in when columns and rows are added later
A) always use absolute cell references in all formulas
B) never hide columns in the spreadsheet
C) apply names in the spreadsheet
D) manually inspect all formulas in the spreadsheet
Correct Answer:
Verified
Correct Answer:
Verified
Q13: Computer scientists say it is better to
Q14: The advanced filtering technique allows you to
Q15: The Scenario Manager window is accessed by
Q16: When using Advanced Filtering on a column
Q17: In a spreadsheet names can only be
Q19: Use the File menu to insert comments
Q20: A named alternative to a spreadsheet that
Q21: Filtering applies only to spreadsheets that have
Q22: The advanced filtering technique that allows you
Q23: In a spreadsheet conditional formatting allows you