DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cut
|
|
|
Move
|
|
|
Copy
|
|
|
Duplicate
|
Detailed explanation-1: -Click the Home tab of the Ribbon. Click the down arrow on the Delete button in the Cells group. Click either the Delete Sheet Columns or the Delete Sheet Rows option.
Detailed explanation-2: -To replace cell content: From the Home tab, click the Find and Select command, then select Replace from the drop-down menu.
Detailed explanation-3: -Merge Cells: This option joins the selected cells into a single cell without entering the text in the cell. Merge and Center: This option enables us to merge the cell and align the text into the center.
Detailed explanation-4: -Use the Go To command to quickly find and select all cells that contain specific types of data, such as formulas. Also, use Go To to find only the cells that meet specific criteria, -such as the last cell on the worksheet that contains data or formatting.