Excel : Basic Formatting Practical - 1

 

Create an inventory list with the following columns: Item Name, Quantity, Price.

Item Name	Quantity	Price
Pen	50	1.00
Notebook	30	2.50
Pencil	70	0.75
Eraser	40	0.50
Highlighter	20	1.20
Ruler	25	1.75
Sticky Notes	100	0.30
Binder Clips	50	0.25
Calculator	10	5.00
File Folders	40	0.80
Scissors	15	1.50
Tape Dispenser	10	2.00
Stapler	20	2.50
Paper Clips	200	0.10
Whiteboard Markers	15	1.80

 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 “Inventory List” using a word art.

3. Align the data in the “Item name” column to the right.

4. Apply a light blue colour to the cells containing “Quantity” information.

5. Apply a light green colour to cells containing “Price” information.

6. Change the “Price” column number format to currency and use $.

7. Add suitable cell borders for the table. 

----------------------------------------------------------------------------------------------------------------

Solution

Step 1: Open Microsoft Excel and create a new workbook.

Step 2: In the Sheet 1 type the above table.

Step 3: Select the top row (header row) and change the font style to Bold and font size to 12pt

Step 4: Create a row above the table. To do that right click on row number 1  and click insert. This will add a new row above the selected row.

Step 5: Increase the row height. Right click on the row and select "Row Height" Change it to 100.

Step 6: Go to insert tab and click Word Art. Then select a suitable word art. Inside the Word Art text box type "Inventory List".

Step 7: Select the Column "A". Change the text alignment to Align Right.

Step 8: Select cells from B3 to B17. Click the Fill Color icon and select "Light Blue" colour.

Step 9: Select the cells from C3 to C17. Click the Fill Color icon and select "Light Green" colour.

Step 10: Let's change the unit prices to display the dollar sign ($). Select cells from C3 to C17. Click the dollar sign ($) in Number section.

Step 11: To apply a cell border, first select all the cells from A2 to C17. Then click the Format Cells. In the Format Cells window, click the Border tab. In the Border window, select a style to apply (for this we'll select 7th style in first column) and then click both Outside and Inside preset. Click OK.

 

That's all for this tutorial.