Description
Complete the file below
Unformatted Attachment Preview
Complete the following tasks:
Tasks:
1) DATABASE IMPORT:
– Delete the empty worksheet named ‘Database Completed’
– Use the Legacy Wizard to import the ‘Suppliers’ table from the Northwind Database
– The imported data should be placed on a new worksheet starting in cell A1 – name the worksheet ‘Database Completed’.
NOTES:
The ‘Northwind’ database file is available for download through the activity portal on Blackboard
The Legacy Wizards are added to the ‘Data’ ribbon using FILE –> OPTIONS –> DATA –> place check marks for each of the import wizards desired (as shown in the image to the right)
2) TEXT IMPORT:
– Delete the empty worksheet named ‘Text Completed’
– Use the ‘Get and Transform Data’ option to import the comma delimited (text) file ‘Stock Data Delimited.csv’.
– The imported data should be placed on a new worksheet starting in cell A1 – name the worksheet ‘Text Completed’.
– Do not import the file header information at the top of the text file (the Company name, author and calendar year)
– Do not import the following fields (columns): Return 2021, Return 2022, Alpha, Beta, and Premium to Nav%
NOTES:
The ‘Stock Data Delimited’ text file is available for download through the activity portal on Blackboard
93992
93992
93992
Purchase answer to see full
attachment
