Figure 532 Launching Function Wizard

2. You can see the entire range of functions listed in the Functions list box. You can also select one category from the Category drop-down list to display the functions listed under that category. Find the desired function from the Functions list, and click to select it. You notice that the Function Wizard dialogue box provides you some information about the selected function to guide you through your selection. After selecting the function, click Next to proceed with the task of entering a formula.

Figure 5.33: Selecting a Function

3. Now, you need to specify the numbers to which you want to apply the formula. To select the numbers, you need to go back to the worksheet.

Click the Shrink button to shrink this dialogue box and return to the worksheet.

Figure 5.34: Shrinking the Function Wizard Dialogue Box

4. The Function Wizard dialogue box shrinks to allow you to view the worksheet. To select the cell range, hold down the SHIFT key and use the mouse to select the cell range containing the desired numbers.

After selecting the cells, you can go back to the Function wizard by clicking the Maximize button.

y Untitledl - OpenOffiee.org Cale [.][□][ x | File Edit View insert Format Tools Data Window Help

■ - m a & h m m m r*> ^mu- a ♦> - - m ^ s-«

»

| D4:D15| ||HJ_

-JTT-

- r

A | B | C | D

E

F

G

H

7

i

Climatic Data

2

Temperature

Mean Rain Fall

3

4

January

25

B5.2 103.3

5

February

24.4

13.

b

March

22.3

11.

7

April

19.3

G

May

16.2

5.

9

June

12.9

1.

10

July

12.2

0.

11

August

13.7

1.

12

September

16.4

15

October

19.6

7

13

Navem ber

22

8

15

December

24

12

IB

\Sheetl

/Sheets /5h

eetî / ||

M

L_ j

Was this article helpful?

0 0

Post a comment