Question

You work for a fast food chain. The style guide used by your organisation requires all tables within documents to have an outside border but no inside border. The header row must be shaded and headings must be typed in capital letters.

You need to create a table titled Shopping list. It will have two columns and 10 rows. The first column will have the heading Items. The second column will have the heading Number required. The following items will be inserted into the first column of the table:

flour

tomato

paste

cheese

pineapple

pepperoni

salami

capsicum

mushrooms

olives

Create a macro titled Shopping list which will allow you to automatically insert a table containing the required information in the appropriate format into a new document. Test the macro to ensure it creates a table which is consistent with your organisation’s document standards for tables. Submit a copy of your table.

Answer 1

SHOPPING LIST xlsx Excel (Product Activation Failed) HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER Sign in L --Ruec Relative References Maar sion Packs d,Import Record Macro δ 빼K-Properties E L E View Code Add-nsMode Run Diolog ExpansionPacks A,Export Refresh Data Visual Mac;, Use Relative References Document Panel Add-Ins COM Insert Design Macro Security Code Add-Ins Controls 1 ITEM5 2 Flour 3 Tomato 4 Paste 5 Cheese 6 Pineapple 7 Pepperoni 8 Salami 9 Capsicum 10 Mushrooms 11 Olives NUMBER REQUIRED 21 24 Sheetl