Exp22_excel_ch04_cumulative – insurance claims 1.1

 Exp22_Excel_Ch04_Cumulative – Insurance Claims 1.1


Project Description:

You have been hired as a business analyst at SKV Insurance claims department. As part of your responsibilities, you have been asked to enhance the Excel workbook used to analyze the department’s performance. The workbook contains records of all claims resolved over the past year. You will convert the data to a table, format the table, sort and filter the table, insert calculations to evaluate key performance indicators, and then prepare the worksheet for printing. 


Start Excel. Download and open   the file named EXP22_Excel_Ch04_Cumulative_Insurance.xlsx.   Grader has automatically added your last name to the beginning of the   filename.


Freeze the panes so the first   row containing column headings (Row 6) and first two columns (Columns A:B) on   the InsuranceClaims worksheet will remain static when scrolling.


Convert the data to a table,   name the table InsuranceClaims, and then apply the Light Green, Table Style Light   21.


Remove duplicate records.


Add a new column to the table   named Duration.


Create a formula using   unqualified structured references to calculate the days required to resolve   the incident (Date Resolved – Date Created) and apply General Number Format.


Add a total row to display the   Average days required to complete a claim.


Sort the table by insurance   agent in alphabetic order, add a second level to sort by description, and   then create a custom sort order as follows: Natural Disaster, Flood, Fire, Theft, Accident. Add a third level to sort by duration smallest to largest.


Filter the table to only display   closed claims as indicated in the status column.


Use Quick Analysis to apply Blue   Data Bars conditional formatting to the column that contains duration. (On a   Mac use Conditional Formatting.)


Create a conditional format that   applies Red fill and White Background 1 font color to the incidents (column   B) that required 30 or more days to resolve.


Select Landscape orientation and   set appropriate margins so that the data will print on one page. Set the   print scale to 70%.


Change page breaks so each   agent’s information prints on its own page.


Set row 6 to repeat on each page   that is printed.


Save and close EXP22_Excel_CH04_Cumulative_Insurance.xlsx.   Exit Excel.

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Quality Essay Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.


Essay Writing Services

At Quality Essay Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.


Admission and Business Papers

Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.


Editing and Proofreading

Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.


Technical papers

We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.