DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Active cell
|
|
|
Cell address
|
|
|
Specific cell
|
|
|
Main Cell
|
Detailed explanation-1: -Active Cell-The cell in your worksheet that has been selected. It will have bolder gridlines around it. The worksheet that is displayed in the work area. A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
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 ActiveCell property returns a Range object that represents the cell that is active. You can apply any of the properties or methods of a Range object to the active cell, as in the following example. While one or more worksheet cells may be selected, only one of the cells in the selection can be the ActiveCell.
Detailed explanation-4: -The columns in a worksheet are identified by numbers. The active cell in a worksheet is outlined by a bold rectangle. Page Layout view is useful when preparing your data for printing.
Detailed explanation-5: -The correct answer is Current cell.