Assignment- Excel Assessment

by


Create an Excel file and enter the following information:

January February March April May
Rent 500 500 500 500 500
Gas 101 99 167 133 102
Food 82 54 167 124 96
Bills 320 300 430 325 330

 

Complete the following tasks in your Excel workbook:

  1. Make the first column yellow and make the top row pink.
  2. Make the months bold font
  3. Format the number to be in dollars
  4. Add a row of the monthly totals
  5. Add a worksheet and copy the table to the second worksheet (label the first worksheet “Budget” and the second worksheet “Gas”
  6. On the second worksheet, create a 2D line graph of the gas values.

Name this excel file “ExcelRocks” and save the file. Submit the file to this assignment.