DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Tab
|
|
|
Enter
|
|
|
Ctrl
|
|
|
Shift
|
Detailed explanation-1: -Answer. Answer: to enter or modify a formula in a cell, press double click the end key after selecting the cell.
Detailed explanation-2: -Pressing Enter moves the selection down one cell, and pressing Tab moves the selection one cell to the right. You cannot change the direction of the move for the Tab key, but you can specify a different direction for the Enter key.
Detailed explanation-3: -To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2). Click the location inside the selected cell where you want to break the line.
Detailed explanation-4: -Press “Enter” to generate your text with cell references. You can use this function with other functions in Excel, such as CONCATENATE, TEXTJOIN or CONCAT.