Part 1 – Create your file and Import your data
- Start Excel creating a new Blank workbook using Excel 2016 or 2019
- Save the file with the Name farah.kazazzi_Excel_Exam2
- Files created in older versions of Excel may not earn full credit!
- Enter the appropriate Excel header and footer elements in the locations below. The only part you should type is your name.
- Left Click the link below to create your file.
- A download link will appear after you click the link and your file has been created. By clicking Create My Data File the button below you agree to follow the guidelines for this assignment.
– Click once
- A download link will appear after you click the link and your file has been created. By clicking Create My Data File the button below you agree to follow the guidelines for this assignment.
- Import the data file that you downloaded and add 2 rows
- The file is a Comma Delimited file so be sure to select that option during the import.
- Use the Load To option in the import wizard and load the data into cell A3.
- Use the Convert to Range option, in Table Design tab, to convert the table to a range.
- At this point your file should look something similar to this image with 417 rows of data and rows 1 & 2 are empty.
- Add 3 document properties via the Document Properties panel.
- Author: farah.kazazzi
- Title: Exam 2 Spring 2021
- Comments: location where you completed the exam i.e Home System, Work Computer
- Save the file with the name _Excel_Exam2.xlsx


0 comments