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: -The PMT function uses the following arguments: Rate (required argument) – The interest rate of the loan. Nper (required argument) – Total number of payments for the loan taken. Pv (required argument) – The present value or total amount that a series of future payments is worth now.
Detailed explanation-2: -Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions. Excel is case sensitive with respect to names of cells. You cannot use column and row titles within formulas when you want to refer to the related data by name.
Detailed explanation-3: -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-4: -RANGE. A range is a group of two or more cells in a worksheet. The cells in a range can be adjacent or nonadjacent.