S h e e t

 

MOD(number,divisor)

Returns the remainder from division.

MONTH(serial_number)

Converts a serial number to a month.

N(value)

Returns a value converted to a number.

NOW( )

Returns the serial number of current date and time.

NPV(rate,value1,value2,...)

Returns the net present value of an investment based on a

 

series of periodic cash flows and a discount rate.

OFFSET(refernce,rows,cols,height,width)

Returns a reference to a range that is a specified number of

 

rows and columns from a cell or range of cells.

PERMUT(number, number_chosen)

Returns the number of permutations for a given number of

 

items.

PI( )

Returns the value of pi.

PMT(rate,nper,pv,fv,type)

Returns the periodic payment for an annuity.

POWER(number,power)

Returns the result of a number raised to a power.

PRODUCT(number1,number2,..)

Multiplies its arguments.

PROPER(text)

Capitalises the first letter in each word of a text value.

PV(rate,nper,pmt,fv,type)

Returns the present value of an investment.

RADIANS(angle)

Converts degrees to radians.

RAND( )

Returns a random number between 0 and 1.

RATE(nper,pmt,pv,fv,type,guess)

Returns the interest rate period of an annuity.

REPLACE(old_text,start_num,num_chars,new_text)

Replaces characters within text.

REPT(text,number_times)

Repeats text a given number of times.

RIGHT(text,num_chars)

Returns the last character or characters from a text value.

ROUND(number,num_digits)

Rounds a number to a specified number of digits.

ROW(row)

Returns the row number of the specified row.

ROWS(array)

Returns the number of rows in a reference.

SECOND(serial_number)

Converts a serial number to a second.

SIGN(number)

Returns the character for the number.

SIN(number)

Returns the sine of the given angle.

SLN(cost,salvage,life)

Returns the straight-line depreciation of an asset for one

 

period.

SQRT(number)

Returns a positive square root.

STDEV(number1,number2,...)

Estimates standard deviation based on a sample.

STDEVP(number1,number2,...)

Calculates standard deviation based on the entire population.

STRING( )

Converts a number to text according to the given format string.

SUM(number1,number2,...)

Adds its arguments.

SUMPRODUCT(array1,array2,…)

Returns the sum of the multiplied arrays.

SUMSQ(array1,array2)

Returns the sum of the squares.

SYD(cost, salvage, life, per)

Returns the sum-of-years’ digits depreciation of an asset for a

 

specific period.

T(value)

Converts its arguments to text.

TAN(number)

Returns the tangent of a number.

TERM( )

Calculates the number of payments for an investment, given

 

the periodic payment amount P, the interest rate R, and future

 

value FV.

Copyright © 2004 Nokia. All Rights Reserved.

47

Page 47
Image 47
Nokia 9500 manual Rand

9500 specifications

The Nokia 9500 Communicator, launched in 2004, stands as a landmark device in the evolution of mobile technology, blending the features of a smartphone with the functionality of a handheld computer. It was part of Nokia's Communicator series, which was known for its advanced features, and the 9500 was particularly significant due to its innovative design and robust capabilities.

One of the standout features of the Nokia 9500 is its distinctive clamshell design. When closed, it resembles a traditional mobile phone, compact and easy to carry. However, upon opening, the device reveals a full QWERTY keyboard and a large display, offering an exceptional typing experience for those who frequently send emails or create documents on the go. The keyboard is spacious and tactile, making it ideal for productivity tasks.

The 9500 is equipped with the Symbian OS, specifically the Series 80 user interface, which was optimized for the Communicator's unique form factor. Users could multitask efficiently, switching between applications seamlessly, which was a remarkable feature for its time. It supported various productivity applications including calendar, contacts, and word processing, enhancing its appeal to business users.

In terms of connectivity, the Nokia 9500 offers a range of options. It includes support for GPRS, providing users with internet access even while on the move. Wi-Fi capabilities further expanded its utility, allowing for faster data transfer rates and easier access to the internet in hot spots. Bluetooth technology was also included, enabling wireless data sharing with other devices.

The device features a 640x200 pixel display, which was impressive for its time, ensuring that both text and images were clear and easily readable. The Nokia 9500 also came with a camera, which was a novelty for mobile devices in the early 2000s, allowing users to capture images on the go.

Another important aspect of the 9500 is its battery life. It was designed to support extended usage, making it a reliable choice for professionals who needed to stay connected throughout the day. The device also supported expandable memory through a miniSD card slot, providing further flexibility for users to store more data.

In summary, the Nokia 9500 Communicator was a pioneering device that combined the functionalities of a mobile phone and a laptop. With its robust design, keyboard, productivity applications, and connectivity options, it set a foundation for future smartphones, showcasing what mobile computing could achieve long before the era of modern smartphones.