1. Andy invested his money in gold. For this purpose, he checks the rise and fall in the prices of the
gold each day. He finds that the price of the gold changes in very frequently. He wants to record
the changes in the price in each trading session in order to analyze the trend in the market. He
finds a website, which displays the gold price for trading sessions. He wants import the data in the
Microsoft Excel worksheet in order to know the rise and fall in the gold prices. Help Andy to load
the data from internet to the worksheet.
Note: To perform the exercise, you need to use the website address,
http://www.londonstockexchange.com/exchange/prices-and-markets/stocks/summary/companysummary.html?fourWayKey=IE00B4XVDC01IEGBXASQ1
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdWI3Z3poQ0hscUE
2. Blue Moon Inc. manufactures computer peripherals across South Dakota. Jane, the Senior HR Manager, needs to assign the task of calculating the salary components for employees to newly hired executives. She decides to share an Excel workbook with the details for calculating the salary. In this worksheet, Jane wants that the executives are able to change the CTC of the employees and remaining cells can be changed only by the HR Manager. Help Jane to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTDJvZ0tiSGpreGc
3. Blue Moon Inc. manufactures computer peripherals across South Dakota. Jane, the Senior HR Manager, needs to assign the task of calculating the salary components for employees to newly hired executives. She decides to share an Excel workbook with the details for calculating the salary. In this worksheet, Jane wants that the executives are able to change the CTC of the employees and remaining cells can be changed only by the HR Manager. Help Jane to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbNUpQeUxXNnMzQm8
4. Global Soccer Federation (GSF) handles all the soccer leagues organized in the US. The GSF annually organizes the National Cup Soccer League. For this, they need the data for all the teams participating in the league. The federation asks Melisa, the Sports Manager, to create a template in an Excel workbook to consolidate this data into a single file. Melisa decides to create multiple copies of the template file and distribute those files to every Club Manager. In addition, she wants every Manager to add details in the le and rename the version of the le with the team name. Thereafter, they need to send those files back to Melisa. Help Melisa and Club Managers to accomplish the required task.
Ans. https://drive.google.com/open?id=0B-yL1mP3zqTbNHJST2FFaDBwNnM
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdWI3Z3poQ0hscUE
2. Blue Moon Inc. manufactures computer peripherals across South Dakota. Jane, the Senior HR Manager, needs to assign the task of calculating the salary components for employees to newly hired executives. She decides to share an Excel workbook with the details for calculating the salary. In this worksheet, Jane wants that the executives are able to change the CTC of the employees and remaining cells can be changed only by the HR Manager. Help Jane to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTDJvZ0tiSGpreGc
3. Blue Moon Inc. manufactures computer peripherals across South Dakota. Jane, the Senior HR Manager, needs to assign the task of calculating the salary components for employees to newly hired executives. She decides to share an Excel workbook with the details for calculating the salary. In this worksheet, Jane wants that the executives are able to change the CTC of the employees and remaining cells can be changed only by the HR Manager. Help Jane to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbNUpQeUxXNnMzQm8
4. Global Soccer Federation (GSF) handles all the soccer leagues organized in the US. The GSF annually organizes the National Cup Soccer League. For this, they need the data for all the teams participating in the league. The federation asks Melisa, the Sports Manager, to create a template in an Excel workbook to consolidate this data into a single file. Melisa decides to create multiple copies of the template file and distribute those files to every Club Manager. In addition, she wants every Manager to add details in the le and rename the version of the le with the team name. Thereafter, they need to send those files back to Melisa. Help Melisa and Club Managers to accomplish the required task.
Ans. https://drive.google.com/open?id=0B-yL1mP3zqTbNHJST2FFaDBwNnM
No comments:
Post a Comment