Excel Crash course Exam from Wall Street
Updated 2026/2027 Questions with Answers
1. Create new sheet - ANSWER-ctrl i w
2. Switch between sheets - ANSWER-ctrl page up / ctrl page down
3. Access anything on the ribbon - ANSWER-atl
4. Toggle between excel books - ANSWER-ctrl tab
5. Open new file - ANSWER-ctrl o
6. Bold - ANSWER-ctrl b
7. Options - ANSWER-alt f t
8. Auto size cell - ANSWER-alt h o i
9. Designate width of box - ANSWER-alt h o w
10. Highlight column - ANSWER-ctrl space
11. Highlight row - ANSWER-shift space
12. Undo - ANSWER-ctrl z
13. Redo - ANSWER-ctrl y
14. Formatting - ANSWER-ctrl 1
15. Highlight all columns next - ANSWER-ctrl shift > / <
16. Paste special - ANSWER-alt e s
17. Zoom in / out - ANSWER-alt v z
18. Freeze pane - ANSWER-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest
of the worksheet scrolls.
19. Split pane - ANSWER-alt w s
20. Hop between panes - ANSWER-F6
, 21. Go inside cell to see functions - ANSWER-F2
22. Go inside cell to clear specific info - ANSWER-ALT h e
23. Input comment - ANSWER-Shift F2
24. Fill Highlighted Area Right / Down - ANSWER-ctrl r / ctrl d
25. Input New Row - ANSWER-ALT i r
26. Input new column - ANSWER-alt i c
27. Deleting columns / rows - ANSWER-ALT H D R / ALT H D C
28. Paste Special Formatting - ANSWER-ALT E S T
29. Trace Precedents - ANSWER-ATL M P / (delete it ALT M A A) allows you to see which
cells are referenced in a particular formula or function
30. Trace Dependents - ANSWER-ALT M D
31. Find and replace - ANSWER-ctrl h
32. IF - ANSWER-criteria, output if true, output if false
33. IF(AND( - ANSWER-IF(AND(first test, 2nd test), output is true, output if false)
34. Date function - ANSWER-(year,month,day) but if you do DATE(Year(cell w/ date to
reference)+1, Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of
dates increasing each year by 1
35. Yearfrac - ANSWER-Start, End, Basis (Basis = 0 or omitted = 30/360, 1 = actual / actual,
2 = actual over / 360, 3 = actual / 365) _____ is a function that will return the number of
years between two dates.
36. Hlookup - ANSWER-(look up value, table range, row number) - searches for a value in
the top row of a table or an array of values, and then returns a value in the same column
from a row you specify in the table or array - use HLOOKUP when your comparison
values are located in row across the top of a table of data, and you want to look a
specified number of rows.
37. Vlookup - ANSWER-(look up value, table range, column number) - searches for a value
in the leftmost column of a table, and then returns a value in the same row from a column
you specify in the table or array - use VLOOKUP when you comparison values are
located in a column to the left of a table of data, and you want to look across (and to the
Updated 2026/2027 Questions with Answers
1. Create new sheet - ANSWER-ctrl i w
2. Switch between sheets - ANSWER-ctrl page up / ctrl page down
3. Access anything on the ribbon - ANSWER-atl
4. Toggle between excel books - ANSWER-ctrl tab
5. Open new file - ANSWER-ctrl o
6. Bold - ANSWER-ctrl b
7. Options - ANSWER-alt f t
8. Auto size cell - ANSWER-alt h o i
9. Designate width of box - ANSWER-alt h o w
10. Highlight column - ANSWER-ctrl space
11. Highlight row - ANSWER-shift space
12. Undo - ANSWER-ctrl z
13. Redo - ANSWER-ctrl y
14. Formatting - ANSWER-ctrl 1
15. Highlight all columns next - ANSWER-ctrl shift > / <
16. Paste special - ANSWER-alt e s
17. Zoom in / out - ANSWER-alt v z
18. Freeze pane - ANSWER-alt w f f
To keep selected rows and/or columns of the worksheet visible on the screen as the rest
of the worksheet scrolls.
19. Split pane - ANSWER-alt w s
20. Hop between panes - ANSWER-F6
, 21. Go inside cell to see functions - ANSWER-F2
22. Go inside cell to clear specific info - ANSWER-ALT h e
23. Input comment - ANSWER-Shift F2
24. Fill Highlighted Area Right / Down - ANSWER-ctrl r / ctrl d
25. Input New Row - ANSWER-ALT i r
26. Input new column - ANSWER-alt i c
27. Deleting columns / rows - ANSWER-ALT H D R / ALT H D C
28. Paste Special Formatting - ANSWER-ALT E S T
29. Trace Precedents - ANSWER-ATL M P / (delete it ALT M A A) allows you to see which
cells are referenced in a particular formula or function
30. Trace Dependents - ANSWER-ALT M D
31. Find and replace - ANSWER-ctrl h
32. IF - ANSWER-criteria, output if true, output if false
33. IF(AND( - ANSWER-IF(AND(first test, 2nd test), output is true, output if false)
34. Date function - ANSWER-(year,month,day) but if you do DATE(Year(cell w/ date to
reference)+1, Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of
dates increasing each year by 1
35. Yearfrac - ANSWER-Start, End, Basis (Basis = 0 or omitted = 30/360, 1 = actual / actual,
2 = actual over / 360, 3 = actual / 365) _____ is a function that will return the number of
years between two dates.
36. Hlookup - ANSWER-(look up value, table range, row number) - searches for a value in
the top row of a table or an array of values, and then returns a value in the same column
from a row you specify in the table or array - use HLOOKUP when your comparison
values are located in row across the top of a table of data, and you want to look a
specified number of rows.
37. Vlookup - ANSWER-(look up value, table range, column number) - searches for a value
in the leftmost column of a table, and then returns a value in the same row from a column
you specify in the table or array - use VLOOKUP when you comparison values are
located in a column to the left of a table of data, and you want to look across (and to the
