DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Editing mode
|
|
|
AutoFit
|
|
|
AutoComplete
|
|
|
AutoFill
|
Detailed explanation-1: -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-2: -Select the cell that contains the formula you want to copy. Hover your cursor around the black square in the lower right corner of the cell until your cursor turns into a plus sign. Click and hold the left mouse button while dragging the handle to include all cellswhere you would like the formula copied.
Detailed explanation-3: -Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.