DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoSum
|
|
|
AutoCorrect
|
|
|
AutoFill
|
|
|
None of these
|
Detailed explanation-1: -The AutoFill excel feature fills a range by using the fill handle in the required direction (down, up, right or left). The range is filled with a series of numerical or textual values. These values are either copied from the initially selected cell or based on the pattern of the selected cells.
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: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-4: -AutoFill is one of Excel’s most powerful and useful features. With AutoFill, you can quickly and easily fill in a range of cells with a series of values without entering them one at a time. This tutorial will show you how to use AutoFill in Excel.