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.
DOWNLOAD LINK:
==================================================================
==================================================================
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.
DOWNLOAD LINK:
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.
DOWNLOAD LINK:
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.
DOWNLOAD LINK:
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.
DOWNLOAD LINK:
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.
DOWNLOAD LINK:
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.
DOWNLOAD LINK:
==================================================================
==================================================================
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.
DOWNLOAD LINK:
==================================================================
==================================================================
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.
DOWNLOAD LINK:
==================================================================
==================================================================
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.
DOWNLOAD LINK:
==================================================================
==================================================================
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.
DOWNLOAD LINK:
==================================================================
==================================================================
0 comments:
Post a Comment