Excel Capabilities for Charting Project 3 Data Worksheets
Order ID: 89JHGSJE83839 Style: APA/MLA/Harvard/Chicago Pages: 5-10 Instructions:
Excel Capabilities for Charting Project 3 Data Worksheets
Question Description
Excel Project 3 MS Excel (Spring 2019)
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 #3. 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 for charting. The charts will be copied into a Microsoft PowerPoint file and the student will develop appropriate findings and
recommendations based on analysis of the data.
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 four
classes of cars: economy, premium, hybrid, SUV. Rental revenue is maintained separately for the four classes of rental
vehicles.
The data for this case resides in the file spring2019rentalcars.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.Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and decimal point variations
for numeric data, but Arial 10 will be the default font and font size.
Step Requirement Comments
1Open Excel and save a blank workbook with the following name: a. Students First InitialLast Name Excel Project 3
Example: JSmith Excel Project 3 b. Set Page Layout Orientation to Landscape
Use Print Preview to review how the first worksheet would print.
2 Change the name of the worksheet to Analysis by.
3
In the Analysis by worksheet:
a. Beginning in Row 1, enter the four labels in column A (one label per row) in the following order: Name:, Class/Section:, Project:, Date Due: b. Place a blank row between each label. Please note the colon : after each label. c. Align the labels to
the right side in the cells
It may be necessary to adjust the column width so the four labels are clearly visible within Column C (not extending into
Column D).
Format for text in column A:
Arial 10 point Normal font Right-align all four labels in the cells
4
In the Analysis by worksheet with all entries in column C: a. Enter the appropriate values for your Name, Class and Section, Project, Date Due across from the appropriate label in column A. b. Use the formatting in the Comments column
(to the right). It may be necessary to adjust the column width so the four labels are clearly visible within Column C (not
extending into Column D).
Format for text in column C:
Arial 10 point Bold Left-align all four values in the cells
Step Requirement Comments
5
a. Create four new worksheets: Data, Slide 2, Slide 3, Filter Analysis. Upon completion, there must be the Analysis by worksheet as well as the four newly created worksheets. b. Delete any other worksheets.
6
After clicking on the blank cell A1 (to select it) in the Data worksheet, import the text file spring2019rentalcars.txt into the Data worksheet. The data should begin in Column A, Row 1.It will be necessary to change Revenue data to Currency format ($ and comma (thousands separators) with NO decimal points, and to change NumCars data to number format, with NO decimal points, but with the comma (thousands separator). Note: in the Currency format there is NO space between the $ and the first numeric character that follows the $.
Though the intent is to import the text file into the Data worksheet, sometimes when text data is imported into a worksheet, a new worksheet is created. If this happens, delete the blank Data worksheet. Then change the name of the new worksheet with the imported data as Data. Make sure worksheets are n the correct order per Item 5.
Excel Capabilities for Charting Project 3 Data Worksheets
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Excel Capabilities for Charting Project 3 Data Worksheets
Excel Capabilities for Charting Project 3 Data Worksheets