DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Active cell
|
|
|
Cell
|
|
|
Scroll bar
|
|
|
Zoom bar
|
Detailed explanation-1: -Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off. To do that, press the Scroll Lock key (labeled as ScrLk) on your keyboard.
Detailed explanation-2: -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-3: -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. Even if more than one cell is selected, there is still only one active cell at a time.