Autosave

Home

Insert

Draw

Page Layout

Formulas

Data

Review

View

Tell me

Share

Paste

Blackadder ITC

$11$

$A^A$

General

Conditional Formatting

Insert

Format as Table

Delete

Cell Styles

Format

Sort &

Find &

Analyze

Filter

Select

Data

Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?

Office Update To keep up$-$to$-$date with security updates, fixes, and improvements, choose Check for Updates.

C$2$

Tametrica

Monthly subtotals of expenses.

Enter monthly costs for each category. Format as currency with two

decimals, like $$12\mathrm{.}34$

$\backslash$table$[[$Subtotals$,$Percentage,$],[$Housing $($rent$,$ mortgage, etc.$),,],[$Food $($eating out, grocieries$),,],[$Utilities $($water$,$ trash, electric, etc.$),,],[$Auto $($gas$,$ payments, inurance, etc.$),,],[$Recreation $($movies$,$ subscriptions, etc.$),,],[$Other$,,],[$Monthly Total,,$],[\backslash$table$[[$Sum up the columns of the table using $=$SUM$($RANGE$),$ where for example, the$],[$range for Rent is F$16$:F$27.$ Format s currency with two decimals, like $$12\mathrm{.}34.],[($This should be automatic if the table is correctly formatted.$)]],]]$

$\backslash$table$[[,,,,,],[$Housing$,$Food,Utilities,Auto,Recreation,Other$],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,]]$

Compute the percentage of the total budget represented by each subtotal. A percentage is calculated as part$/$whole$,$ or subtotal$/$total$.$ Format as a percentage with two decimals, like $12\mathrm{.}34\%.$

Insert Pie chart here. Make sure the categories and either percentages or subtotals are displayed on the chart. Make sure to set the chart title appropriately.

Goals and Instructions