You will create a minimum six$-$month budget.

The budget for those sheets can be weekly, bi$-$weekly, or monthly as long as each budget sheet

encompasses three months. $*$ Without the required budget worksheets, the remainder of the

assignment has no true value.

Additional sheets are required. What sheets they are and what they should include are

described in detail in the instructions under each sheet name listed below.

See the details of each sheet requirement below.

Budget sheets

There should be a minimum of two worksheets for budget months. The following breaks down

the requirements for each sheet. Budget sheets $1$ and $2$ require most of the same things.

Remember, you can always add more, but the minimum is all that is required.

Budget sheet $1($required$)$

$1.$ Should have at least three months of budget months included in each sheet.

Example: Budget sheet $1$ could be the budget months of January through March.

$2.$ There should be a minimum of six expenses; however, more is better

$3.$ The sheet should be named indicating the budget months. For example: Jan$-$Mar

$4.$ Merge and center the title of the worksheets.

$5.$ Minimum of one cell style. On the checklist, enter the location of the cell$($s$)$ that the cell

style was used. Include the cell type in used. $($example A$1$:A$6$ cell type: blue accent $20\%).$

$6.$ Minimum of one heading style. On the checklist, enter the location of the cell$($s$)$ that the

style was used. Include the heading name $($example: A$1$ Heading $2).$

$7.$ Min of one conditional formatting type. On the checklist include the criteria for the

condition and type format applied. $($example: A$21$:F$20,$ If balance is $>5,$ red background

with white print$)$

Held CIS$114$DE Final Project $2$

$8.$ Use at least two numeric formatting features $($$$,$ comma, $\%,$ etc.$)$ No need to put in

checklist.

$9.$ Use at least one date format

Formulas$/$Functions for Budget sheet $1$

$*$If you do not use formulas, your score results in a zero for this portion.

$10.$ Minimum of three different function types. Of the three, one must be an $=$If function.

$11.$ Minimum of one formula. Example: $=$A$1+$B$7*$A$6/$K$5.$

$12.$ Minimum of one formula$/$function using an absolute or mixed value. On the checklist,

enter the location of the cell$($s$)$ the absolute$/$mixed value and why it was used.

Look at this function$/$formula: $=$IF$($B$32<=0,0,$ $J$$39).$ This function meets two of the minimum

requirements for a budget sheet the $=$IF function and the requirement of using an absolute

value.

Look at this function$/$formula: $=$IF$($$B$32<=0,0,$ J$39).$ It also meets the minimum requirement

since you can use absolute or mixed values. The catch? Make sure they are being used properly.

Budget sheet $2($required$)$

$1.$ Should have at least three months of budget months included in each sheet.

Example: Budget sheet $2$ could be the continuation of budget months of April through June.

$2.$ There should be a minimum of six expenses; however, more is better

$3.$ The sheet should be named indicating the budget months. For example: Apr$-$Jun

$4.$ Merge and center the title of the worksheets.

$5.$ Minimum of one cell style. On the checklist, enter the location of the cell$($s$)$ that the cell

style was used. Include the cell type in used. $($example A$1$:A$6$ cell type: blue accent $20\%).$

$6.$ Minimum of one heading style. On the checklist, enter the location of the cell$($s$)$ that the

style was used. Include the heading name $($example: A$1$ Heading $2).$

$7.$ Min of one conditional formatting type. On the checklist include the criteria for the

condition and type format applied. $($example: A$21$:F$20,$ If balance is $>5,$ red background

with white print$)$

Held CIS$114$DE Final Project $3$

$8.$ Use at least two numeric formatting features $($$$,$ comma, $\%,$ etc.$)$ No need to put in

checklist.

$9.$ Use at least one date format

Formulas$/$Functions for Budget sheet $2$

$*$If you do not use formulas, your score results in a zero for this portion.

$10.$ Minimum of three different function types. Of the three, one must be an $=$If function.

$11.$ Minimum of one formula. Example: $=$A$1+$B$7*$A$6/$K$5.$

$12.$ Minimum of one formula$/$function using an absolute or mixed value. On the checklist,

enter the location of the cell$($s$)$ the absolute$/$mixed value and why it was used.

Look at this function$/$formula: $=$IF$($B$32<=0,0,$ $J$$39).$ This function meets two of the minimum

requirements for a budget sheet the $=$IF function and the requirement of using an absolute

value.

Look at this function$/$formula: $=$IF$($$B$32<=0,0,$ J$39).$ It also meets the minimum requirement

since you can use absolute or mixed values. The catch? Make sure they are being used properly.

Loan sheet

$1.=$PMT$()$ Calculate a loan could be a car, student loan, home, etc.

$2.$ Why was it used?

Use on ANY worksheet

What$-$if analysis OR VLOOKUP

Minimum of one What$-$if analysis $($example data table with one or two variables, scenario,

etc.$).$ OR minimum of one VLOOKUP $($or HLOOKUP$)$ On the checklist, enter the location of the

cell$($s$)$ the formula is located and why used.

AND

Minimum of one data validation rule.