DATABASE FUNDAMENTALS
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 references You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row. If it precedes the column or row (but not both), it’s known as a mixed reference.
Detailed explanation-4: -Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups? There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.
Detailed explanation-5: -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.