USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoComplete
|
|
|
AutoFill
|
|
|
Autocorrect
|
|
|
Autospell
|
Detailed explanation-1: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
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: -Turn Formula AutoComplete on or off Click File > Options > Formulas., click Excel Options, and then click the Formulas category. Under Working with formulas, select or clear Formula AutoComplete.
Detailed explanation-4: -Autofill is a function found in some computer applications or programs, typically those containing forms, which prefills a field automatically and can save a user time. A web browser’s autofill feature is used to fill out forms with previously entered values, or a predetermined value.
Detailed explanation-5: -A formula in Excel always begins with an equal sign (=). Excel interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.