DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Active cell
|
|
|
Active tab
|
|
|
Range
|
|
|
Source area
|
Detailed explanation-1: -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-2: -Select the cells into which you want to enter the same data. The cells do not have to be adjacent. In the active cell, type the data, and then press Ctrl+Enter.
Detailed explanation-3: -Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard.
Detailed explanation-4: -The Active cell inside Excel Worksheet is used to identify the cell which is currently active. The thick border gridlines around the cell indicates that it is the Active cell inside Excel Worksheet. The Active cell is where the focus is on and where the data will be entered when a key is typed on keyboard.
Detailed explanation-5: -Answer: Formula bar. Explanation: the data entered in the active cell is also displayed in formula bar.