DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Normal View
|
|
|
Layout
|
|
|
Workbook
|
|
|
Scroll
|
Detailed explanation-1: -Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.
Detailed explanation-2: -Note: To select the very last cell in a row or column, press END, and then press the RIGHT ARROW key or the DOWN ARROW key.
Detailed explanation-3: -We can change the active cell by either moving the pointer and clicking on another cell, or using the Down, Up, Left and Right arrow keys. Also, when you press the Enter key, the active cell row shall shift downwards.
Detailed explanation-4: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.