I have been trying to upload the attached documents but the site is not letting me do it
I have been trying to upload the attached documents but the site is
not letting me do it. It says that it has already been uploaded. I need help with this assignment. thanks.
Excel Project 1 – MS ExcelUse the project description HERE to complete this activity. For a review of the complete rubric used in gradingthis exercise, click on the Assignments tab, then on the title “Excel Project 1.” Click on Show Rubrics if therubric is not already displayed.SummaryCreate a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities includinggraphing, 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 indowntown. It has been operating since 2015 and each location summarizes its car rental revenuequarterly. Both locations rent two classes of cars: economy and premium. Rental revenue is maintainedseparately for the two classes of rental vehicles.The data for this case resides in the fileExcel Project 1-Data.txtand can be downloaded by clicking on theAssignments 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.TutorialsNote: Tutorials that address activities used in this project have been assigned in Week 1, 2 and 3.RequirementPointsAllocatedComments1Open Excel and save a blank worksheet with the followingname:a. “Student’s First InitialLast Name Excel Project 1”Example: JSmith Excel Project 1.b. Set Page Layout to Landscape0.2Use Print Preview to reviewhow spreadsheet wouldprint.2a. Change the name of the worksheet toAnalysis by.0.13a. In theAnalysis byworksheet, enter the four labelsvertically in column A in the following order: Name:,Class/Section:, Project:, Date Due:b. Place a blank row between each label. Please notethe colon, (:) after each label.c. Align the labels to the right in the celld. It may be necessary to adjust the column width sothe four labels are clearly visible.0.3Use the following textformat:Arial 10 pointBoldAlign values Right in thecell4a. 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.c. Use the formatting listed in theComments0.3Use the following textformat:Arial 10 pointBoldAlign values left in the cells
RequirementPointsAllocatedComments5a. Create new worksheets:Data,Sorted,andAirport.Upon completion, thereshould beAnalysis byas well as the three newlycreated worksheets.b. Delete any other worksheets.0.26a. If necessary, reorder the four worksheets so theyare in the following order:Analysis by, Data,Sorted, Airport.0.17In theDataworksheet,import the text fileExcel Project 1-Data.txt.Though the intent is to import the text file into the Dataworksheet, sometimes when text data is imported into aworksheet, a new worksheet is created. If this happens,delete the blank Data worksheet, and then rename the newworksheet which HAS the recently imported data as“Data.” It may be necessary to change Revenue toCurrency format with NO decimal points and to changeNumCars tonumerical format, with no decimal points, as aresult of the import operation.This may or may not occur, but in case it does it needs tobe corrected.0.5Format all data (fieldnames and numbers) toArial 10 point.The field names should bein the top row of theworksheet with the datadirectly under it in rows.This action may not benecessary as this is part ofthe Excel table creationprocess. The data shouldbegin in Column A.8In theDataworksheet,a. create an Exceltablewith the recently importeddata.b. Pick a style with the styles group to format the table,c. The style should highlight the field names in the firstrow.d. Ensure NO blank spaces are part of the specifieddata range. Insure the table has headers.e. Insure that Header Row and Banded Rows areselected in the Table Style Options Group Box.0.6Some adjustment may benecessary to columnwidths to insure all fieldnames and all data arereadable (not truncated orobscured).9In theDataworksheet,a. select the entire table (data and headers) using amouse.b. Copy the table to theSortedworksheet.c. The upper left hand corner of the header/datainSortedshould be in cell A1.d. Adjust columns widths if necessary to insure all dataand field names are readable.0.410In theSortedworksheet,a. sort the data by location (ascending)b. (All cells with data in the table should be selected)0.2Insure all the table isselected, NOT just thelocation column.11a. Copy the entire table from theSortedworksheet totheAirportworksheet.b. Some column adjustments may be necessary toinsure the field names as well as the data is allreadable.0.2Insure all cells with dataare selected.12In theAirportworksheet,0.3
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
