DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS 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: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
Detailed explanation-2: -The fill handle allows you to copy and paste formulas to adjacent cells. You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete. In Excel, columns are identified by numbers and rows by letters.
Detailed explanation-3: -Copy cells by using Copy and Paste Select the cell or range of cells. Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.
Detailed explanation-4: -Fill Handle: The fill handle is the small bold square in the bottom right corner of a cell that can be used to copy (fill) data to adjacent cells in the same row or column.