DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoSum
|
|
|
Custom Fill
|
|
|
Fill Handle
|
|
|
Ctrl+C
|
Detailed explanation-1: -Excel has a feature that helps you automatically enter data. If you are entering a predictable series (e.g. 1, 2, 3…; days of the week; hours of the day) you can use the AutoFill command to automatically extend the sequence.
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.
Detailed explanation-3: -In Microsoft Excel, a fill handle is a feature to extend (and fill) several numbers, dates, or even text to other cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom-right corner, as shown in the image.
Detailed explanation-4: -Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.