USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Auto Complete
|
|
|
Auto Fill
|
|
|
Auto Size
|
|
|
Auto Data
|
Detailed explanation-1: -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.
Detailed explanation-2: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-3: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. 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.
Detailed explanation-4: -AutoFill Formatting Move your cursor to the corner until you see the Fill Handle. This time hold your right mouse button and drag through the cells where you want to apply the formatting. Release the button and you’ll see a shortcut menu appear. Choose Fill Formatting Only.
Detailed explanation-5: -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.