7/27/2019 ex14c

1/5

www.itq2009.co.uk 65

PRACTICAL EXERCISE 1.3.2.3

OBJECTIVES

Create a macro. Assign a macro to a custom button on a toolbar. Perform addition calculations on a numeric list in a table.

INSTRUCTIONS

1. Start the Word program.2. Open the document called INVOICE.3. Delete the following records from the top three rows of the Invoice:

ITEM STOCK CODE QTY PRICE

Wall Clock 256/1712 4 56.99

Kitchen Table 610/8951 2 34.99

Kitchen Chairs 600/2480 3 29.99

4. Delete ALL the calculated values in the TOTAL column.5. Create a macro to enter the Item details and Stock Code into a table.

CREATING A MACRO - S256_1712

Place the cursor in thefirst row of the ITEM column

under Order Details

Select the View tab, select Macros and Record

Macro, type the Macro name S256_1712, and clickOKto start

Type Wall Clockin the cell, press the Tab key, then

type 256/1712 as the Stock Code, press the Tab key,

type 1 as the default Qty,press the Tab key, type

56.99 as the Price

Select Macros and Stop Recording the macro

7/27/2019 ex14c

2/5

www.itq2009.co.uk66

CREATING A MACRO - S610_8951

Place the cursor in thesecond row of the ITEM column

under Order Details

Select the View tab, select Macros and Record

Macro, type the Macro name S610_8951, and clickOKto start

Type Kitchen Table in the cell, press the Tab key, then

type 610/8951 as the Stock Code, press the Tab key,

type 1 as the default Qty,press the Tab key, type

34.99 as the Price

Select Macros and Stop Recording the macro

CREATING A MACRO - S600_2480

Place the cursor in the third row of the ITEM column

under Order Details

Select the View tab, select Macros and RecordMacro, type the Macro name S600_2480, and clickOKto start

Type Kitchen Chairs in the cell, press the Tab key, then

type 600/2480 as the Stock Code, press the Tab key,

type 1 as the default Qty,press the Tab key, type

29.99 as the Price

Select Macros and Stop Recording the macro

N.B.Macros could be recorded for all items sold by the

company.

6. Delete the following records from the top three rows of the Invoice:ITEM STOCK CODE QTY PRICE

Wall Clock 256/1712 1 56.99

Kitchen Table 610/8951 1 34.99

Kitchen Chairs 600/2480 1 29.99

7. Save the changes made to the document.

PROBLEMS

SAVING

MACROS

Macros canNOT be savedon a systemwhere theNormal

template file iswrite protected.Networkedsystems oftendo this forsecurityreasons. Ifyour system isprotected you

will be able todo this exercise

but not save themacros for

future use.

7/27/2019 ex14c

3/5

www.itq2009.co.uk 67

8. Add the macros created to the Quick Access Toolbarthis is located next tothe Microsoft Office Button in the top left corner of your screen.

ADDING MACROS TO THE QUICK ACCESS TOOLBAR

Select the Microsoft Office Button , select Word Options,

choose the Customize category, select to Choose commands

from MacrosHighlight the Normal.NewMacros. S256_1712 macro

and Add it onto the Quick Access Toolbar

Highlight the Normal.NewMacros.S610_8951 macro and

and Add it onto the Quick Access Toolbar

Highlight the Normal.NewMacros.S600_2480 macro and

and Add it onto the Quick Access Toolbar

ClickOKto close the Word Options Customize window

9. Use the macros created above to generate an Invoice with the default value 1as the Qty sold.

RUNNING A MACRO - S256_1712Place the cursor in thefirst row of the ITEM column

under Order Details

Click the Macro S256_1712 on the Quick Access Toolbar

RUNNING A MACRO - S610_8951

Place the cursor in thesecond row of the ITEM column

under Order Details

Click the Macro S610_8951 on the Quick Access Toolbar

RUNNING A MACRO - S600_2480

Place the cursor in the third row of the ITEM column

under Order Details

Click the Macro S600_2480 on the Quick Access Toolbar

10. Enter the following values as the Qty in the top three rows of the Invoice:ITEM STOCK CODE QTY PRICE

Wall Clock 256/1712 4 56.99

Kitchen Table 610/8951 2 34.99

Kitchen Chairs 600/2480 3 29.99

7/27/2019 ex14c

4/5

www.itq2009.co.uk68

11. Use the formulae functions in Word to calculate the Totals for the three setsof goods on the Invoice.

FINDING THE PRODUCT OF TWO VALUES

Select the Layout tab on the ribbon

Place the cursor in the TOTAL cell for the Wall Clock

Select Formula , enter a Formula =PRODUCT(LEFT) ,

choose the Number format 0.00, then clickOK

N.B. The amount 227.96 should be displayed.

Place the cursor in the TOTAL cell for the Kitchen Table

Select Formula , enter a Formula =PRODUCT(LEFT) ,

choose the Number format 0.00, then clickOK

N.B. The amount 69.98 should be displayed.

Place the cursor in the TOTAL cell for the Kitchen Chairs

Select Formula , enter a Formula =PRODUCT(LEFT) ,

choose the Number format 0.00, then clickOK

N.B. The amount 89.97 should be displayed.

12. Enter the amount 10.00 in the TOTAL cell for Plus p&p per order.13. Use the formulae functions in Word to calculate the Total order value for the

Invoice.

Select the Layout tab on the ribbon

Place the cursor in the Total order value cell for Total

Select Formula , enter the Formula =SUM(e:e),

choose the Number format 0.00, then clickOK

N.B. e:e represents all the cells above the current one incolumn E. The columns being A, B, C, etc. The total

shown should be 397.91.

14. Save the changes made to the document.

15. Select the Microsoft Office Button and clickClose to clear thescreen.

16. Select the Microsoft Office Button and then Exit Word.

7/27/2019 ex14c

5/5

www.itq2009.co.uk 69

INVOICE

Your Order No: Invoice No:

Date: Date:

Ref: Ref:

To: From:

The Furniture Company

190/196 The High StreetWillesdenLondonNW10 3XD

ORDER DETAILS:

ITEM STOCK CODE QTY PRICE TOTAL

Wall Clock 256/1712 4 56.99 227.96

Kitchen Table 610/8951 2 34.99 69.98

Kitchen Chairs 600/2480 3 29.99 89.97

Plus p&p per

order

10.00

Total order

value 397.91