WSP EXCEL CRASH COURSE EXAM |ACTUAL EXAM WITH CORRECT DETAILED AND
VERIFIED ANSWERS|GRADED A+|WALL STREET PREP EXCEL CRASH COURSE EXAM |NEW
UPDATE
Introduction - (ANSWER)
Easy to use ctrl functions when opening, printing, and saving - (ANSWER)ctrl + p
ctrl + s
ctrl + n
How to highlight a row - (ANSWER)Shift + Spacebar
How to highlight a column - (ANSWER)Ctrl + spacebar
Ctrl + 1 (very important) - (ANSWER)Basic formatting
Alt c for a font color
Alt d for number
Borders can be an exception to use the mouse for
What is the command for paste special and what is the rule that follows for paste special? -
(ANSWER)Alt + e + s
YOU NEED SOMETHING COPIED FIRST
Utilize operators
Can multiply by -1 as an example
, WSP EXCEL CRASH COURSE EXAM |ACTUAL EXAM WITH CORRECT DETAILED AND
VERIFIED ANSWERS|GRADED A+|WALL STREET PREP EXCEL CRASH COURSE EXAM |NEW
UPDATE
How to get between different workbooks - (ANSWER)Ctrl + tab
How to freeze a pane - (ANSWER)Alt + w + f +f
Use again to unfreeze
Holds the headers to make it easier to navigate large files
Splitting panes - (ANSWER)Alt + w + s
Use F6 to jump between the split and Shift + F6 to go back
Go all the way horizontal if you are looking to go up and down
What is the command to enter a comma - (ANSWER)Shift + F2
There is a way to delete all commas through ALT + H + E
Ctrl shortcut to move something - (ANSWER)Ctrl + X
then
Ctrl + V
Simple control commands - (ANSWER)Ctrl + Shift + !
VERIFIED ANSWERS|GRADED A+|WALL STREET PREP EXCEL CRASH COURSE EXAM |NEW
UPDATE
Introduction - (ANSWER)
Easy to use ctrl functions when opening, printing, and saving - (ANSWER)ctrl + p
ctrl + s
ctrl + n
How to highlight a row - (ANSWER)Shift + Spacebar
How to highlight a column - (ANSWER)Ctrl + spacebar
Ctrl + 1 (very important) - (ANSWER)Basic formatting
Alt c for a font color
Alt d for number
Borders can be an exception to use the mouse for
What is the command for paste special and what is the rule that follows for paste special? -
(ANSWER)Alt + e + s
YOU NEED SOMETHING COPIED FIRST
Utilize operators
Can multiply by -1 as an example
, WSP EXCEL CRASH COURSE EXAM |ACTUAL EXAM WITH CORRECT DETAILED AND
VERIFIED ANSWERS|GRADED A+|WALL STREET PREP EXCEL CRASH COURSE EXAM |NEW
UPDATE
How to get between different workbooks - (ANSWER)Ctrl + tab
How to freeze a pane - (ANSWER)Alt + w + f +f
Use again to unfreeze
Holds the headers to make it easier to navigate large files
Splitting panes - (ANSWER)Alt + w + s
Use F6 to jump between the split and Shift + F6 to go back
Go all the way horizontal if you are looking to go up and down
What is the command to enter a comma - (ANSWER)Shift + F2
There is a way to delete all commas through ALT + H + E
Ctrl shortcut to move something - (ANSWER)Ctrl + X
then
Ctrl + V
Simple control commands - (ANSWER)Ctrl + Shift + !