Scripting+and+macros+exercises

Complete this exercise on scripting and macros.

> > > > > > > (i) formats all of the cells as currency > (ii) adds all of the values for Mon-Sat and displays the result in a total. > (iii) format the total as bold and centred > (iv) formats all other text in blue > Now delete the values and total, and enter some different values. Run your macro. What happens? > >
 * 1) Open the file Super Heroes (User: Admin, Password: heroes). Go to the Scripts menu. Try running each script. Now try clicking on the menu buttons (New / Delete / Find etc) at the top of the layout. What do you notice?
 * 1) Go to Scripts -> Scriptmaker and examine each script by double clicking on it.
 * 1) Look at the script Sort by Name. Explain in your own words what the script is doing.
 * 1) Create a new script called Sort by Secret Identity. Try running it to see if the script works.
 * 1) look at the script Test. Try to explain in your own words what the script is doing.
 * 1) Open Microsoft Word. Create a macro which changes the font to courier, size 24, centred, underlined. Now change to a different font setting. Run the macro. What happens?
 * 1) Start Microsoft Excel. Create a spreadsheet for the daily sales of chocolate bars, and enter an amount for each day Mon-Sat. Record a macro which:
 * 1) Give two benefits of using a scripting language.
 * 1) What is the difference between a macro and a scripting language.