AutoSave Off Chapter 4 Homework_Student-1 - Excel Search Alexus Joe AJ 7 o File Home Insert Page Layout Formulas Data Review View Help Share Comments Define Name fx w Q Calculate Now Insert Function AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library e, Trace Precedents Dr Show Formulas Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing Use in Formula Name Manager E Create from Selection Defined Names Calculation Calculate Sheet LOS Watch Window Options Calculation 027 X foc K 1 M N B D F G H 26 The Fiscal Year (FY) projected 2019 budget is given in the spreadsheet broken down by Outlays (Mandatory and Discretionary spending) and 27 Receipts (income). 28 29 Outlay (expenditures) % of Subtotal% of Total 30 Mandatory 31 Social Security 1046.5 32 Medicare 624.7 33 Medicaid 412 34 Other 656 35 Sub Total Excel Budget 36 37 Discretionary % of Subtotal% of Total 38 National Defense 678.2 39 Non-Defense 626) 40 Homeland Security 363.4 41 Interest 259 Sub Total 42 43 Total 44 45 16! Section 4.1 Pie Chart Table Outlave Section 4.3 + Section 4.2 Ready 100% Type here to search O T E 1 a 67F Sunny a la 1:01 PM 10/30/2021