100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.6 TrustPilot
logo-home
Exam (elaborations)

Excel Crash Course Exam

Rating
-
Sold
-
Pages
16
Grade
A+
Uploaded on
18-06-2025
Written in
2024/2025

Excel Crash Course Exam from Wall Street Prep - Wall Street Prep Questions And Answers Updated 2022

Institution
Excel Crash Course From Wall Street Prep
Course
Excel Crash Course from Wall Street Prep

Content preview

Excel Crash Course Exam from Wall Street Prep -
Wall Street Prep Questions And Answers Updated
move back and forth between the worksheets in a workbook - ANSWER: *Ctrl
PageUp* or *Ctrl PageDown*

open a file - ANSWER: *alt f o*

*ctrl o*

save a file - ANSWER: *alt f s*

*ctrl s*

print a file - ANSWER: *alt f p*

*ctrl p*

navigating to the toolbars without the mouse - ANSWER: hit *Alt and the appropriate
letter* (or use the right/left arrow keys) to get to the desired tab

once there, use the Tab and Shift Tab keys to navigate around

accessing settings - ANSWER: File > Options (*Alt f t*)

*Alt t o*

Disabling the Start Screen and adding more worksheets on startup - ANSWER: click
on 'Blank worksheet' !@#$
%^&*
Hit *Alt f t* go go to Excel options (you can also get there by clicking the file tab) (*&^
%$#@
Under 'General' unselect "Show the Start screen when this application starts"
#$%^
password protecting files - ANSWER: File &*(*&
Info ^%$#
@#$%
password protect files: "Encrypt with Password" ^&*(*
&^%$
password protect individual worksheet (so that people can't see or edit formulas):
"Protect Current Sheet" #@#$
%^&
highlighting columns and rows - ANSWER: columns: *Ctrl Spacebar*
rows: *Shift Spacebar*

widening columns and rows - ANSWER: highlight column by pressing *Ctrl
Spacebar*

,Excel Crash Course Exam from Wall Street Prep -
Wall Street Prep Questions And Answers Updated
*Alt h o i* to auto-fit the column width
-if you want a column to have a certain width, press *Alt h o w* and enter the desired
width

highlight row by pressing Shift Spacebar
*Alt h o a* to auto-fit the row height
-if you want a row to have a certain height, press *Alt h o h* and enter the desired height

format cells - ANSWER: *Ctrl 1* pulls up the 'Format Cells' menu

navigating the 'Format Cells' menu - ANSWER: after hitting Ctrl 1 to pull up the
'Format Cells' menu, you can navigate around tabs by hitting *Ctrl tab*

each category within a tab can be accessed by pressing *Alt* and the appropriate
underlined letter, or by hitting *tab* to move clockwise and *shift tab* to move counter
clockwise

when on the desired tab, horizontal alignment can be accessed through *Alt h* and
vertical alignment through *Alt v*

paste special - ANSWER: *Alt v s t* or *Alt e s t*

changing zoom size - ANSWER: *Alt w q* or *Alt v z*

Move/copy a tab - ANSWER: *Alt h o m*
!@#$
freezing panes - ANSWER: click the cell BELOW the desired row and to the RIGHT %^&*
of the desired column where you want to freeze panes and hit *Alt w f f* (*&^
%$#@
to unfreeze panes: press *Alt w f f* again
#$%^
splitting panes - ANSWER: splitting panes allows users to scroll in both areas of the &*(*&
worksheet, while rows and columns in the non-scrolled area remain visible ^%$#
@#$%
to split panes:
^&*(*
-click the cell BELOW the desired row and to the RIGHT of the desired column where
you want to split panes and hit *Alt w s* &^%$
-to unspilt panes, click *Alt w s* again #@#$
-press *F6* to move from pane to pane in a clockwise direction; press *Shift F6* to %^&
move from pane to pane in a counter-clockwise direction

manipulating data inside a cell - ANSWER: *F2* is the command that puts you inside
a cell:

, Excel Crash Course Exam from Wall Street Prep -
Wall Street Prep Questions And Answers Updated
-pressing the F2 key once shows you the components of the formula you created
earlier, puts you inside a cell and enables you to navigate through it to edit the existing
cell data
-pressing the F2 key twice activates the cursor and enables you to move to different
cells, worksheets, and even other open Excel files

*Shift arrow key* will highlight characters one at a time

*Shift Ctrl arrow key* will highlight contiguous ranges of characters

deleting and clearing cell data - ANSWER: hitting *Delete* does NOT delete the
formatting in the cell

to truly delete a cell:
-*Alt h e* (Home tab > Clear)
-from the drop-down, chose the appropriate actions
*(Alt h e) a*: clears ALL contents of the cell
*(Alt h e) f*: clears only the cell FORMAT
*(Alt h e) c*: clears only the cell CONTENT
-this is the same as hitting Delete
*(Alt h e) m*: clears only the cell COMMENTS

right and down fills - ANSWER: highlight the range

*Ctrl R* tells Excel to look at the LEFTMOST column of a range of highlighted cells and
copy and paste the inputs and formulas in that column to all the columns to the right !@#$
*Ctrl D* does the same thing for rows that Ctrl R does for columns, telling Excel to look %^&*
at the topmost row of a range of highlighted cells and to copy and paste the inputs and (*&^
formulas in that row down to all the rows below it %$#@
#$%^
inserting comments - ANSWER: enter the cell and type *Shift F2*
&*(*&
hit *Esc* twice to exit the comment area ^%$#
@#$%
to edit an existing comment: go to the cell and press *Shift F2* ^&*(*
&^%$
to delete a comment: press *Alt h e am*
#@#$
inserting rows - ANSWER: highlight the row BELOW the row where you want to add %^&
a row

press *Shift spacebar* to highlight the entire row

press *Ctrl Shift +* to insert the row

Written for

Institution
Excel Crash Course from Wall Street Prep
Course
Excel Crash Course from Wall Street Prep

Document information

Uploaded on
June 18, 2025
Number of pages
16
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
Free
Get access to the full document:
Download

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

Get to know the seller
Seller avatar
victormwenda

Get to know the seller

Seller avatar
victormwenda EXAMS
View profile
Follow You need to be logged in order to follow users or courses
Sold
22
Member since
7 months
Number of followers
0
Documents
238
Last sold
1 day ago

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions