Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Previously searched by you
Previously searched by you
logo
  • WALL STREET PREP EXCEL CRASH COURSE
  • WALL STREET PREP EXCEL CRASH COURSE
To add items to your wishlist, you must be logged in
Exam (elaborations)

WALL STREET PREP EXCEL CRASH COURSE EXAM – 2026 EDITION COMPLETE QUESTIONS WITH 100% CORRECT ANSWERS

Rating
-
Sold
-
Pages
76
Grade
A+
Uploaded on
30-05-2026
Written in
2025/2026

WALL STREET PREP EXCEL CRASH COURSE EXAM – 2026 EDITION COMPLETE QUESTIONS WITH 100% CORRECT ANSWERS Question 1 All of the following are keyboard shortcuts that allow the user to add more sheets to a workbook EXCEPT A) Alt + H + I + W B) Shift + F11 C) Alt + Shift + F1 D) Fn + F11 Correct Answer: A) Alt + H + I + W ________________________________________ Question 2 What is the keyboard shortcut to open a file A) Ctrl + F12 B) Ctrl + O C) Ctrl + F D) Ctrl + N Correct Answer: B) Ctrl + O ________________________________________ Question 3 What is the recommended workbook calculation setting for Excel A) Manual B) Automatic C) Automatic except for Data Tables D) Manual except for Data Tables Correct Answer: C) Automatic except for Data Tables ________________________________________ Question 4 To add a cell reference from a different worksheet into an existing formula using only your keyboard, what is the correct sequence of steps Correct Answer: Step 1 Hit F2 to edit the existing formula; delete any incorrect formulas or operators Step 2 Hit F2 again to enable "Enter" mode (bottom-left corner) Step 3 Hold Ctrl, use PageUp or PageDown to find the desired worksheet Step 4 Release Ctrl and PageUp/PageDown keys Step 5 Use arrow keys to locate the desired cell reference Step 6 Hit Enter ________________________________________ Question 5 Match each shortcut to its function Alt + H + O + I Correct Answer: exact column width Alt + H + O + W Correct Answer: identical column widths Alt + H + O + H Correct Answer: identical column height Control + Space Correct Answer: highlight column Shift + Space Correct Answer: highlight row ________________________________________ Question 6 What is the keyboard shortcut to move sheets within a workbook A) Alt + H + O + M B) Alt + H + O + S C) Ctrl + PageUp D) Ctrl + Shift + PageDown Correct Answer: A) Alt + H + O + M ________________________________________ Question 7 What is the keyboard shortcut to open the Format Cells dialog box A) Ctrl + F B) Ctrl + Shift + F C) Ctrl + 1 D) Alt + Enter Correct Answer: C) Ctrl + 1 ________________________________________ Question 8 When you are in the Format Cells dialog (Ctrl + 1), what is the keyboard shortcut for moving across tabs (Number, Alignment, Font, Border, Fill, Protection) Correct Answer: Ctrl + Tab How do you move counterclockwise across form elements Correct Answer: Shift + Tab How do you select a checkbox (put a checkbox next to it) Correct Answer: Spacebar ________________________________________ Question 9 What is the keyboard shortcut to freeze panes within a worksheet A) Alt + W + F + F B) Alt + W + S C) Ctrl + F D) Alt + H + F Correct Answer: A) Alt + W + F + F ________________________________________ Question 10 What is the keyboard shortcut to open the Paste Special dialog box A) Alt + E + S B) Alt + H + V + S C) Ctrl + Alt + V D) All of the above Correct Answer: D) All of the above ________________________________________ Question 11 Which of the following keys is NOT a way to trace precedent cells

Show more Read less
Institution
WALL STREET PREP EXCEL CRASH COURSE
Course
WALL STREET PREP EXCEL CRASH COURSE

Content preview

WALL STREET PREP EXCEL CRASH COURSE EXAM – 2026 EDITION
COMPLETE QUESTIONS WITH 100% CORRECT ANSWERS




Question 1
All of the following are keyboard shortcuts that allow the user to add
more sheets to a workbook EXCEPT
A) Alt + H + I + W
B) Shift + F11
C) Alt + Shift + F1
D) Fn + F11
Correct Answer: A) Alt + H + I + W


Question 2
What is the keyboard shortcut to open a file
A) Ctrl + F12
B) Ctrl + O
C) Ctrl + F
D) Ctrl + N
Correct Answer: B) Ctrl + O


