Question: Please answer 1a-1c using the information given. Use Excel to answer 1a-1c. A global finance company is currently evaluating the possibility of using online spreadsheet


Please answer 1a-1c using the information given. Use Excel to answer 1a-1c.
A global finance company is currently evaluating the possibility of using online spreadsheet software as opposed to the traditional locally installed spreadsheet application. The company wants you to investigate the possibilities that are currently available while also paying special attention to the company requirements. The company has the following requirements: a. The ability to share spreadsheets easily between employees b. The ability to share spreadsheets easily between customers C. The ability to secure this information via encryption, passwords, virtual private networks, etc. d. The ability to save the spreadsheets into other formats (i.e. CSV files) e. The ability to import/export data in various formats (i.e. CSV files) f. The ability to work on the spreadsheet from anywhere in the world g. The resources to train and provide "how to" material to the employees h. The ability to use the spreadsheet software in multiple currencies i. The ability to display the data in the spreadsheet into visualizations (i.e. graphs) # Item 1a Research and identify different options for online (select 2) and traditional (select 2) spreadsheets and list the available options. 1b Using the finance company requirements, create a table identifying the pros and cons for each spreadsheet option. **Note, it helps to give numerical ratings (i.e. 1 to 10) for the company requirements (a to i) versus qualitative (i.e. poor, good, best) to be able to assess the items quantitatively. 10 Summarize the findings and present your findings with a minimum of 2 graphs. Provide a recommendation to the company. A global finance company is currently evaluating the possibility of using online spreadsheet software as opposed to the traditional locally installed spreadsheet application. The company wants you to investigate the possibilities that are currently available while also paying special attention to the company requirements. The company has the following requirements: a. The ability to share spreadsheets easily between employees b. The ability to share spreadsheets easily between customers C. The ability to secure this information via encryption, passwords, virtual private networks, etc. d. The ability to save the spreadsheets into other formats (i.e. CSV files) e. The ability to import/export data in various formats (i.e. CSV files) f. The ability to work on the spreadsheet from anywhere in the world g. The resources to train and provide "how to" material to the employees h. The ability to use the spreadsheet software in multiple currencies i. The ability to display the data in the spreadsheet into visualizations (i.e. graphs) # Item 1a Research and identify different options for online (select 2) and traditional (select 2) spreadsheets and list the available options. 1b Using the finance company requirements, create a table identifying the pros and cons for each spreadsheet option. **Note, it helps to give numerical ratings (i.e. 1 to 10) for the company requirements (a to i) versus qualitative (i.e. poor, good, best) to be able to assess the items quantitatively. 10 Summarize the findings and present your findings with a minimum of 2 graphs. Provide a recommendation to the company
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
