DATABASE FUNDAMENTALS
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: -Data tables have multiple purpose(s). You can double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.
Detailed explanation-2: -A Data Table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. If you have more than two variables in your analysis problem, you need to use Scenario Manager Tool of Excel.
Detailed explanation-3: -Tables are organized into records which are composed of fields. Records are columns in a a table that describes a characteristic about a field, such as a customer’s last name or street address. Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.