What is a macro? What are the two kinds of macros and how are they different?
What will be an ideal response?
A macro is a VBA, Visual Basic for Applications, program that can make tasks in Excel easier. A macro records your keystrokes and then plays them back to you. An absolute reference macro affects the same cells every time you run the macro, regardless of which cell is active when you run the macro. A relative reference macro affects cells relative to the active cells and therefore may affect different cells every time the macro is run.
You might also like to view...
When preparing a presentation for delivery using a traditional projection device, you should take into consideration that the edges of the screen are usually ________
A) gray B) blue C) white D) black
Excel displays a green arrow in the top left corner of a cell if it detects a
A) cell reference or a value. B) potential error. C) rule that governs components of functions. D) predefined formula that performs a calculation.