DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
shift
|
|
|
space bar
|
|
|
tab
|
|
|
None of the above
|
Detailed explanation-1: -To add a row above the selected cell, click Insert Above. To add a row below the selected cell, click Insert Below. Notes: To add a row at the end of a table, you can click the rightmost cell of the last row, and then press Tab.
Detailed explanation-2: -You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell.
Detailed explanation-3: -Add a row or column To add rows, click Insert Above or Insert Below and to add columns, click Insert Left or Insert Right. Tip: To add a row at the end of a table, click the last cell of the last row, and then press the TAB key.
Detailed explanation-4: -By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65, 536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.