DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB 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: -To add a new row, click a cell in the row immediately above where you want the new row, right click, select insert and press enter.
Detailed explanation-2: -To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones. Right-click the selection, and then select Insert Rows.
Detailed explanation-3: -Select a cell to the right or left of where you want the new column to appear. Select the Table Tools Layout tab > Insert Left or Insert Right.
Detailed explanation-4: -Click the Insert command on the Home tab. The new column will appear to the left of the selected column.
Detailed explanation-5: -When inserting new rows, columns, or cells, you will see a paintbrush icon next to the inserted cells. This button allows you to choose how Excel formats these cells. By default, Excel formats inserted rows with the same formatting as the cells in the row above.