FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To go back to cell A1 tap
A
CTRL + ALT
B
CTRL + ALT + DEL
C
CTRL + HOME
D
ALT + HOME
Explanation: 

Detailed explanation-1: -If you want to quickly jump to cell A1 from anywhere of the sheet, you just need to hold Ctrl key, and press Home, then the cursor jumps to the cell A1 at once.

Detailed explanation-2: -Press F5 or CTRL+G to launch the Go To dialog. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box, then press OK.

Detailed explanation-3: -Ctrl+Home in Excel and other spreadsheet programs In Microsoft Excel, pressing Ctrl + Home moves to the A1 cell. If you pressed Ctrl + Shift + Home, everything from the text cursor’s current position to A1 would be highlighted.

Detailed explanation-4: -The easiest way to go back to the A1 cell may the shortcut keys, please do as this: Hold down the Ctrl + Home keys together as following screenshot shown, the cursor will be jump to the cell A1 from anywhere of the worksheet.

Detailed explanation-5: -Home-Go to the beginning of the line, paragraph or document. Ctrl + Home-Pressing Ctrl and Home at the same time takes you to the very beginning of the document, text, worksheet, or page. With languages that write left-to-right, pressing Ctrl+Home moves to the top-left of the page.

There is 1 question to complete.