USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
AutoFill
|
|
#Name?
|
|
Column charts
|
|
Pie Charts
|
Detailed explanation-1: -Go to File > Options > Proofing, and select AutoCorrect Options. On the AutoCorrect tab, select the Replace text as you type check box, if it’s not already checked. Under Replace, type the characters that you want to trigger the automatic text. The text that you selected in your document should appear under With.
Detailed explanation-2: -On the Excel menu, click Preferences. Under Formulas and Lists, click AutoComplete. In the Show the menu only after I’ve typed box, enter the number of letters that you want to type before the AutoComplete menu appears. Tip: You can also show the AutoComplete menu by pressing CONTROL + OPTION + DOWN ARROW .
Detailed explanation-3: -AutoComplete is the automatic filling in of your text when you start typing and is switched on by default. This will reduce the amount of text you have to enter by preventing you typing in repetitive words. AutoComplete matches only exact cell entries, not individual words in a cell.