DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
TRUE
|
|
FALSE
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table: Click anywhere in the table, and the Table Tools option appears. Click Design > Resize Table.
Detailed explanation-2: -Insert or delete a column Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
Detailed explanation-3: -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. Or select a cell, and then select Home > Insert or Home > Delete, and then choose an option.
Detailed explanation-4: -Click a table cell in the column or row that you want to delete. On the Layout tab, in the Rows & Columns group, click Delete, and then click Delete Columns or Delete Rows.
Detailed explanation-5: -If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here’s how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete.