FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following finishes an entry based on previous entries made in the column containing the active cell?

A	AutoComplete
B	AutoFinish
C	Conditional formatting
D	FillComplete

Explanation:

Detailed explanation-1: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.

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: -Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.

There is 1 question to complete.