ADVANCED EXCEL LAB @ 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 the 
employees. Help Warren to accomplish the task.


ANS:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE