Having spent the last few days testing QuickOffice Pro 7 for Symbian I noted that there is not much information on the supported Microsoft Excel functions within the QuickSheet subapp of QuickOffice.
Function Entry
Functions can be entered within QuickSheet, but it is a somewhat long winded process as you have to:
 tap on “Tap here to edit” or [Options] and [Edit Cell] which opens the half screen keyboard, and exit again by tapping on the green tick (bottom left corner).
 tapping on [Options] brings up new menu options, including [Operators] and [Insert function].
 Tap on [Insert function] and you will be presented with function categories as seen in Microsoft Excel function wizard.
Once you have selected a function, all function text must be entered in uppercase as lowercase letter usage presents you with a “Cannot accept the input” error message.
This Review forms part of a multipart review:
 QuickOffice Pro 7
 QuickOffice Pro 7: QuickWord
 QuickOffice Pro 7: QuickSheet
 QuickOffice Pro 7: QuickSheet – Supported Excel Functions
 QuickOffice Pro 7: QuickPowerPoint
Also when you change case during function entry the cursor is automatically moved after the closing bracket of the formula, requiring manual repositioning of the cursor to the correct text entry position.
The good news is that the first few operations can be ignored if you already know the function needed as functions can be entered manually.
Sadly there is no excel style guidance as to how, and in which order, functions should be constructed. To help I have listed all functions supported in QuickSheet and the construction of the function in the following section.
Available Functions
Below are a number of tables, aligned to the categories of functions available within Quicksheet, with hyperlinks to Microsoft detailed information on the functions..
Common
Returns the average of its arguments 
AVERAGE(number1,number2,…) 

Specifies a logical test to perform 
IF(logical_test,value_if_true, 

Returns the internal rate of return for a series of cash flows 
IRR(values,guess) 

Returns the serial number of the current date and time 
NOW() 

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate 
NPV(rate,value1,value2,..) 

Returns the periodic payment for an annuity 
PMT(rate,nper,pv,fv,type) 

Adds its arguments 
SUM(number1,number2,…) 

Estimates standard deviation based on a sample 
STDEV(number1,number2,…) 
Math and trigonometry functions
Returns the absolute value of a number 
ABS(number) 

Returns the arccosine of a number 
ACOS(number) 

Returns the inverse hyperbolic cosine of a number 
ACOSH(number) 

Returns the arcsine of a number 
ASIN(number) 

Returns the inverse hyperbolic sine of a number 
ASINH(number) 

Returns the arctangent of a number 
ATAN(number) 

Returns the arctangent from x and ycoordinates 
ATAN2(x_num,y_num) 

Returns the inverse hyperbolic tangent of a number 
ATANH(number) 

Returns the cosine of a number 
COS(number) 

Returns the hyperbolic cosine of a number 
COSH(number) 

Converts radians to degrees 
DEGREES(angle) 

Returns e raised to the power of a given number 
EXP(number) 

Returns the factorial of a number 
FACT(number) 

Rounds a number down to the nearest integer 
INT(number) 

Returns the natural logarithm of a number 
LN(number) 

Returns the logarithm of a number to a specified base 
LOG(number,base) 

Returns the base10 logarithm of a number 
LOG10(number) 

Returns the remainder from division 
MOD(number,divisor) 

Returns the value of pi 
PI() 

Returns the result of a number raised to a power 
POWER(number,power) 

Multiplies its arguments 
PRODUCT(number1,number2,…) 

Converts degrees to radians 
RADIANS(angle) 

Rounds a number to a specified number of digits 
ROUND(number,num_digits) 

Rounds a number down, toward zero 
ROUNDDOWN(number,num_digits) 

Rounds a number up, away from zero 
ROUNDUP(number,num_digits) 

Returns the sine of the given angle 
SIN(number) 

Returns the hyperbolic sine of a number 
SINH(number) 

Returns a positive square root 
SQRT(number) 

Adds its arguments 
SUM(number1,number2,…) 

Returns the tangent of a number 
TAN(number) 

Returns the hyperbolic tangent of a number 
TANH(number) 

Truncates a number to an integer 
TRUNC(number,num_digits) 
Statistical functions
Returns the average of the absolute deviations of data points from their mean 
AVEDEV(number1,number2,…) 

Returns the average of its arguments 
AVERAGE(number1,number2,…) 

Counts how many numbers are in the list of arguments 
COUNT(value1,value2,…) 

Counts how many values are in the list of arguments 
COUNTA(value1,value2,…) 

Counts the number of blank cells within a range 
COUNTBLANK(range) 

Returns the kurtosis of a data set 
KURT(number1,number2,…) 

Returns the kth largest value in a data set 
LARGE(array,k) 

Returns the maximum value in a list of arguments 
MAX(number1,number2,…) 

Returns the minimum value in a list of arguments 
MIN(number1,number2,…) 

Returns a random number between 0 and 1 
RAND() 

Returns the skewness of a distribution 
SKEW(number1,number2,…) 

Returns the kth smallest value in a data set 
SMALL(array,k) 

Estimates standard deviation based on a sample 
STDEV(number1,number2,…) 

Estimates standard deviation based on a sample, including numbers, text, and logical values 
STDEVA(value1,value2,…) 

Calculates standard deviation based on the entire population 
STDEVP(number1,number2,…) 

Calculates standard deviation based on the entire population, including numbers, text, and logical values 
STDEVPA(value1,value2,…) 

Estimates variance based on a sample 
VAR(number1,number2,…) 

Estimates variance based on a sample, including numbers, text, and logical values 
VARA(value1,value2,…) 

Calculates variance based on the entire population 
VARP(number1,number2,…) 

Calculates variance based on the entire population, including numbers, text, and logical values 
VARPA(value1,value2,…) 
Logical functions
Returns TRUE if all of its arguments are TRUE 
AND(logical1,logical2,..) 

Specifies a logical test to perform 
IF(logical_test,value_if_true, value_if_false) 

Reverses the logic of its argument 
NOT(logical) 

Returns TRUE if any argument is TRUE 
OR(logical1,logical2,..) 

Returns the logical value FALSE 
FALSE() 

Returns the logical value TRUE 
TRUE() 
Text functions
Returns the character specified by the code number 
CHAR(number) 

Returns a numeric code for the first character in a text string 
CODE(text) 

Joins several text items into one text item 
CONCATENATE(text1,text2,…) 

Checks to see if two text values are identical 
EXACT(text1,text2,…) 

Finds one text value within another (casesensitive) 
FIND(find_text,within_text, start_num) 

Returns the leftmost characters from a text value 
LEFT(text,num_chars) 

Returns the number of characters in a text string 
LEN(text) 

Converts text to lowercase 
LOWER(text) 

Returns a specific number of characters from a text string starting at the position you specify 
MID(text,start_num,num_chars) 

Capitalizes the first letter in each word of a text value 
PROPER(text) 

Replaces characters within text 
REPLACE(old_text,start_num, num_chars,new_text) 

Repeats text a given number of times 
REPT(text,number_times) 

Returns the rightmost characters from a text value 
RIGHT(text,num_chars) 

Converts its arguments to text 
T(value) 

Removes spaces from text 
TRIM(text) 

Converts text to uppercase 
UPPER(text) 

Converts a text argument to a number 
VALUE(text) 
Date and time functions
Returns the serial number of a particular date 
DATE(year,month,day) 

Converts a date in the form of text to a serial number 
DATEVALUE(date_text) 

Converts a serial number to a day of the month 
DAY(serial_number) 

Calculates the number of days between two dates based on a 360day year 
DAYS360(start_date,end_date, method) 

Converts a serial number to an hour 
HOUR(serial_number) 

Converts a serial number to a minute 
MINUTE(serial_number) 

Converts a serial number to a month 
MONTH(serial_number) 

Returns the serial number of the current date and time 
NOW() 

Converts a serial number to a second 
SECOND(serial_number) 

Returns the serial number of a particular time 
TIME(hour, minute,second) 

Converts a time in the form of text to a serial number 
TIMEVALUE(time_text) 

Returns the serial number of today’s date 
TODAY() 

Converts a serial number to a day of the week 
WEEKDAY(serial_number, return_type) 

Converts a serial number to a year 
YEAR(serial_number) 
Financial functions
Returns the depreciation of an asset for a specified period by using the doubledeclining balance method or some other method that you specify 
DDB(cost,salvage,life,period,factor) 

Returns the future value of an investment 
FV(rate,nper,pmt,pv,type) 

Returns the interest payment for an investment for a given period 
IPMT(rate,per,nper,pv,fv,type) 

Returns the internal rate of return for a series of cash flows 
IRR(values,guess) 

Returns the number of periods for an investment 
NPER(rate,pmt,pv,fv,type) 

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate 
NPV(rate,value1,value2,..) 

Returns the periodic payment for an annuity 
PMT(rate,nper,pv,fv,type) 

Returns the payment on the principal for an investment for a given period 
PPMT(rate,per,nper,pv,fv,type) 

Returns the present value of an investment 
PV(rate,nper,pmt,fv,type) 

Returns the interest rate per period of an annuity 
RATE(mper,pmt,pv,fv,type,guess) 

Returns the straightline depreciation of an asset for one period 
SLN(cost,salvage,life) 

Returns the sumofyears’ digits depreciation of an asset for a specified period 
SYD(cost,salvage,life,per) 
Information functions
Returns a number corresponding to an error type 
ERROR.TYPE(error_val) 

Returns TRUE if the value is blank 
ISBLANK(value) 

Returns TRUE if the value is any error value except #N/A 
ISERR(value) 

Returns TRUE if the value is any error value 
ISERROR(value) 

Returns TRUE if the value is a logical value 
ISLOGICAL(value) 

Returns TRUE if the value is the #N/A error value 
ISNA(value) 

Returns TRUE if the value is not text 
ISNONTEXT(value) 

Returns TRUE if the value is a number 
ISNUMBER(value) 

Returns TRUE if the value is a reference 
ISREF(value) 

Returns TRUE if the value is text 
ISTEXT(value) 

Returns a value converted to a number 
N(value) 

Returns a number indicating the data type of a value 
TYPE(value) 
Lookup and reference functions
Returns a reference as text to a single cell in a worksheet 
ADDRESS(row_num,column_num, abs_num,a1,sheet_text)) 

