My sister is asking something about Macro in MS Excel and Powerpoint for their assignment, but I can't find it in wikipedia. I need to know what is this and its types and purpose. Please.
2007-03-15 02:36:21 · 3 answers · asked by midnightshadow_04 1 in Computers & Internet ➔ Software
a macro is a set of steps that you can program into excel that will do the same thing over and over if it is selected. for example, if you want to make a cell bolded, in italics, then change the font size, you can select macro under the tools menu, start recording those steps, and save the macro. if you want to do the exact same thing to another cell, just load the macro again and it will run these steps instead of clicking on the individual steps. it makes creating large spreadsheets with repeating information much easier.
2007-03-15 02:45:54 · answer #1 · answered by mizzouswm 5 · 0⤊ 0⤋
A macro is an action or set of actions that can automate certain tasks in the application. In MS Office applications, macros are written in Visual Basic.
Macros are often created by a user who wants to avoid writing repetitive routines. For example, if I often had to sort a column of data and then find the median for the top 10 items, I could write a macro to do it, save the macro, and then with a single keystroke (or clicking on a button I made) execute the macro.
2007-03-15 09:54:37 · answer #2 · answered by SA Writer 6 · 0⤊ 0⤋
It's a recording of keystokes and mouse clicks that you can play back at anytime. Any task that u preform that is the same task everytime you do it is a good canidate for using a macro.
2007-03-15 09:46:54 · answer #3 · answered by Jenny 4 · 0⤊ 0⤋