USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Flash Fill is case sensitive. If you enter a lower-case last name, for example, all the last names follow suit. If you don’t like a result, just press Escape, and continue typing without using suggestions. You can also make case sensitivity work for you, and use Flash Fill to change the case of text.
Detailed explanation-2: -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. Note: Flash Fill is only available in Excel 2013 and later. WindowsmacOS.
Detailed explanation-3: -While it’s true that the Auto Fill feature is able to copy a pattern, it is limited to repeating a simple pattern over and over. Flash Fill is a smarter tool: It has the capability to foresee which adjustments within a pattern the user is attempting to make within a spreadsheet.
Detailed explanation-4: -Start Flash Fill manually If you know that Flash Fill is enabled, but still doesn’t work, then you can start it manually by clicking Data > Flash Fill or Home > Flash Fill. You can also press Ctrl+E on the keyboard.