FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you enter a formula using Point mode and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

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.

There is 1 question to complete.