1. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbY3lyVlJHdHBlSmc
2. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbTDQzQnZJOFlXMnc
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 https://drive.google.com/open?id=0B-yL1mP3zqTbUEY5R0ZKWUJwWms
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 https://drive.google.com/open?id=0B-yL1mP3zqTbODNBVXhCd1FQcVE
5. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbaERSN2psTlhyUWc
6. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbZWVtdEkteEUtbHM
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbY3lyVlJHdHBlSmc
2. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbTDQzQnZJOFlXMnc
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 https://drive.google.com/open?id=0B-yL1mP3zqTbUEY5R0ZKWUJwWms
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 https://drive.google.com/open?id=0B-yL1mP3zqTbODNBVXhCd1FQcVE
5. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbaERSN2psTlhyUWc
6. 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 https://drive.google.com/open?id=0B-yL1mP3zqTbZWVtdEkteEUtbHM
No comments:
Post a Comment