FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A new command in Excel 2013 that recognizes a pattern and duplicates it is:
A
AutoSum
B
AutoComplete
C
FlashFill
D
Copy Down
E
Replicate
Explanation: 

Detailed explanation-1: -Excel Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identifies a pattern. The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, Excel 2021, and Excel for Microsoft 365.

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.

Detailed explanation-3: -Select Data > Flash Fill and Excel automatically fills in your data.

Detailed explanation-4: -The most notable feature in Excel is Flash fill. It reformats data automatically based on how you use Excel 2013 and auto-completes the remaining entries without needing a formula.

There is 1 question to complete.