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: -Thus autocomplete is a feature in MS-Excel that automatically enters the remaining characters, if the first few characters entered the match with an existing entry in that column.
Detailed explanation-2: -AutoComplete helps you quickly insert functions and arguments while minimizing typing and syntax errors. The AutoComplete menu shows you available options based on context, and you choose what you want to insert into your formula.
Detailed explanation-3: -AutoFill in excel can fill a range in a specific direction by using the fill handle. The range is filled with values (numerical, textual or a mix) which are either copied from the initially selected cell or based on the pattern of the selected cells. The range can be filled downwards, upwards, rightwards or leftwards.