- | P a g e
pg. 1
EXCEL CRASH COURSE EXAM NEWEST 2025 ACTUAL
EXAM| WSP EXCEL CRASH COURSE FROM WALL
STREET| COMPLETE QUESTIONS AND CORRECT
ANSWERS (VERIFIED ANSWERS) ALREADY GRADED
A+|| BRAND NEW!!
What is the keyboard shortcut to open the paste special dialog box?Ctrl v Ctrl e s Alt e s or Alt h v s Ctrl h v
The correct answer is: Alt e s or Alt h v s
Ctrl v is the shortcut for basic paste. Ctrl e s is not a valid shortcut sequence. Ctrl h v is not a valid shortcut sequence.
Which of the following keys IS NOT a way to trace precedent cells?Ctrl [ Alt m p Alt t u t Ctrl Alt [
The correct answer is: Ctrl [. Ctrl [ is not a valid shortcut. Alt m p, Alt t u
t, and Ctrl Alt [ are all shortcuts that can be used to trace precedent cells.
What is the keyboard shortcut to freeze panes within a worksheet? 1 / 3
- | P a g e
pg. 2 Alt F W V Alt W S Alt W F F Alt A W T
The correct answer is: Alt w f f.
Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alt a w t is a shortcut to build data tables.
You are in cell A1 and start a formula by typing = in a worksheet with split top and bottom panes. In order to jump to the bottom pane while
working on the formula:
Hit Tab Hit F6 Hit Alt F6 Hit Alt Tab
The correct answer is: Hit F6
Tab will navigate to the next cell. Alt F6 is not a valid shortcut. Alt Tab will navigate to a different window.
Identify the commands to insert a comment and delete a comment 1)Alt e m 2) Alt e m 1)Alt h e m 2) Alt I m 1)Shift F2 2) Alt h e m 1)Alt h e m 2) Alt I s 2 / 3
- | P a g e
pg. 3 The correct answer is Shift F2, Alt h e m.Alt e m is a shortcut to open the menu to move or copy a selected sheet.Alt I s is the shortcut to insert a symbol.
Identify the utility used to create a dropdown menu in Excel.Alt d t Alt d v l Alt d l Alt d d t
The correct answer is: alt d l.
Alt d t is the shortcut to build a data table. Alt d v l is not a valid shortcut. Alt d d t is not a valid shortcut.
Which of the following is NOT a shortcut for changing the format of a cell Ctrl Tab Ctrl Shift 1 Ctrl B Alt h f c The correct answer is Ctrl Tab.Ctrl Tab will move the selected cell. It is not a shortcut used to format cells. Ctrl Shift 1 will change the cell to a Number format, Ctrl B makes the cell text bold, Alt h f c will allow to change the text color.
- / 3