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.

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.

=IF(AND(K3>25,K4>25,K5>25,K6>25,K7>25,K8>25,K9>25,
K10>25,K11>25,K12>25,K13>25,K14>25,K15>25,K16>25,
K17>25,K18>25,K19>25,K20>25,K21>25,K22>25,K23>25,
K24>25,K25>25,K26>25,K27>25,K28>25,K29>25,K30>25,
K31>25,32>25),"Target Achieved","Taget not Achieved")



Home('Fill' tab  'Right')