FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

WORKBOOK THEMES

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

A	Double-click the name of the function
B	Double-click anywhere inside the worksheet
C	Double-click anywhere outside the worksheet
D	None of the above

Explanation:

Detailed explanation-1: -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-2: -Enter Items in a Formula Using Formula AutoComplete Click the cell where you want to enter a formula. Type = (an equal sign), and beginning letters or a display trigger to start Formula AutoComplete. For example, type su to display all value items, such as SUBTOTAL and SUM.

Detailed explanation-3: -Click Home > Cut (or press Ctrl + X). Select the cell you want the formula to be in, and then click Paste (or press Ctrl + V). Verify that the cell references are still what you want. Tip: You can also right-click the cells to cut and paste the formula.

There is 1 question to complete.