Ifsm 201 excel project 2 pivot table

Summary Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, 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 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 2-Data.

It is a text file with the file type. Do not create your own data. You must use the data provided and only the data provided. Set Page Layout to Landscape. Change the name of the worksheet to Analysis by. It may be necessary to adjust the column width so the four labels are clearly visible. Upon completion, there should be Analysis. If necessary, reorder the four worksheets so they are in the following order: Analysis by, Data, Initial Analysis, Profit Analysis.

In the Data worksheet, import the text file Excel Project 2-Data. 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, and then. It may be necessary to change Revenue to Currency format with NO decimal points and to change NumCars to Number format with NO decimal points, because of the import operation. This may or may not occur, but in case it does it needs to be corrected.

In the Data worksheet, create an Excel table with. Pick a style with the styles group to format the table. The style should highlight the field names in the first row. Ensure NO blank spaces are part of the specified data range.

Insure the table has headers. Delete all data. There should be one row for titles and thirty-two rows of data after the data is deleted. There should be no column or data truncation.

In the Data worksheet, select the table entire table data and headers using a mouse. Copy the table to the Initial Analysis worksheet. Adjust columns widths if necessary to insure all data and field names are readable.

Copy the entire table column headings and data to the Initial Analysis worksheet. Some column adjustments may be necessary to insure the field names as well as the data is all readable. Format all data, both text and numerical content, as Arial 10 normal.

It should be located a few columns to the right of the data and begin in Row 1.

ifsm 201 excel project 2 pivot table

It should provide the combined revenue for Economy as well as Premium class cars, and display the total revenue for both Airport and Downtown locations, and include a total of all revenue for each location and each vehicle type. In the Initial Analysis worksheet, create a graph that shows the total revenue for both vehicle types at each location.Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for graphing.

The graphs 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 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 3-data. It is a text file with the file type. Set Page Layout to Landscape. Arial 10 point Bold It may be necessary to adjust the column width so the four labels are clearly visible.

Align values Right in the cell. Arial 10 point Bold b. Create three new worksheets: Data, Slide 2, Slide 3. Upon completion, there should be Analysis by as well as the three newly created worksheets. Delete any other worksheets. In the Data worksheet, import the text file Excel Project 3.

This action may not be necessary as this is part of the Excel table creation process. The data should begin in Column A. In the Data worksheet, create an Excel table with the recently imported data.

Pick a style with the styles group to format the table. The style should highlight the field names in the first row. Ensure NO blank spaces are part of the specified data range. Insure the table has headers. The resulting table should consist of Row 1labels followed by data, with NO empty cell rows within the table.

Copy the table to the both the Slide 2 as well as the Slide 3 worksheets. Adjust columns widths if necessary to insure all data and field names are readable. Create a Pivot Table that provides a quarterly breakdown columns of the number of car rentals by car class rows. Totals for rows and columns should be included. Numerical format with no decimal places and 12 Arial normal for the entire pivot table.

Place the pivot table two rows below the data beginning in column A. Create a Pivot Table that provides a quarterly breakdown columns of number the of cars rentals by location rows. Place this pivot table two rows below the above pivot table beginning in column A.To browse Academia. Skip to main content. Log In Sign Up.

This Tutorial contains following Attachments

Singht Rock. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title "Excel Project 1. 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 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. It is a text file with the file type. Do not create your own data. You must use the data provided andonlythe data provided.

Tutorials Note: Tutorials that address activities used in this project have been assigned in Week 1, 2 and 3. Open Excel and save a blank worksheet with the following name: 1 a.

Set Page Layout to Landscape 3 a.

Week One Excel Project

Place a blank row between each label. Please note the colon, : after each label. Align the labels to the right in the cell d. It may be necessary to adjust the column width so the four labels are clearly visible.

Use the formatting listed in the Comments 5. Create new worksheets: Data, Sorted, and Airport. Upon completion, there should be Analysis by as well as the three newly created worksheets. Delete any other worksheets. If necessary, reorder the four worksheets so they are in the following order: Analysis by, Data, Sorted, Airport. In the Data worksheet, import the text file Excel Project 1-Data.

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. This may or may not occur, but in case it does it needs to be corrected. In the Data worksheet, a.Notice: Welcome to our university. Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, 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 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 2-Data.

It is a text file with the file type.

ifsm 201 excel project 2 pivot table

