DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
formula
|
|
cell
|
|
Name Box
|
|
active cell
|
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: -You can enter data into the active cell on a worksheet by typing the data into the formula bar and pressing ENTER. The cell reference indicator, a gray box to the left of the formula bar, shows the address of the active cell.
Detailed explanation-3: -The active cell is the cell that is currently selected in the worksheet. This cell is where data entry and editing will take place. To select a cell, simply click on it with the mouse. The active cell will be highlighted with a dark border.
Detailed explanation-4: -Double clicking on a cell will simply activate and make it editable. You can also make a cell editable by clicking in the formula bar. This method works only if the cell you want to edit is active.
Detailed explanation-5: -The ActiveSheet is the worksheet tab that is currently selected before running the macro. If multiple sheets are selected, the ActiveSheet is the sheet that is currently being viewed.