TASK 1: If you setup a macro which when tested did not work correctly. Describe how you would resolve the issue(s) by referring to user manuals, documentation and online help to overcome problems when designing and producing spreadsheets. (As a guide 60 words)Task 2 may not be possible on CIT Computers. You must demonstrate and run the macro on your own device if it does not function on the CIT computer.If you have your computer at CIT, demonstrate your macro working and running, to your teacher PRIOR to submitting your AT3 for grading.TASK 2: Use Consolidation Exercise 164 (page 204) data for Designer Picnicware to make a new excel spreadsheet. Create the following MACRO:(Make sure you have setup a header and footer with: Your name, CIT number, Date and file name) 1
Record a macro in this file with a keyboard short cut of CTRL SHIFT P
and has the name ‘Printing’ which will adjust page setup, to show the
worksheet as follows:
in portrait
orientationscaled
to fit to one pagehorizontally and vertically aligneddisplays
the header and footername this sheet portrait
2 Examine the macro to determine if it works, if not, make corrections.make a copy the portrait sheetrename the sheet as landscape 3 Using the landscape sheet edit the macro to display orientation as landscape
(test the macro and amend if required)4 Upload the file into this quiz question