ADVANCED EXCEL LAB @ HOME 3

NOTE: ALL THE ANSWERS ARE IN ZIP FORMAT.

             DIRECT DOWNLOAD FROM LINKS.

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:

CLICK HERE

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: 

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE

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:

CLICK HERE