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.
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.
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.
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.
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.
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.
Posts
No comments