13-6-10

Using the Action Menu

uQ3

Function: Returns the third quartile of the values contained in the range of specified cells.

Syntax: Q3(start cell:end cell[,start cell:end cell])

Example: To determine the third quartile of the values in the block whose upper left corner is located at A7 and whose lower right corner is located at C12, and input the result in cell A1:

upercent

Function: Returns the percentage of each value in the range of specified cells, the sum of which is 100%.

Syntax: percent(start cell:end cell)

Example: To determine the percentage of the values in cells B1 through B4, and input the result in cell A1:

20050501