1. Consider the scenario of the Felocity chartered account services. The company handles the tax
returns of its clients. Shaun, the Accounts Officer, wants to calculate the amount of tax that the
clients are required to pay. Therefore, he prepares a worksheet to calculate the tax. He wants to
ensure the following options:
*Cells containing the income of the client should contain the decimal value greater than zero.
*Cells containing the phone number should have 10 digits.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZFhNTnBSckJZV28
2. Consider the scenario of TabiscoInfotech. Warren, the HR Manager, wants to see the overall performance of allthe employees. For this, the company has a performance measurement methodology,wherein, certain scores are assigned to employees based on their performance.These scores are recorded in a Microsoft Excel worksheet. Warren wants to knowabout those employees, who have scored less than the average scores of all theemployees. Help Warren to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbQmxTN0otTURZUkU
3. Sam wants to invest an amount, which will fetch him $ 200,000 after 12 years at an annual interest of 9%. Sam wants to know how much amount should be invested today, so that he gets a future value of $ 200,000. You are required to help Sam to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTS1wSVFKYzd2anM
4. Sean wants to plan an investment. For this, he plans to invest $ 500 in a fixed deposit every month for 10 years in a bank. The bank provides 8% annual interest on the fixed deposit. Sean wants to calculate how much amount he would get at the end of the tenth year. Help Sean to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbeE1obnNPVmk3T1k
5.Consider the scenario of Benson &Hedges Technosoft, which is a software solution company headquartered in the US.Gerard, the Sales Manager at the head office, receives the sales details of theyear 2011, which are recorded in a Microsoft Excel worksheet, from one of theoffices located in Europe. He finds that some sale dates data has year as 2012.He wants to check all the dates, which are entered incorrectly in the salesreport. You are required to help Gerard to find all the incorrect dates.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbVTMxY1JiMHRkWk0
6. Consider a scenario of MSP Telecom BPO,which works for its clients to sell their products. Linda, the Project Manager,is currently handling a project to sell the electronic products of KGElectronics. Currently, there are 10 members working for this project underLinda. Each member is required to sell 25 products at the end of each day.Linda maintains a Microsoft Excel worksheet to record the daily sales of eachteam member. At the end of the month, she wants to know whether the teammembers have achieved their daily targets. You are required to help Linda toaccomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZ0tQeUxjaW5QMnc
*Cells containing the income of the client should contain the decimal value greater than zero.
*Cells containing the phone number should have 10 digits.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZFhNTnBSckJZV28
2. Consider the scenario of TabiscoInfotech. Warren, the HR Manager, wants to see the overall performance of allthe employees. For this, the company has a performance measurement methodology,wherein, certain scores are assigned to employees based on their performance.These scores are recorded in a Microsoft Excel worksheet. Warren wants to knowabout those employees, who have scored less than the average scores of all theemployees. Help Warren to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbQmxTN0otTURZUkU
3. Sam wants to invest an amount, which will fetch him $ 200,000 after 12 years at an annual interest of 9%. Sam wants to know how much amount should be invested today, so that he gets a future value of $ 200,000. You are required to help Sam to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbTS1wSVFKYzd2anM
4. Sean wants to plan an investment. For this, he plans to invest $ 500 in a fixed deposit every month for 10 years in a bank. The bank provides 8% annual interest on the fixed deposit. Sean wants to calculate how much amount he would get at the end of the tenth year. Help Sean to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbeE1obnNPVmk3T1k
5.Consider the scenario of Benson &Hedges Technosoft, which is a software solution company headquartered in the US.Gerard, the Sales Manager at the head office, receives the sales details of theyear 2011, which are recorded in a Microsoft Excel worksheet, from one of theoffices located in Europe. He finds that some sale dates data has year as 2012.He wants to check all the dates, which are entered incorrectly in the salesreport. You are required to help Gerard to find all the incorrect dates.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbVTMxY1JiMHRkWk0
6. Consider a scenario of MSP Telecom BPO,which works for its clients to sell their products. Linda, the Project Manager,is currently handling a project to sell the electronic products of KGElectronics. Currently, there are 10 members working for this project underLinda. Each member is required to sell 25 products at the end of each day.Linda maintains a Microsoft Excel worksheet to record the daily sales of eachteam member. At the end of the month, she wants to know whether the teammembers have achieved their daily targets. You are required to help Linda toaccomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZ0tQeUxjaW5QMnc
No comments:
Post a Comment