Chooses a value from a list of values 
CHOOSE(index_num,value1, value2,…) 

Returns the number of columns in a reference 
COLUMNS(array) 

Looks in the top row of an array and returns the value of the indicated cell 
HLOOKUP(lookup_value, table_array,row_index_num, range_lookup) 

Uses an index to choose a value from a reference or array 
INDEX(…) 

Returns the number of rows in a reference 
ROWS(array) 

Looks in the first column of an array and moves across the row to return the value of a cell 
VLOOKUP(lookup_value, table_array,column_index_num, range_lookup) 
Nice work. I’ve been thinking of upgrading to the Pro to get the direct cloud storage (I use DropML heaps now), is it much better than standard? Is Adobe faster at scrolling docs?
Thanks
Sorry to say that QuickOffice Pro for Symian^3 does not include the Acrobat Reader LE 2.5 app, which is sold separately. This has always been the case with QuickOffice limited to QuickWord, QuickSheet and QuickPoint and it’s integrated file manager app.
The cloud side of QuickOffice Pro for Symian^3 works a dream and a review of this and other features is to follow.
Thanks! Sad to hear about adobe not being integrated into the deal.
I tried to download the trial from the Quickoffice website but it didn’t change a thing after I installed it.
I got it for my kindle fire… what I wanted was to be able to do Data validation lists… I have spreadsheets that use lists created with the data validation function. How can I enable this in Quick office pro… It is the only reason I bought. Otherwise, please recommend a solution. Last time I checked it could not be done in google spreadsheets either
I do not even know how I ended up here, but I
thought this post was good. I don’t know who you are but definitely you’re
going to a famous blogger if you aren’t already 😉 Cheers!