DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
automatic
|
|
|
autofill
|
|
|
automation
|
|
|
automobile
|
Detailed explanation-1: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.
Detailed explanation-2: -In Microsoft Excel, AutoFill is a feature that allows the user to extend a series of numbers, dates, or even text to the necessary range of cells. This little option gives you plenty of possibilities. Use Flash Fill in Excel, autofill dates and numbers, populate numerous cells, and get custom list values.
Detailed explanation-3: -Anyone who has used Excel for some time knows how to use the autofill feature to autofill an Excel cell based on another. You simply click and hold your mouse in the lower right corner of the cell, and drag it down to apply the formula in that cell to every cell beneath it (similar to copying formulas in Excel).
Detailed explanation-4: -Select the top cell that you want to fill from. Select the column range by pressing Shift + Ctrl + End . Press Ctrl + D to autofill.