Skip to content support royalresearchers. Sign in Login Place Order. Do not create your own data. You must use the data provided and only the data provided. Requirement a. It may be necessary to adjust the column width so the four labels are clearly visible. Upon completion, there should be Analysis by as well as the three newly created worksheets. Delete any other worksheets. If necessary, reorder the four worksheets so they are in 6 the following order: Analysis by, Data, Initial Analysis, Profit Analysis.

In the Data worksheet, import the text file Excel Project 2-Data. 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.

This may or may not occur, but in case it does it needs to be corrected. In the Data worksheet, create an Excel table with the recently imported data. Pick a style with the styles group to format the table. The style should highlight the field names in the first row. Ensure NO blank spaces are part of the specified data range. Insure the table has headers. Delete all data. There should be one row for titles and thirty-two rows of data after the data is deleted.

There should be no column or data truncation. In the Data worksheet, select the table entire table data and headers using a mouse. Copy the table to the Initial Analysis worksheet. Adjust columns widths if necessary to insure all data and field names are readable. Copy the entire table column headings and data to the Initial Analysis worksheet.

Some column 10 adjustments may be necessary to insure the field names as well as the data is all readable. Format all data, both text and numerical content, as Arial 10 normal 11 a. In the Initial Analysis worksheet, using the table just copied there, create a Pivot Table.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. 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 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. It is a text file with the file type. Do not create your own data. You must use the data provided andonlythe data provided. Tutorials Note: Tutorials that address activities used in this project have been assigned in Week 1, 2 and 3.

It may be necessary to adjust the column width so the four labels are clearly visible. Sorted, and Airport. Upon completion, there should be Analysis by as well as the three newly created worksheets.

If necessary, reorder the four worksheets so they are in the following order: Analysis by, Data, Sorted, Airport. In the Data worksheet, import the text file Excel Project 1-Data. 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.

It may be necessary to change Revenue to Currency format with NO decimal points and to change NumCars to numerical format, with no decimal points, as a result of the import operation.

ifsm 201 excel project 2 pivot table

This may or may not occur, but in case it does it needs to be corrected. In the Data worksheet, a. Some column adjustments may be necessary to insure the field names as well as the data is all readable. No credit will be awarded if anything other than AE as the function range is used instead of the named range. Use the formatting instructions in the Comments.Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, graphing, and written analysis and recommendations in support of a business enterprise.

ifsm 201 excel project 2 pivot table

A large rental car company has two metropolitan locations, one at the airport and another centrally located in downtown. It has been operating since 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 2-Data. It is a text file with the file type.

Do not create your own data. You must use the data provided and only the data provided. Open Excel and save a blank worksheet with the. Example: JSmith Excel Project 2. Set Page Layout to Landscape. In the Analysis by worksheet, enter the four labels. It may be necessary to adjust the column width so the. In the Analysis by worksheet, with all entries in. Class and Section, Project, Date Due. It may be necessary to adjust the column width so. Upon completion, there should be Analysis.

This Tutorial contains following Attachments

Delete any other worksheets. If necessary, reorder the four worksheets so they are in. Analysis, Profit Analysis. In the Data worksheet, import the text file Excel. Project 2-Data. Though the intent is to import the text file into the Data. If this. NO decimal points, because of the import operation.

UMUC IFSM 201 Excel Project 2

This may or may not occur, but in case it does it needs. In the Data worksheet, create an Excel table with. Pick a style with the. Ensure NO blank spaces are part of the specified.

Insure the table has headers. Do NOT check. Delete all data. There should be one row for. There should be no column or data truncation. In the Data worksheet, select the table entire table. Copy the table to the Initial Analysis worksheet. Adjust columns widths if necessary to insure all. Copy the entire table column headings and data to. Some column.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 2. Click on Show Rubrics if the rubric is not already displayed. Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, 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 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 2-Data.

It is a text file with the file type. Do not create your own data. You must use the data provided and only the data provided. Points Allocated. Set Page Layout to Landscape. Use Print Preview to review how spreadsheet would print. Change the name of the worksheet to Analysis by. It may be necessary to adjust the column width so the four labels are clearly visible.

Use the following text format:. Arial 10 point. Align values Right in the cell. Align values left in the cells. Upon completion, there should be Analysis by as well as the three newly created worksheets. Delete any other worksheets. We promise to never spam you, and just use your email address to identify you as a valid customer.

This product hasn't received any reviews yet. Be the first to review this product! All prices are in USD. Sitemap Powered by BigCommerce.

Categories Order a paper. Additional Information Home Custom work request Welcome! Contact Us. Site Information. Please wait


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *