Answer the given question with a proper explanation and step-by-step solution. Practice is the best way to learn Excel. In this assignment, you will have the opportunity to apply what you learned from the video tutorial. The following are some expenses you have listed in your notes, this time you want to use excel to get the totals from the details automatically: Electricity & Water Bill, 350.75 Phone Bill, 250 Internet, 190 Gas, 120 Meals with Client, 250 Courier, 25 Donation, 100 Car change oil, 179.25 Paid to your accountant, 1,500 Car repairs, 730 Instruction: 1. Open a blank Excel workbook, then create two columns- the 1st column is for the description (e.g. donation), and the 2nd column is for the amount. Write column headings e.g. Expenses for column 1 and Amount for column 2. 2. Write a table heading. The heading should be "Your Family Name's Expenses for the month of September 2022", for example, if your Family Name is Cruz, your table heading will be "Cruz Family Expenses". 3. Format the amounts in two decimal places with the $ sign. 4. Bold the heading and apply some formatting features of Excel to make your work more presentable
Answer the given question with a proper explanation and step-by-step solution.
Practice is the best way to learn Excel. In this assignment, you will have the opportunity to apply what you learned from the video tutorial. The following are some expenses you have listed in your notes, this time you want to use excel to get the totals from the details automatically:
Electricity & Water Bill, 350.75 Phone Bill, 250 Internet, 190 Gas, 120 Meals with Client, 250 Courier, 25 Donation, 100 Car change oil, 179.25 Paid to your accountant, 1,500 Car repairs, 730 Instruction: 1. Open a blank Excel workbook, then create two columns- the 1st column is for the description (e.g. donation), and the 2nd column is for the amount. Write column headings e.g. Expenses for column 1 and Amount for column 2. 2. Write a table heading. The heading should be "Your Family Name's Expenses for the month of September 2022", for example, if your Family Name is Cruz, your table heading will be "Cruz Family Expenses". 3. Format the amounts in two decimal places with the $ sign. 4. Bold the heading and apply some formatting features of Excel to make your work more presentable
Step by step
Solved in 3 steps with 1 images
