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: -Excel is case sensitive with respect to names of cells. If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference. The PMT function has two arguments: rate and payment.
Detailed explanation-2: -Detailed Solution. The correct answer is Formula bar. The Formula Bar is where data or formulas you enter into a worksheet appear for the active cell.
Detailed explanation-3: -Click the cell in which you want to enter the formula., type = (equal sign). Do one of the following, select the cell that contains the value you want or type its cell reference. You can refer to a single cell, a range of cells, a location in another worksheet, or a location in another workbook.