Module 03 Written Assignment - Formulas, Functions, and Formatting

profileGladiola

 

ontinue working with the personal budget that you have already started. You will add formulas, functions, and more formatting.

  • Add a title row that is centered within merged cells. Change its font color to anything other than black.
  • Using functions within Excel, find the following data for your expenses each month: AVERAGE, MAXIMUM, and MINIMUM
  • Using a formula, find your net income (income minus expenses) for each month and for the entire year.
  • Change the orientation or angle of the names of the months.
  • Use the bold, underline, and italicize effect somewhere in the workbook.
  • Add a border to your worksheet.

Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates.

    • 8 years ago
    • 3
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      PersonalBudget.xlsx