Steps to complete this project:
Mark the steps as checked when you complete them.
1. Open the start file: EX2019-MOS-Ch1 If the file opens in Protected View, click the Enable Editing button in the Message Bar at the top of the file so you can modify it.
2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
3. On the Kia data worksheet, make the following modifications:
a. Autofit column I to fit the data.
b. Modify the row height of row 1 to exactly 78.
c. Apply Freeze Panes so the first row is always visible as you scroll down the worksheet.
d. Find the cell with the underhood ID MKMXV01.6J13 and apply Bold formatting. (Hint: Verify that the top row of the worksheet is no longer selected, or the Find feature may be limited to the highlighted cells.)
4. Throughout the workbook, review headers and footers and make the following modifications:
a. From Normal view, on the Kia data worksheet, add a custom header to the center section: Kia Data
b. On the 2020 Green Cars Federal worksheet, use Layout view to delete the text in the left footer section and replace it with: Source: fueleconomy.gov
c. On the 2020 Green Cars Federal worksheet, add the sheet name to the footer center section. Hint: Do not type the sheet name in the footer. Insert a code so Excel will display the name of the current worksheet.
5. On the Kia data worksheet, make the following page and print settings modifications:
a. Using Page Break Preview view, move the page break between pages one and three to before the Stnd Description column (between columns H and I).
b. Define the print area to print only the Kia Forte data (cells A1:R7).
6. On the 2020 Green Cars Federal worksheet, make the following page and print settings modifications:
a. Change the orientation to landscape.
b. Modify the scaling so all columns will fit on one page.
c. Modify the print settings to repeat row 1 at the top of every page.
d. Set the margins to the Narrow option.
e. Split the worksheet view into two vertical panes at cell H1.
7. On the Kia data worksheet, navigate to the named range Sportage_data. When you navigate to the range, Excel will highlight the range for you. Copy the data and paste starting in cell A10 on the Summary worksheet.
8. Add hyperlinks to the Summary worksheet.
a. On the Summary worksheet, insert a hyperlink in cell A1 to navigate to cell A1 on the Kia data worksheet.
b. On the Summary worksheet, insert a hyperlink in cell A2 to navigate to the web site: https://www.fueleconomy.gov/feg/download.shtml
9. On the Summary worksheet, display formulas.
10. Import from a text file.
a. Import the tab-delimited text file SmartWay Vehicle List for MY 2020.txt to a new worksheet.
b. Rename the sheet: SmartWay
11. Import from a CSV file.
a. Import the CSV file 2022 FE Guide preliminary data.csv to a new worksheet.
b. Rename the sheet: 2022 Prelim
12. Add the Quick Print option to the Quick Access Toolbar.
13. Inspect the workbook for issues and remove all document properties and personal information.
14. Modify the workbook properties to add the keyword: fuel
15. Save and close the file.
16. Upload and save your project file.
17. Submit project for grading.
18. If directed to do so by your instructor: open the workbook file and save it in the .xls format compatible with older versions of Excel. Provide this file to your instructor for additional grading.
I’ve attached an Excel file that requires some specific modifications. Please follow the steps outlined below carefully:
Skip Steps 1 and 2: There’s no need to make any changes related to these steps. You should start directly from Step 3.
Start from Step 3: Begin the work from Step 3 as outlined in the instructions. Proceed with the necessary modifications and continue working up to Step 15.
Complete Up to Step 15: After you complete the work for Step 15, please stop. Do not go beyond Step 15.
Save the file: Once you’ve completed the work, save the file with the changes.
Send the file: Finally, please send me the updated file once you’re done. If you need any clarification or additional details regarding the steps, feel free to ask.