Calibrl (Body) 11 General Paste Conditional Format Cell Formatting as Table Styles Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left oft? B C D H M 1 2 Year Financial Ald PELL SEOG PERKINS INST AID SEIG Amount 2004 2013 2009 2010 2010 7 30 11 12 13 4 15 16 17 In cell 4 place the appropriate function(s) to retrieve the appropriate amount from the table on sheet "Prob Infobased on the financial aid and year provided. Copy this function down through cell H. You will need to create range names and you may use working columns, if desired (10 points 39 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 29 40 Prob 2 Prob 2 Info Proba Prob Prob Probo Prob 7 Prod 7 Info Proba Probe D E F G Year Financial Aid PELL SEOG PERKINS INST AID SEIG Amount 2004 2013 2009 2010 2010 In cell H4 place the appropriate function(s) to retrieve the appropriate amount from the table on sheet "Prob 7 Info" based on the financial aid and year provided. Copy this function down through cell H8. You will need to create range names and you may use working columns, if desired. (10 points) Do Not Hord code Plecese Show work Save Final Insert Draw Page Layout Formulas Data Review View Tell me 1 Trick Kilis Erectile D searchstartnow.com Wives Are Speechless Arial - A A 10 === General BI 19 $% Wong Conditional Format Cell Formatting as Table Styles E E Format pen recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? O P C 2010 PEU PHEAA INST AID SEOG PERKINS 2004 2003 $1,116 $ 988 325 S $ 954714 $36.270 $ $ 742299 $ 850,716 $ $ 11-05 8.318 S S 24 ZN $ 3.854 5 L M N Francial Aid Year-over Year Years 2006 2007 2008 2009 2011 2012 2013 Tel 1345,202 $ 1.294,917 5 1217308 $ 1,204463 $ 1067,413 $ 1,28,33 $ 1,197.445 $ 1,257,666 $12.001.708 808 877 908,418 S 882.0413 304,006 3969, 1745 S66 S 926,700S 902829 9318.914 827 575 5 782,205 5 712.9215 756,12 $ T33 854 5 787312 5 880.667 5 737 264 $ 7.772.275 13,475 $ 22 18,638 5 28,294 $ 18.400 $ 26 2025 14.4205 21,391 s 183,113 16305 16667 $ 13,564 $ 258225 250 $ 9.5845 34.888 29,9715 231,375 Pro 10 POBO Pro 7 Pub Probe Proble Prob 3 Pro 2 indo Prob 2 Final ert Draw Page Layout Formulas Data Review View Tell me 10 A Arial ab = General lili 8 00 .00 10 Conditional Format Cell Formatting as Table Styles covered workbooks? Your recent changes were saved. Do you want to continue working where you left off? M PELL PHEAA INST AID SEOG PERKINS 2004 2005 $ 1,110,428 $ 988 325 $ $ 984.774 $ 956 270 $ $ 742.899 $ 850 716 $ $ 11.431 $ 8,318 5 S 5 24 274 $ 36.654 $ G H Financial Aid Year-over-Year Year's 2006 2007 2008 2009 2010 2011 2012 2013 Total 1,345,368 $ 1,294,917 $ 1,217,308 $ 1,304 463 $ 1,067,413 $ 1,288,373 $ 1,197,445 $ 1257.666 $ 12,061,700 908,877 $ 908,418 $ 887,041 5 904005 $ 959 1745 9560665 926,780 $ 827 529 $ 9,318,914 827 575S 762 265 $ 712,9215 756,812 5 733,854 S 787,312 S 860,657 $ 737,254 $ 7,772,275 13,475 $ 22.937 $ 18,638 S 29.294 $ 16.407 $ 28802 S 14,420 $ 21,3915 183.113 16.303 $ 14.667 $ 13.564 $ 25822 $ 25 238 S 9,984 S 34.898 $ 29.971 S 231.375 Calibri (Body) 11 A A General te BIU Conditional Format Format as Table cell Styles A B C D E F G H Year Financial Ald PELL SEOG PERKINS INST AID SEIG Amount 2004 2013 2009 2010 2010 In cell H4 place the appropriate functions) to retrieve the appropriate amount from the table on sheet "Prob 7 Infobased on the financial aid and year provided. Copy this function down through cell H. You will need to create range names and you may use working columns, if desired [10 points) Prob Prob 7 Info Prob. 8 Probo Prob 10 Prob 11 Pivot tablo Info + eady Year Financial Aid PELL SEOG PERKINS INST AID SEIG Amount 2004 2013 2009 2010 2010 In cell H4 place the appropriate function(s) to retrieve the appropriate amount from the table on sheet "Prob 7 Info" based on the financial aid and year provided. Copy this function down through cell H8. You will need to create range names and you may use working columns, if desired. (10 points) AutoSave ir Final ABESUE Page Layout Formulas cert Draw Data Review View Tell me Share Arial 10 General I'll lili II IU III BIU Conditional Formatting Format as Table Cell Styles 16 A $ % ) Cells F B D E PELL PHEAA INST AID SEOG PERKINS 2004 2005 $ 1.110,428 $ 988,325 $ $ 984,774 $ 956 270 $ $ 742.899 $ 850,716 $ $ 11,431 $ 8,318 $ $ 24274 $ 36,654 $ G H Financial Aid Year-over-Year Years 2006 2007 2008 2009 2010 2011 2012 2013 Total 1,345,368 $ 1,294,917 $ 1.217,308 $ 1304,463 $ 1,057,413 $ 1,288,373 $ 1,197.445 $ 1.257.666 $ 12,061,708 908,877 $ 908,418$ 887041 $ 904,005 $ 969, 1745 956086 5 926,780 $ 827 529 $ 9,318,914 827 575 $ 762,265 S 712 921 $ 756,812 $ 733,854 $ 787 312 5 860,657 737,264 $ 7.772.275 13,475 S 22 937 $ 18 638 29,294 $ 16,407 S 26,8025 14.420 $ 21.1915 183,113 16,303 $ 14.667 S 13,564 5 25.822$ 25.238 $ 9,984 5 34.898 $ 29,971 $ 231 375 Info + Pivottabile Prob 11 Prob 7 ipto ProD TO Prob Prob Prob 7 eady peace-symbols umbing peace-symbols Silhouett. Umbipo Draw Page Layout Formulas Ulu Arial General 10 A A Conditional Formatting Format as Table v Cell Styles LN Cells BTU $ % 9 . D G H K L M N PELL PHEMA INSTAD SEOG PERONS 2004 2005 5 1110 $ 9883255 $ CT4 20 S 5 76 S150716 S 5 11.01 S 2318 S $ Financial Aid Year-over-Year Years 2006 2007 2008 2009 2010 2011 2012 2013 Total 1,345368 $ 1.294.917 $ 1.217,308 $ 1,304,463 $ 1,057,413 $ 1,288,373 $ 1,197,445 $ 1,257,666 $ 12,061,706 908.8775 908.418 887,041 $ 904 006 $ 959. 1745 966,086 5 926,760 $ 927,529 $ 9,318,914 827 57S $ 762.265 $ 712,921 $ 756,812 $ 733 854 $ 787,312 $ 860,657 $ 737,264 $ 7,772,275 13.475 S 22.9375 18,638 $ 29,294 $ 16.407 $ 26,802 $ 14.420 $ 21,391 $ 16.30 $ 183,113 14 667 $ 13,564 $ 25.82 $ 25 238 $ 9.984 $ 34,898 $ 29,971 5 231,375 Probioto Pro 10 Prob 11 Pivot table Info +