Please help me transfer this data unto a excel spreadsheet.
Please help me transfer this data unto a excel spreadsheet.
Use the project description HERE to complete this activity. For a review of the complete rubric used ingrading this exercise, click on the Assignments tab, then on the titleExcel Project 2.Click on ShowRubrics if the rubric is not already displayed.SummaryCreate a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilitiesincluding creating a pivot table, graphing, and written analysis and recommendations in support of abusiness enterprise.A large rental car company has two metropolitan locations, one at the airport and another centrallylocated in downtown. It has been operating since 2015 and each location summarizes its car rentalrevenue quarterly. Both locations rent two classes of cars: economy and premium. Rental revenue ismaintained separately for the two classes of rental vehicles.The data for this case resides in the file Excel Project 2-Data.txt and can be downloaded by clickingon the Assignments tab, then on the data tile name. It is a text file with the file type .txt).Do notcreate your own data. You must use the data provided and only the data provided.RequirementPointsAllocatedComments1a.Open Excel and save a blank worksheet with thefollowing name:“Student’s First InitialLast Name Excel Project 2”Example: JSmith Excel Project 2b.Set Page Layout to Landscape0.1Use Print Preview toreview howspreadsheet wouldprint.2Change the name of the worksheet toAnalysis by.0.13In theAnalysis byworksheet, enter the four labelsvertically in column A in the following order: Name:,Class/Section:, Project:, Date Due: with a row betweeneach label, please note the colon, : , after each label.It may be necessary to adjust the column width so thefour labels are clearly visible.0.1Use the followingtext format:Arial 10 pointAlign values Right inthe cell4a. In theAnalysis byworksheet,with all entries incolumn C, enter the appropriate values for Name,Class and Section, Project, Date Due.b. It may be necessary to adjust the column width sothe four labels are clearly visible.0.2Use the followingtext format:Arial 10 pointBoldAlign values left inthe cells5Create new worksheets:Data, Initial Analysis, ProfitAnalysis. Upon completion, there should be Analysisby as well as the three newly created worksheets.Delete any other worksheets.0.3
6If necessary, reorder the four worksheets so they are inthe following order:Analysis by, Data, InitialAnalysis, Profit Analysis.0.37In theDataworksheet, import the text fileExcelProject 2-Data.txt.Though the intent is to import the text file into the Dataworksheet, sometimes when text data is imported intoa worksheet, a new worksheet is created.If thishappens, delete the blank Data worksheet, and thenrename the new worksheet which HAS the recentlyimported data as “Data.”It may be necessary tochange Revenue to Currency format with NO decimalpoints and to change NumCars to Number format withNO decimal points, because of the import operation.This may or may not occur, but in case it does it needsto be corrected.0.4The field namesshould be in the toprow of the worksheetwith the data directlyunder it in rows. Thisaction may not benecessary as this ispart of the Exceltable creationprocess. The datashould begin inColumn A.8a. In theDataworksheet, create an Excel table withthe recently imported data. Pick a style with thestyles group to format the table. The style shouldhighlight the field names in the first row.b. Ensure NO blank spaces are part of the specifieddata range. Insure the table has headers. Insurethat Header Row and Banded Rows are selected inthe Table Style Options Group Box. Do NOT checkthe Total Row.c.Delete all 2017 data.There should be one row fortitles and thirty-two rows of data after the 2017 datais deleted.d. There should be no column or data truncation.0.5Some adjustmentmay be necessary tocolumn widths toinsure all field namesand all data arereadable (nottruncated orobscured).9In theDataworksheet, select the table entire table(data and headers) using a mouse.a. Copy the table to theInitial Analysisworksheet.The upper left hand corner of the header/datashould be in cell A1.b. Adjust columns widths if necessary to insure alldata and field names are readable.0.210a. Copy the entire table (column headings and data) totheInitial Analysisworksheet. Some columnadjustments may be necessary to insure the fieldnames as well as the data is all readable.b. Format all data, both text and numerical content, asArial 10 normal0.2The upper left handcorner of the tableshould be in cell A1of the Sortedworksheet.11a. In theInitial Analysisworksheet, using the tablejust copied there, create a Pivot Table.0.8There should be NO2017 data on the
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
