FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A thin red border indicates the active cell.
A
true
B
false
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -A thin red border indicates the active cell. Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. Excel can display characters in only three font colors: black, red, and blue.

Detailed explanation-2: -The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border. Data can only be entered into the active cell.

Detailed explanation-3: -The active cell reference appears in the Name box on the left side of the formula bar. Merging cells involves creating a single cell by combining two or more selected cells. The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. The equal sign (=) precedes a formula.

Detailed explanation-4: -You should press the SPACEBAR to clear a cell. You should press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing. Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. Worksheet titles and subtitles should be as wordy as possible.

Detailed explanation-5: -Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.

There is 1 question to complete.