Advanced Excel Lab At home 4
1.
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:
2.
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:
3.
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:
4.
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:
5.
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:
6.
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:
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:
2.
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.
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:
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:
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:
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:
Posts
No comments