USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You want to preserve the integrity of any cells referenced by formulas in the macro.
|
|
|
You want the values of any cells copied to the macro to be accurate.
|
|
|
You want the results of any formulas produced by the macro to be accurate.
|
|
|
You want the macro to reproduce its results in the same place each time
|
Detailed explanation-1: -Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative? You want to preserve the integrity of any cells referenced by formulas in the macro.
Detailed explanation-2: -Which of the following statements best describes how to copy macros from one workbook to another? Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor.
Detailed explanation-3: -Absolute reference is the cell reference in which the row and column are made constant by adding the dollar ($) sign before the column name and row number. The absolute reference does not change as you copy the formula from one cell to other.
Detailed explanation-4: -Which of the following is a possible reason why a spreadsheet solution may require changes? Data (variables) should never appear more than once in a spreadsheet.
Detailed explanation-5: -What are the limitations when entering a macro name in the Record Macro text box? It cannot begin with a number, and it cannot contain spaces.