Medical Plans
Aon
Stop Loss
Excel Shortcuts
Plan Features
100

What does HDHP stand for?

High Deductible Health Plan

100

Northeast Regional A&A Practice Leader

Mike Morfe

100

What does HCC stand for?

High Cost Claimant

100

ctrl X and ctrl V

cut and paste

100

This is the minimum you need to spend before the plan starts paying

Deductible

200

What type of plan could have an HSA?

HDHP

200

Aon CEO

Greg Case

200

Stop loss trends at a higher rate than typical Medical and Rx trend. What is this type of trend called?

Leveraged trend

200

What tab is opened from the command: alt h

Home

200

Claim of $2500

Deductible is $500

Coinsurance is 20%

How much does a person pay from this claim?

$900

300

What is the 2026 minimum individual deductible for an HDHP?

$1700

300

Name an exam advisor

Any of these: CJ Wolfe, Dawn Powell, Carole Raffetto, Lu Yu, Sarah Snyder

300

You have 2 claims:

$100,000

$750,000

Your ISL deductible is $350,000

What is the total reimbursement

$400,000

300

fn f4

lock the cells

300

What type of care is always fully covered prior to the deductible (think about the rows on the AV model)

Preventative Care

400

What does PPO stand for?

Preferred provider organization

400

What city is the Aon Global Headquarters in?

London

400

The ASL is 120%

Expected claims are $1,000,000

Actual claims are $1,200,000

What is the reimbursement?

0

400

Ctrl -

Deletes row
400

What is the PCORI fee for 2024?

A. 2.30

B. 3.22

C. 3.40

D. 3.47

E. 3.85


3.47

500

What plan type does not have out of network coverage?

EPO/HMO

500

Northeast Region Leader

Christine Williams

500

Name one stop loss vendor

......

500

ctrl H

find and replace

500

There is a true family deductible of $4000

Coinsurance is 20%. OOP is $10,000.

Person #1 has a $5000 claim

Person #2 has a $1500 claim

Person #3 has a $2500 claim

What is the total this family pays?


$5000