USING MICROSOFT EXCEL
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: -Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Detailed explanation-2: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-3: -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-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.