Wall Street Prep Excel Crash Course Exam: Finance & Modeling Review Questions and Answers Guide

Wall Street Prep Excel Crash Course Exam:
Finance & Modeling Review Questions and
Answers Guide


________________________________________________



**Question 1**

What is the keyboard shortcut to "Paste Special" in Excel?

a. Ctrl + V

b. Ctrl + Alt + V

c. Alt + E + S
d. Both B and C

☑ d. Both B and C



________________________________________________



**Question 2**

Which function is used to return a value from a specific row and column in a range?
a. VLOOKUP

b. HLOOKUP

c. INDEX

d. MATCH

☑ c. INDEX

,________________________________________________



**Question 3**
What does the keyboard shortcut F4 do when a cell reference is selected in a formula?

a. Deletes the cell

b. Cycles through absolute and relative cell references

c. Closes the workbook

d. Opens the "Find and Replace" dialog

☑ b. Cycles through absolute and relative cell references



________________________________________________



**Question 4**

Which of the following shortcuts is used to "AutoSum" a column of numbers?

a. Ctrl + S

b. Alt + =

c. Shift + S
d. Ctrl + Alt + A

☑ b. Alt + =



________________________________________________



**Question 5**
In financial modeling, what color is typically used for "Hard-coded" inputs?

a. Red
b. Green

,c. Blue

d. Black

☑ c. Blue



________________________________________________



**Question 6**

What is the keyboard shortcut to group selected rows or columns?

a. Alt + G

b. Shift + Alt + Right Arrow

c. Ctrl + G
d. Shift + Alt + Left Arrow

☑ b. Shift + Alt + Right Arrow



________________________________________________



**Question 7**
How do you toggle between different open Excel workbooks?
a. Ctrl + Tab

b. Alt + Tab

c. Ctrl + F6

d. Both A and C

☑ d. Both A and C



________________________________________________


**Question 8**

, Which Paste Special command is used to flip data from a vertical column to a horizontal
row?

a. Values

b. Formulas

c. Transpose

d. Formats

☑ c. Transpose



________________________________________________


**Question 9**

What is the keyboard shortcut to open the "Format Cells" dialog box?

a. Ctrl + F
b. Ctrl + 1

c. Alt + H

d. Ctrl + Shift + F

☑ b. Ctrl + 1



________________________________________________


**Question 10**

Which function would you use to find the position of a specific value within a range?

a. INDEX

b. MATCH

c. LOOKUP

d. OFFSET

☑ b. MATCH