Use the Create from Selection command to create named ranges for the selected data table in cells B2:E6 using the labels in row 1 as the basis for the names. T1 Font Size 1 53:41 1 of 2 Attempts XE AutoSave Off Salaries - Saved Search (Alt+Q) Ken Dishner KD X File Home Insert Draw Page Layout Formulas Data Review View Automate Comments Share v X Arial 10 A ab General Insert . E . AY O $ - % " Conditional Format Cell Ex Delete . Sort Find Analyze Sensitivity Add-ins Paste B 60 .00 Formatting . as Table . Styles . Format . Filter . Select . Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Add-ins B1 X V fx Year 1 B C D E F G H K L M N P Ben Delbow 65,000 $ 67,600 $ 70,304 $ 73,116 Dr. Patella 115,000 $ 119,600 $ 124,384 $ 129,359 John Patterson 105,000 | $ 109,200 | $ 113,568 | $ 118,111 Total Gross Salaries $ 380,000| $ 395,200 $ 411,008 $ 427,448 9 COLA 4% 10 11 12 Salaries + D