Excel : Basic Formatting Practical - 2

 

Create a table for Monthly Expenses with the following columns: Expense Type, Amount, Date.

 

Expense Type	Amount	Date
Groceries	150	05/08/2023
Rent	1200	01/08/2023
Utilities	80	15/08/2023
Dining Out	50	10/08/2023
Transportation	75	08/08/2023
Entertainment	20	20/08/2023
Shopping	100	12/08/2023
Health	40	18/08/2023
Subscriptions	15	03/08/2023
Gym Membership	60	22/08/2023
Miscellaneous	25	25/08/2023

Format the table using the following steps:

1. Change the font style and size for the headers.
2. Add a title above the table as “Monthly Expenses”. Use a thin font and bigger font size. Merge top 3 cells which to cover the 3 columns of the table.
3. Change the “Amount” column's number format to currency and use $. Reduce decimal places to 1.
4. Change the date format type to show “8/24/2023” as "August 24, 2023"
5. For the table, add appropriate cell borders.

*********************************************************************************

Solution:

Step1:  Open Microsoft Excel and Create a new workbook.

Step 2: Type the data into the sheet.

Step 3: Insert a row above the data set. Right click on row 1 and select insert. This will insert the row.

Step 4: In cell A1, type "Monthly Expenses."

Step 5: Change the font in to something thinner like Arial. Change the font size to little bigger like 20.

Step 6: Select A1,B1 & C1 cells.  Then, in the Home tab, click Merge & Center. This will merge (make all three cells in to one) and center the content inside the merged cell. Note that there are no more B1 and C1 cells. Merged cell will be now A1.

Step 7: In the Home tab Number section, select amount data and click the dollar sign ($).

Step 8: A currency value normally have two decimal places. Specially in dollar ($) or Sri Lankan Rupee (LKR). We can reduce number of decimal places by clicking the Decrease Decimal in Home tab Number section.

Step 9: To change the date format first select all the cells which have dates.  Then right click and select "Format Cells"

Step 10: Select the Date Category in Number tab.

Step 11: Pick the type which display as "March 14, 2012" and click OK.

Step 12: To apply cell borders to the table, first select all the cells which have data. Then right click and select Format Cells. Select the Border tab. Select a suitable Line Style, a colour for the border, and borders. (Be fancy and change the colours and styles for different sides.) Click OK to apply the selected borders.

That is all. See how easy to do these things. After you save the Sheet, do not hesitate to experiment different things in Excel. That is how you could learn new things and broad your knowledge.