Exam (elaborations)
UMUC IFSM 201 Excel Project 1 University of Maryland,
- Course
- Institution
UMUC IFSM 201 Excel Project 1 University of Maryland, UMUC IFSM 201 Excel Project 1 University of Maryland,
[Show more]
Seller
Follow
Pronurse
Reviews received
Content preview
Excel Project 1 – MS ExcelUse the project description HERE to complete this activity. For a review of the complete rubric
used in grading this exercise, click on the Assignments tab, then on the title "Excel Project 1."
Click on Show Rubrics if the rubric is not already displayed.
Summary
Create a Microsoft Excel file with four worksheets that provides extensive use of Excel
capabilities including graphing, and written analysis and recommendations in support of a
business enterprise.
A large rental car company has two metropolitan locations, one at the airport and another
centrally located in downtown. It has been operating since 2015 and each location summarizes
its car rental revenue
quarterly. Both locations rent two classes of cars: economy and premium. Rental revenue is
maintained separately for the two classes of rental vehicles.
The data for this case resides in the file Excel Project 1-Data.txt and can be downloaded by
clicking on the Assignments tab, then on the data tile name. It is a text file (with the file type
.txt).
Do not create your own data. You must use the data provided and only the data provided.
Tutorials
Note: Tutorials that address activities used in this project have been assigned in
Week 1, 2 and 3.
Requirement Points Comments
Allocated
Open Excel and save a blank worksheet with the
following name:
Use Print Preview to
a. “Student’s First InitialLast Name Excel review how spreadsheet
1 Project 1” Example: JSmith Excel Project 1. 0.2
would print.
b. Set Page Layout to Landscape
1
, a. Change the name of the worksheet to
2 0.1
Analysis by.
a. In the Analysis by worksheet, enter the four Use the following
labels vertically in column A in the following text format:
order: Name:, Class/Section:, Project:, Date
Due:
b. Place a blank row between each label. Arial 10 point
Please note the colon, (:) after each label.
3 0.3
c. Align the labels to the right in the cell Bold
d. It may be necessary to adjust the column
width so the four labels are clearly visible.
Align values Right in
the cell
a. In the Analysis by worksheet, with all Use the following
entries in column C, enter the appropriate text format:
values for Name, Class and Section,
Arial 10 point
Project, Date Due.
4 0.3 Bold
b. It may be necessary to adjust the column
width so the four labels are clearly visible. Align values left in the
cells
c. Use the formatting listed in the Comments
2
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Pronurse. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now