Question 3
What is the recommended workbook calculation setting for Excel
A) Manual
B) Automatic

,C) Automatic except for Data Tables
D) Manual except for Data Tables
Correct Answer: C) Automatic except for Data Tables


Question 4
To add a cell reference from a different worksheet into an existing
formula using only your keyboard, what is the correct sequence of steps
Correct Answer:
Step 1 Hit F2 to edit the existing formula; delete any incorrect formulas
or operators
Step 2 Hit F2 again to enable "Enter" mode (bottom-left corner)
Step 3 Hold Ctrl, use PageUp or PageDown to find the desired
worksheet
Step 4 Release Ctrl and PageUp/PageDown keys
Step 5 Use arrow keys to locate the desired cell reference
Step 6 Hit Enter


Question 5
Match each shortcut to its function
Alt + H + O + I
Correct Answer: exact column width
Alt + H + O + W
Correct Answer: identical column widths
Alt + H + O + H
Correct Answer: identical column height

,Control + Space
Correct Answer: highlight column
Shift + Space
Correct Answer: highlight row


Question 6
What is the keyboard shortcut to move sheets within a workbook
A) Alt + H + O + M
B) Alt + H + O + S
C) Ctrl + PageUp
D) Ctrl + Shift + PageDown
Correct Answer: A) Alt + H + O + M


Question 7
What is the keyboard shortcut to open the Format Cells dialog box
A) Ctrl + F
B) Ctrl + Shift + F
C) Ctrl + 1
D) Alt + Enter
Correct Answer: C) Ctrl + 1


Question 8
When you are in the Format Cells dialog (Ctrl + 1), what is the keyboard
shortcut for moving across tabs (Number, Alignment, Font, Border, Fill,
Protection)

, Correct Answer: Ctrl + Tab
How do you move counterclockwise across form elements
Correct Answer: Shift + Tab
How do you select a checkbox (put a checkbox next to it)
Correct Answer: Spacebar


Question 9
What is the keyboard shortcut to freeze panes within a worksheet
A) Alt + W + F + F
B) Alt + W + S
C) Ctrl + F
D) Alt + H + F
Correct Answer: A) Alt + W + F + F


Question 10
What is the keyboard shortcut to open the Paste Special dialog box
A) Alt + E + S
B) Alt + H + V + S
C) Ctrl + Alt + V
D) All of the above
Correct Answer: D) All of the above


Question 11
Which of the following keys is NOT a way to trace precedent cells
Report Copyright Violation

Written for

Institution
WALL STREET PREP EXCEL CRASH COURSE
Course
WALL STREET PREP EXCEL CRASH COURSE

Document information

Uploaded on
May 30, 2026
Number of pages
76
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

  • wall street
  • wall street prep excel crash course exam
  • questions with 100 correct answers
$15.99
Get access to the full document:
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Get to know the seller
Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
maingirose
5.0
(2)

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
maingirose Chamberlain College Of Nursing
View profile
Follow You need to be logged in order to follow users or courses
Sold
9
Member since
3 months
Number of followers
0
Documents
751
Last sold
2 days ago
MaingiRose

THE PREMIUM STUDY RESOURCE HUB – VERIFIED ANSWERS FOR EVERY LEARNER COMPREHENSIVE STUDY GUIDES DESIGNED FOR SUCCESS. EVERY QUESTION NUMBERED. EVERY ANSWER CONFIRMED. DETAILED EXPLANATIONS THAT BUILD UNDERSTANDING. ALL ANSWER CHOICES INCLUDED FOR COMPLETE PREPARATION. CLEAR, ACCURATE, AND EASY TO USE. FORMATTED FOR QUICK REFERENCE AND FAST LEARNING. PERFECT FOR STUDENTS, PROFESSIONALS, AND LIFELONG LEARNERS SEEKING RELIABLE, TRUSTWORTHY MATERIALS. COMPLETE PATIENT CASE ANALYSES WITH SOAP NOTES. COMPREHENSIVE Q&A COLLECTIONS WITH STEP-BY-STEP RATIONALES. TECHNICAL GUIDES WITH PRACTICAL APPLICATIONS. ALL CONTENT VERIFIED FOR ACCURACY. YOUR TRUSTED SOURCE FOR QUALITY STUDY MATERIALS. MASTER YOUR SUBJECTS. STUDY SMARTER. ACHIEVE MORE.

Read more Read less
5.0

2 reviews

5
2
4
0
3
0
2
0
1
0

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

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions