USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Tip: You can delete the contents of a table row or column without deleting the table structure. To do this, select the row or column and then press the Delete key. Right-click in a table cell, row, or column you want to delete. On the menu, click Delete Cells.
Detailed explanation-2: -Delete a row or column Select a row or column that you want to delete. Press Backspace, or select the Table Tools Layout tab >Delete, and then select an option. Note: In Excel, select a row or column that you want to delete, right-click and select Delete, and choose the option you want.
Detailed explanation-3: -If you don’t need any of the existing cells, rows or columns, here’s how to delete them: Select the cells, rows, or columns that you want to delete. Right-click, and then select the appropriate delete option, for example, Delete Cells & Shift Up, Delete Cells & Shift Left, Delete Rows, or Delete Columns.
Detailed explanation-4: -Click on the Insert command to add a row or the Delete command to remove a row. The row will be inserted above the selected column or the row selected will be removed, depending on your choice to insert or delete.
Detailed explanation-5: -Answer: Yes! In excel when you add or delete any row or column the size changes.