FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Speed Fill enters text based on patterns it finds in the data.

Detailed explanation-2: -If you establish a pattern by typing the full name in column C, Excel’s Flash Fill feature will fill in the rest for you based on the pattern you provide. Enter the full name in cell C2, and press ENTER. Go to Data > Flash Fill, or press Ctrl+E. Excel will sense the pattern you provided in C2, and fill the cells below.

Detailed explanation-3: -Flash Fill is an Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells.

Detailed explanation-4: -You enter or edit cell contents in the Formula Bar for the active cell. The placement of cell data between the left and right cell margins. By default, text is left-aligned, and values are right-aligned.

Detailed explanation-5: -As a default in Microsoft Excel, text typed into a cell is aligned to the left border of the cell while numbers are aligned to the right.