USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Fill Series
|
|
Fill Formatting Only
|
|
Fill without Formatting
|
|
None of the above
|
Detailed explanation-1: -Fill Series is a helpful feature in Excel that improves efficiency in creating spreadsheets. It allows instant filling of values in selected cells based on the intervals, type, units and step values specified by the user.
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. Note: This article explains how to automatically fill values into other cells.
Detailed explanation-3: -If you use the Fill – Series button instead of the fill handle, you can enter just your starting number, then click Fill and choose Series. Here you can enter a Step Value (the number added to each cell in the fill range). You can also set a Stop Value if you want to stop filling once a certain number is reached.