FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -When inserting formula in Excel, you can type several first letters of the function in the formula bar, and use the suggestion to autocomplete the formula. Say that you want to use the SUM Function, to sum values from cells B2:B7, in cell B8. Select cell B2, and type =SU.

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.