Information about Excel

 
Formulas are equations that perform calculations on values in your worksheet. A formula always starts with an equal sign (=).

 
You can create a simple formula by using constants and calculation operators. For example, the formula =5+2*3 multiplies two numbers and then adds a number to the result. Microsoft Office Excel follows the standard order of mathematical operations. In the preceding example, the multiplication operation (2*3) is performed first, and then 5 is added to its result.

 
You can also create a formula by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2.

Depending on the type of formula that you create, a formula can contain any or all of the following parts.

-------------------------------------------------

Functions-- A function, such as PI(), starts with an equal sign (=). For many functions, such as SUM(), you can enter arguments within its parentheses. Each function has a specific argument syntax. Some arguments require exactly one argument, others require or allow several arguments (that is, some arguments might be optional), and some other functions allow no arguments at all - such as PI().

 
Cell references You can refer to data in worksheet cells by including cell references in the formula. For example, the cell reference A2 returns the value of that cell or uses that value in the calculation.

 
Constants You can also enter constants, such as numbers (such as 2) or text values, directly into a formula.

 
Operators Operators are the symbols that are used to specify the type of calculation that you want the formula to perform. For example, the ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.

-------------------------------------------------

To achieve the calculation result that you want, you can use a single function, nested functions, or arrays that calculate single or multiple results.

--------------------------------------------------Create a simple formula by using constants and calculation operators
 

2.Type = (equal sign).

Type the constants and operators that you want to use in the calculation.

 
Example formula

=5+2 (Adds 5 and 2)

=5-2  (Subtracts 2 from 5)

=5/2  (Divides 5 by 2)

=5*2  (Multiplies 5 times 2)

=5^2  (Raises 5 to the 2nd power)

Note:  For the next few months there will be additional information about Excel

New Technology 2012 

Internet Advances - Internet of Things 

The Internet of Things (IoT) is a concept that describes how the Internet will expand as sensors and intelligence are added to physical items such as consumer devices or physical assets and these objects are connected to the Internet. 

The vision and concept have existed for years, however, there has been an acceleration in the number and types of things that are being connected and in the technologies for identifying, sensing and communicating. These technologies are reaching critical mass and an economic tipping point over the next few years. Key elements of the IoT include:

Embedded sensors: Sensors that detect and communicate changes are being embedded, not just in mobile devices, but in an increasing number of places and objects.

Image Recognition: Image recognition technologies strive to identify objects, people, buildings, places logos, and anything else that has value to consumers and enterprises. Smartphones and tablets equipped with cameras have pushed this technology from mainly industrial applications to broad consumer and enterprise applications.

Cecile Bendavid  

CEO Computers, Inc.