1|Page
EXCEL CRASH COURSE FROM WALL STREET EXAM NEWEST
2025/2026 ACTUAL EXAM WITH COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
How to change a list of numbers quoted in 1,000s to 1s -
ANSWER-In another cell, enter the number 1000
Copy this cell, then highlight your list of numbers
Press Alt+E+S+M (Paste Special Multiply)
Paste Special Operations - ANSWER-Allows you to apply
operations to large amounts of data
You can convert large amounts of data to positive to negative or
vice versa
*Note: You should ONLY paste on numbers that are hard inputs
Converting Positive Numbers to Negative - ANSWER-Ctrl+C the
data values
Special paste the new numbers using the Subtract operation -
Alt+E+S+S
,2|Page
OR
In another cell, enter the number -1
Ctrl+C -1 and special paste on the relevant numbers using the
multiply operation (Alt+E+S+M)
Paste Special Transpose - ANSWER-Allows users to convert a
vertical list of data into a horizontal list of data, and vice versa
(1) Highlight and copy the list of numbers
(2) Move your cursor outside of the list range
(3) Press Alt+E+S+E (Paste Special Transpose)
*Note: Be careful when applying a paste special transpose on
formulas -- they don't work on formulas with relative references
Ctrl Shortcuts - ANSWER-Cut: Ctrl+X
Cut Cells - ANSWER-Ctrl+X
Note: Dependent calculations DO NOT change when you cut
cells!
,3|Page
Number Format: 2 decimals, 000 separator - ANSWER-
Ctrl+Shift+!
Currency Format: 2 decimal places - ANSWER-Ctrl+Shift+$
Percentage Format with No Decimal Places - ANSWER-
Ctrl+Shift+%
Date Format with the Day, Month, and Year - ANSWER-
Ctrl+Shift+#
Boldface - ANSWER-Ctrl+B
Italicize - ANSWER-Ctrl+I
Underline - ANSWER-Ctrl+U
(Cmnd+U)
, 4|Page
Remove All Borders - ANSWER-Ctrl+Shift+_
Naming Cells - ANSWER-Ctrl+F3 > Alt+N to name a new cell
(Ctrl+L)
Anchoring Cells - ANSWER-Anchoring (or "fixing") cells that are
being referenced in a formula tells Excel that even if you copy the
formula to another cell, the cells in the formula that are anchored
should not change
(Fn+)F4 on the name of the cell in a formula
Keep clicking F4 to toggle the type of anchor
Naming Worksheets - ANSWER-Alt+H+O+R
Inserting & Deleting Worksheets - ANSWER-Add a new
worksheet by pressing Alt+H+I+S
Delete a worksheet by pressing Alt+E+L
EXCEL CRASH COURSE FROM WALL STREET EXAM NEWEST
2025/2026 ACTUAL EXAM WITH COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (100% VERIFIED ANSWERS)
|ALREADY GRADED A+| ||PROFESSOR VERIFIED||
How to change a list of numbers quoted in 1,000s to 1s -
ANSWER-In another cell, enter the number 1000
Copy this cell, then highlight your list of numbers
Press Alt+E+S+M (Paste Special Multiply)
Paste Special Operations - ANSWER-Allows you to apply
operations to large amounts of data
You can convert large amounts of data to positive to negative or
vice versa
*Note: You should ONLY paste on numbers that are hard inputs
Converting Positive Numbers to Negative - ANSWER-Ctrl+C the
data values
Special paste the new numbers using the Subtract operation -
Alt+E+S+S
,2|Page
OR
In another cell, enter the number -1
Ctrl+C -1 and special paste on the relevant numbers using the
multiply operation (Alt+E+S+M)
Paste Special Transpose - ANSWER-Allows users to convert a
vertical list of data into a horizontal list of data, and vice versa
(1) Highlight and copy the list of numbers
(2) Move your cursor outside of the list range
(3) Press Alt+E+S+E (Paste Special Transpose)
*Note: Be careful when applying a paste special transpose on
formulas -- they don't work on formulas with relative references
Ctrl Shortcuts - ANSWER-Cut: Ctrl+X
Cut Cells - ANSWER-Ctrl+X
Note: Dependent calculations DO NOT change when you cut
cells!
,3|Page
Number Format: 2 decimals, 000 separator - ANSWER-
Ctrl+Shift+!
Currency Format: 2 decimal places - ANSWER-Ctrl+Shift+$
Percentage Format with No Decimal Places - ANSWER-
Ctrl+Shift+%
Date Format with the Day, Month, and Year - ANSWER-
Ctrl+Shift+#
Boldface - ANSWER-Ctrl+B
Italicize - ANSWER-Ctrl+I
Underline - ANSWER-Ctrl+U
(Cmnd+U)
, 4|Page
Remove All Borders - ANSWER-Ctrl+Shift+_
Naming Cells - ANSWER-Ctrl+F3 > Alt+N to name a new cell
(Ctrl+L)
Anchoring Cells - ANSWER-Anchoring (or "fixing") cells that are
being referenced in a formula tells Excel that even if you copy the
formula to another cell, the cells in the formula that are anchored
should not change
(Fn+)F4 on the name of the cell in a formula
Keep clicking F4 to toggle the type of anchor
Naming Worksheets - ANSWER-Alt+H+O+R
Inserting & Deleting Worksheets - ANSWER-Add a new
worksheet by pressing Alt+H+I+S
Delete a worksheet by pressing Alt+E+L
