Assignment $1$

You will generate a Microsoft Excel spreadsheet showing a financial budget and a sorted list.

This assignment will be out of $1000$ possible points.

You can use Microsoft Excel or Google Sheets to create this assignment. Your assignment should be saved as a Microsoft Excel document $(.$xlsx$).$

Your files $($the spreadsheet and two screenshots$)$ must be uploaded to Canvas by the due date.

Your spreadsheet will have multiple tabs$.$

One tab will be a budget spreadsheet. See an example budget spreadsheet here. $($Yours will likely look a bit different.$)$

The second tab will have a sorted list of movies and their year of release.

You must have at least the following items in your spreadsheet. Feel free to add more and make this financial budget a valuable tool for you.

Item #$1($Budget$)$: Have at least $8$ columns. $(100$ pts$)$

At minimum, you must include one of the following:

Two pairs of columns for bills, and two pairs of columns for income, or

Three pairs of columns for bills, and one pair of columns for income.

For any pair of columns, the left column should say the type of bill$/$income $($ex$.$ Rent$),$ and the right column should contain the value $($ex$.$ $$600).$

For the bills columns, one must be Monthly Bills. The others can be any of the following:

Weekly Bills

Annual Bills

Bi$-$annual Bills

Quarterly Bills

For the income column$($s$),$ it can be any of the following:

Weekly Income

Monthly Income

Annual Income

Bi$-$annual Income

Quarterly Income

Parental Income

Financial Aid Income

Item #$2($Budget$)$: Have an area for Total Monthly Bills. $(100$ pts$)$

You will need to use a function.

Functions begin with an equal sign.

Typing $=$SUM$($B$3,$B$7)$ will give you the sum of cells B$3$ and B$7($B$3+$B$7).$

Typing $=$SUM$($B$3$:B$7)$ will give you the sum of all the cells between B$3$ through B$7($B$3+$B$4+$B$5+$B$6+$B$7).$

Empty cells do not affect the formula $($they act like a $0).$

You can do many math operations at once.

For example, $=$SUM$($C$2$:C$9)*4+$ SUM$($E$2$:E$9)$ takes the sum of weekly bills $($in column C$),$ multiplies them by $4$ to convert to monthly values, and adds the sum of monthly bills $($in column E$).$

You need to convert all your bills to monthly values.

For example, weekly bills should be multiplied by $4($like in the example above$),$ yearly bills should be divided by $12,$ bi$-$annual bills should be divided by $6,$ etc.

Item #$3($Budget$)$: Have an area for Total Monthly Income. $(100$ pts$)$

Like in Item #$2,$ you will need to use a function.

In my example spreadsheet in cell C$11,$ I typed $=($SUM$($K$2$:K$9)+($SUM$($M$2$:M$9))/12).$

Item #$4($Budget$)$: Have an area showing how much money you have left over each month, labelled $$Play Money$.(100$pts$)$

Like in Items #$2$ and #$3,$ you will need to use a function.

This number might be negative, since students often go into debt.

Item #$5($Budget$)$: Text Formatting $(200$ pts$)$

Use a font that is not default $(50$ pts$).$ Some examples of fonts that are not default:

Arial Narrow

Courier New

Garamond

Tahoma

Verdana