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.

Computer Science & Information Technology

You might also like to view...

In OpenOffice applications, the sidebar displays tools and options grouped into what OpenOffice refers to as decks

Indicate whether the statement is true or false

Computer Science & Information Technology

_________ is a Microsoft resource that helps administrators identify the compatibility of their applications with Windows 8.1, thereby helping organizations to produce a comprehensive software inventory

a. Application Compatibility Toolkit (ACT) b. Application Compatibility Mode c. AppSetup d. None of the above

Computer Science & Information Technology

With a two-dimensional array, the ____ field holds the number of rows in the array.

A. size B. capacity C. row D. length

Computer Science & Information Technology

In a ____, the key, through an algorithmic function, determines the location of the data.

A. probability search B. binary search C. sentinel search D. hashed search

Computer Science & Information Technology