Excel Project 1 – MS Excel
Use 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
Use 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
