DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Enter
|
|
|
AutoFill
|
|
|
Delete
|
|
|
None of the above
|
Detailed explanation-1: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-2: -What is AutoFill? Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.
Detailed explanation-3: -Autofill, also called autocomplete, is a software feature that automatically inserts previously-entered personal information into web form fields for the user’s convenience.
Detailed explanation-4: -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-5: -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.