USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.
Detailed explanation-2: -Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.
Detailed explanation-3: -When more than one arithmetic operator is involved in a formula, excel follows the same basic order of operations that you use in algebra. An arithmetic operator simply means the mathematical function which takes two operands and then performs a calculation on them.
Detailed explanation-4: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-5: -In a formula, a % sign designates that a cell in a formula is an absolute.