PREP QUESTIONS AND ANSWERS UPDATED 2025/ GET IT 100%
ACCURATE!!
Question 1
All of the following are valid keyboard shortcuts for inserting a new worksheet in Excel
EXCEPT:
A) Shift + F11
B) Alt + Shift + F1
C) Alt + H + I + S
D) Alt + H + I + W
E) All of the above are valid shortcuts
Correct Answer: D) Alt + H + I + W
Rationale: Shift + F11 and Alt + Shift + F1 are traditional shortcuts for adding a new sheet.
Alt + H + I + S is the modern ribbon-based sequence (Home > Insert > Insert Sheet). Alt +
H + I + W is not a standard Excel shortcut for this action.
Question 2
What is a standard keyboard shortcut to open the "Open" file dialog box in Excel?
A) Ctrl + N
B) Ctrl + S
C) Ctrl + F
D) Ctrl + P
E) Ctrl + O
Correct Answer: E) Ctrl + O
Rationale: Ctrl + O is the standard Windows keyboard shortcut to open the "Open" dialog
box in most applications, including Excel, allowing you to browse for a file to open.
Question 3
For large financial models that may contain resource-intensive data tables, what is the
recommended workbook calculation setting in Excel?
A) Automatic
B) Manual
C) Automatic Except for Data Tables