Tuesday 26 January 2016

ADVANCED EXCEL LAB @ HOME 7

1.

  Consider the scenario of PureDrink Inc., which is a leading organization in manufacturing 
soft drinks, and has its head quarter in Los Angles. The organization manufactures various 
soft drink products, such as Liquid Mango, Tangy Orange, Strawberry Twirl, and Aqua Clear. 
Keith is the Sales Manager of the organization, and develops the sales strategies. Recently, 
Keith has observed a huge decline in the demand of all the soft drink products. Therefore, 
he decides to analyze the sales data of soft drinks for the last one year to check the fluctuation 
in the sales data whether there is a frequent decline or it just depends on the seasonal 
requirements. He has to present this data to the board members. Therefore, he decides to 
present the sales report with graphical representation. Help Keith to create the sales report 
with graphical representations.


ANS: 

CLICK HERE




2.
  Consider the scenario of Global Fertilizers Inc., which is a leading organization in 

manufacturing fertilizers in the U.S. Mark is the Chief Operations Officer of the organization. 
Mark has to calculate the budget for the production of fertilizers for the next financial quarter. 
However, before making the budget report he wants to analyze the budget trend, which was 
spent on the production of fertilizers in the financial year, 2009. Thereafter, he will predict the 
budget expense for the next financial quarter, based on this budget trend report. He assigns 
this task to Garry who is a Sales Executive. Help Garry to create the budget trend report.



ANS: 

CLICK HERE



3.
   Peter wants to build a house. The total estimated expense of constructing the house is 

$ 20,000. He is having a savings of $ 5,000, and he is looking for a loan amount of $ 15,000. 
For this, he wants to take a home loan from the bank, Home Finance. The bank 
representative has told him that the loan amount will be sanctioned at an interest rate of 
12% per annum for a period of 45 months, which makes a repayment of $ 416 per month. 
When Peter calculated the total amount, which he will be repaying in 45 months, he got 
$ 18,700 as the result. Now, Peter wants to increase the number of repayment periods as he
would not be able to pay $ 416 per month. However, he does not want to increase the total 
repaid amount more than $ 20,000. He needs a solution for this. Help Peter to find the solution.


ANS: 

CLICK HERE


4.
   
Consider the scenario of Alpha Supermart. Harry, the HR Manager, asks Callie, the HR 

Executive, to generate payroll reports for the last quarter. For this, Callie decides to store 
the payroll details of each month in a separate worksheet in a workbook. In addition, she 
wants that the appearance of all the worksheets should be similar. Therefore, Callie decides 
to implement the following formatting conventions in all the worksheets in the workbook:
The font color, font size, and background color of the cell containing the title should be Red, 

20, and Light Green, respectively.
The column headings should be bold and italicized.
The background color of the column headings should be Red, Accent 2, Lighter 60%.
The background color the cells containing the payroll values should be Orange, Accent 6, 

Lighter 40%.
It becomes a tedious task to follow the preceding formatting standards while creating 

payroll reports. Therefore, Callie decides to capture the actions while formatting the first 
worksheet, and to apply these captured actions on the remaining worksheets. You need 
to help Callie in accomplishing the required tasks.


ANS: 

CLICK HERE



5.
    Consider the scenario of Alpha Supermart. Callie created a macro to apply the common 

set of formatting standards on the payroll reports. However, now, she needs to change all 
the formatting standards according to the feedback given by Harry. To accomplish this, 
Callie needs to record a fresh macro. However, before recording the new macro, she wants 
to remove the existing macro. You need to help Callie for removing the macro.


ANS: 

CLICK HERE




6.
    
Consider the scenario of Alpha Supermart. Harry asks Callie to perform the following 

modifications to improve the visual appearance of the payroll reports:
The font size of the cell containing the title in the worksheets should be 22.
The column headings in the worksheets should not be italicized.
The font size of the column headings should be 14.
The font size of the payroll values should be 12.
Help Callie in accomplishing the required tasks.



 ANS:  

CLICK HERE

No comments:

Post a Comment