DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
used
|
|
|
unused
|
|
|
upper-left
|
|
|
lower-right
|
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: -The database function that counts the cells in the field that are not empty and that meet the criteria is: DCOUNTA.
Detailed explanation-3: -You should create worksheets as if you are going to use them only once. A cell name often is created from column and row titles. You cannot use column and row titles within formulas when you want to refer to the related data by name. Assigning names to a cell or range of cells allows you to select them quickly.
Detailed explanation-4: -Stop. If you set the error alert style to Stop, then you are asking Excel to prevent the user from typing in an invalid value. A value that does not meet the condition specified on the Settings tab will be rejected, and will not be stored in the cell. This is the default style.