FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A way to view locations on the worksheet without changing the active cell.
A
Normal View
B
Layout
C
Workbook
D
Scroll
Explanation: 

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.

There is 1 question to complete.