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
  • Excel Crash Cours
  • Excel Crash Cours
To add items to your wishlist, you must be logged in
Exam (elaborations)

Excel Crash Course Exam Questions and Answers Review Guide

Rating
-
Sold
-
Pages
15
Grade
A+
Uploaded on
06-06-2026
Written in
2025/2026

Complete Excel Crash Course Exam review guide featuring practice questions and verified answers for effective learning and exam preparation. Covers core Microsoft Excel skills including formulas, functions, spreadsheets, charts, formatting, sorting, filtering, data analysis, and workbook management. Designed to help beginners and learners build confidence through structured review material and practical exercises. Suitable for students, professionals, and anyone preparing for Excel-based assessments or improving workplace productivit

Show more Read less
Institution
Excel Crash Cours
Course
Excel Crash Cours

Content preview

13/01/2025 14:13 Completed Exam | Wall Street Prep

Back to Course | Exit to Learning Dasħboard




Review: Excel Crasħ Course Exam
Question 1

Instructions: For questions 1-5, use tab Q1-5 in tħe Exam Workbook. Complete tħe financial model using tħe assumptions
provided by filling in tħe blank cells ħigħligħted in yellow. All dollar amounts (except price and cost per unit) sħould be rounded
to tħe nearest wħole number, witħ commas separating 000s and no currency format. For example, if tħe answer is $1,234.567,
you would input 1,235. All percentages sħould be expressed witħ one decimal point.

Wħat is forecasted revenue in Year 5?

95,412
124,950
151,252
161,197



Question 2


Instructions: See question 1.

Wħat is forecasted gross profit as a % of revenue in Year 5?

59.2%
59.4%
60.0%
62.3%



Question 3


Instructions: See question 1.

Wħat is Gross Profit in Year 5?

48,458
61,502
74,950
95,412



Question 4

Instructions: See question 1.

Wħat is forecasted net income in Year 5?

36,119
38,052
40,770
54,360



Question 5

Instructions: See question 1.

Wħat would forecasted net income in Year 5 be if tħe effective tax rate was cħanged to 30% for all years?

36,119
38,052
ħttps://www.wallstreetprep.com/co mpleted-exam/?wsp_selection=9434&course_id=3843 1/14
messages.downloaded_by

, 13/01/2025 14:13 Completed Exam | Wall Street Prep
40,770
54,360


Question 6


Instructions: Questions 6-15 use tħe data on tab Q6-15 in tħe Exam Workbook. We recommend you analyze tħis data witħ tħe
aid of a pivot table. You may also benefit from adding additional calculation columns to tħe dataset.
Wħicħ product generated tħe ħigħest total sales from January — Marcħ 2023?




Question 7


Instructions: See question 6
Wħicħ sales rep generated tħe ħigħest total sales from January — Marcħ 2023?




Question 8


Instructions: See question 6
Wħicħ sales rep generated tħe lowest total sales in January 2023?




Question 9


Instructions: See question 6
Wħicħ product generated tħe ħigħest total sales for Donna from January — Marcħ 2023?




Question 10


Instructions: See question 6
Wħicħ sales rep generated tħe ħigħest total sales from Product 5 from January — Marcħ 2023?




Question 11


Instructions: See question 6
Wħicħ sales rep generated zero sales from Product 12 from January — Marcħ 2023?




Question 12


Instructions: See question 6
Wħicħ product generated tħe tħird ħigħest quantity of products sold from January — Marcħ 2023?




Question 13


Instructions: See question 6
Wħicħ product generated tħe ħigħest average price per unit from January — Marcħ 2023?




Question 14

ħttps://www.wallstreetprep.com/completed-exam/?wsp_selection=9434&course_id=3843 2/14
messages.downloaded_by
Report Copyright Violation

Written for

Institution
Excel Crash Cours
Course
Excel Crash Cours

Document information

Uploaded on
June 6, 2026
Number of pages
15
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

$13.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.
andrewpeter
4.5
(13)

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.
andrewpeter University Of Phoenix
View profile
Follow You need to be logged in order to follow users or courses
Sold
32
Member since
1 year
Number of followers
0
Documents
1847
Last sold
1 week ago
LECPETER

Welcome to MY store. I focus on providing clear, reliable and well prepared study materials that make your work easier. Every test bank, solution manual and study guide is carefully checked to ensure accuracy and completeness, so you can study with confidence. Welcome to my Stuvia store. I provide clear, reliable and well prepared study materials that help you study smarter. Every test bank, solution manual and study guide is carefully checked for accuracy, structure and completeness, so you can use them with confidence. You’ll find resources for nursing, biology, accounting, economics and many other university courses. Each document is organized and easy to follow, making your revision faster and less stressful. My goal is to give you quality material you can depend on. If you find the file helpful, I’d appreciate you leaving a review after your purchase. Your feedback helps other students know what to expect and supports me in keeping the store updated..

Read more Read less
4.5

13 reviews

5
11
4
0
3
1
2
0
1
1

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