FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use the AutoFill option to get repeating series. Filling down cells horizontally and vertically. Autofill several rows or columns.

Detailed explanation-2: -Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.

Detailed explanation-3: -What is AutoFill? 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-4: -Auto Preview-Excel will automatically format your data range or table with a preview of any style you select, but will only apply that style if you press Enter or click with the mouse to confirm it. You can scroll through the table formats with the mouse or your keyboard’s arrow keys.

Detailed explanation-5: -Fill Handle is a feature in Excel that enables you to auto-complete a list in a row/column by simply dragging it using your mouse.