Generate a report that summarizes the existing balances

Reference no: EM132264044

Assignment -

In the Lab - Design, create, modify, and/or use a workbook following the guidelines, concepts, and skills presented in this module.

Lab - Insurance Premium Worksheet

Problem - You are a part-time assistant in the accounting department at Aylin Insurance, an Orlando-based insurance company. You have been asked to use Excel to generate a report that summarizes the existing balances on annual premiums, similar to the one shown in Figure (see in attached file).

Include the three columns of customer data in Table in the report, plus two additional columns to compute a monthly fee and a current balance for each customer. Assume no negative unpaid monthly balances.

Table - Aylin Insurance Premium Data
Customer	Previous Balance	Payments
Albasco, Robin	1600.72	72.15
Deon, Jade	1518.62	382.3
Goodman, Brad	679.29	80.69
Hill, Raine	1060.42	107.6
Klonde, Albert	1178.83	125.63
Lang, Rose	1280.2	79.85
Moore, Jeffrey	1253.88	389.79
Piper, Taylor	477.11	278.52
Sothens, Mary	821.31	153.14

Perform the following tasks -

1. Enter and format the worksheet title Aylin Insurance and worksheet subtitle Premium Analysis in cells A1 and A2. Change the theme of the worksheet to the Berlin theme. Apply the Title cell style to cells A1 and A2. Change the font size in cell A1 to 26 points, and change the font size in cell A2 to 18 points. Merge and center the worksheet title and subtitle across columns A through E. Draw a thick outside border around the range A1:A2.

2. Change the width of column A to 20.00 points. Change the widths of columns B through E to 14.00 points. Change the heights of row 3 to 36.00 points and row 14 to 25.50 points.

Attachment:- Assignment File.rar

Reference no: EM132264044

Questions Cloud

How quickly and in what way the sales staff will respond : BAA514 : How you will ensure that the products they receive will be of the highest quality and delivered in the timeframe agreed;

What are the different roles that project managers : What are the different roles that project managers can play in organizational leadership.

Context free gramamr in chomsky : Show that if G is a Context Free Gramamr in Chomsky normal form, then for any string ?? L(G), |?|=n=1, then exactly 2n-1 steps are required for anyderivation of

Calculate the expected rate of return : Calculate the expected rate of return, variance of the asset, and decompose the asset into a sum of a forward portfolio and a non-systematic risk

Generate a report that summarizes the existing balances : Use Excel to generate a report that summarizes the existing balances on annual premiums, similar to the one shown in Figure

List the total ascending : List the total ascending. You will be using AdventureWorks Database. (Your results window should have 351 rows)

Discuss why the type of methodology employed should be drive : Discuss why the type of methodology employed should be driven by the research questions rather than being selected because of preconceived notions.

Should the law allow an employer to fire an employee : Should the law allow an employer to fire an employee without a good reason? Conduct research to provide examples to support your position and use your own.

App feature of attaching video : A company copying the tenor app feature of attaching video gif files with standard emoticons, would be any potential problem? Explain

User Account

All Pages