1.Consider the scenario of MultiTech Software Solutions Inc. Jason, the HR Manager, is recording
the employee details in a Microsoft Excel worksheet. Jason wants to arrange the details in such a
way that the department names, along with the names of the employees in each department, are
arranged in an alphabetical order. You need to help Jason to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbSE5kZ2pHaTdKT0E
2.. Consider the scenario of University of Minnesota. The university is conducting an entrance examination for the various courses offered by the university. It has received a large number of applications for the entrance test. John, the Examination Controller, records all the applicants' details in a worksheet. To generate the admit cards and the entrance ids for the students, John is required to arrange the data by ordering the names of applicants in an alphabetical order. You need to help John to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbQzFiTnl6ZmVPRDg
3.. Consider the scenario of Posco Supermart Inc. The company records all its current year sales details in a Microsoft Excel worksheet for different regions in the world, where each region consists of a number of countries. To calculate the total sales of all the regions, Patrick, the Sales Manager at the head office in Colorado, is required to calculate the total sales of each region separately. This wastes his time. You are required to help Patrick to find the total sales of all the regions by assigning a combined name to the countries in each region. Thereafter, calculate the total sales by using the assigned names of these regions.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbX21qbFhHT19rZG8
4..Consider the scenario of Hilton Finance Services. The company maintains all its employee details in a Microsoft Excel worksheet. Jose, the HR Executive, wants to view the details of the employees working in the Finance department. You are required to help Jose to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbMURaUFBQb19BVzA
5.Consider the scenario of Jenson Powers, which is a leading company for electrical products in US. The sales report of the first quarter is created by the Sales Officer, Mark. In the sales report, Mark wants that the sales values above $ 1,000,000 should be colored red and displayed in a bold format. You need to help Mark to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdGZfdkNiS0h6a3M
6..Consider the scenario of Highland Blue Florist, which is owned by Bailey. The flower store is famous among people in the town for its variety of flowers. Bailey has recorded the details of all the flowers in a Microsoft Excel worksheet. A customer wants to buy some orchids and asks for the details of different types of orchids that are available in the store. To look for the variety of orchids, Bailey is required to check each and every entry. This will waste a lot of his time. Therefore, he is required to apply some method, which will enable him to highlight the details of orchids. You need to help Bailey, so that he can find all the types of orchids in a more convenient manner.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbbTlWSFZhWVNNMnc
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbSE5kZ2pHaTdKT0E
2.. Consider the scenario of University of Minnesota. The university is conducting an entrance examination for the various courses offered by the university. It has received a large number of applications for the entrance test. John, the Examination Controller, records all the applicants' details in a worksheet. To generate the admit cards and the entrance ids for the students, John is required to arrange the data by ordering the names of applicants in an alphabetical order. You need to help John to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbQzFiTnl6ZmVPRDg
3.. Consider the scenario of Posco Supermart Inc. The company records all its current year sales details in a Microsoft Excel worksheet for different regions in the world, where each region consists of a number of countries. To calculate the total sales of all the regions, Patrick, the Sales Manager at the head office in Colorado, is required to calculate the total sales of each region separately. This wastes his time. You are required to help Patrick to find the total sales of all the regions by assigning a combined name to the countries in each region. Thereafter, calculate the total sales by using the assigned names of these regions.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbX21qbFhHT19rZG8
4..Consider the scenario of Hilton Finance Services. The company maintains all its employee details in a Microsoft Excel worksheet. Jose, the HR Executive, wants to view the details of the employees working in the Finance department. You are required to help Jose to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbMURaUFBQb19BVzA
5.Consider the scenario of Jenson Powers, which is a leading company for electrical products in US. The sales report of the first quarter is created by the Sales Officer, Mark. In the sales report, Mark wants that the sales values above $ 1,000,000 should be colored red and displayed in a bold format. You need to help Mark to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbdGZfdkNiS0h6a3M
6..Consider the scenario of Highland Blue Florist, which is owned by Bailey. The flower store is famous among people in the town for its variety of flowers. Bailey has recorded the details of all the flowers in a Microsoft Excel worksheet. A customer wants to buy some orchids and asks for the details of different types of orchids that are available in the store. To look for the variety of orchids, Bailey is required to check each and every entry. This will waste a lot of his time. Therefore, he is required to apply some method, which will enable him to highlight the details of orchids. You need to help Bailey, so that he can find all the types of orchids in a more convenient manner.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbbTlWSFZhWVNNMnc
No comments:
Post a Comment