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