USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
There is no difference between an AutoFiltered range of records in a list and a table.
|
|
|
A table maintains its sort order after you close and then open it again.
|
|
|
A table given a title enables its field names to be used in formulas in place of cell references.
|
|
|
A table enables special subtotal functions for total rows.
|
Detailed explanation-1: -There is no difference between an AutoFiltered range of records in a list and a table.
Detailed explanation-2: -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-3: -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-4: -Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.
Detailed explanation-5: -Or, press the keyboard shortcut Ctrl + Shift + F3. Either way, the Create Names from Selection dialogue box will open. You select the column or row with headers, or both, and click OK.