Good Example Of Excel’s Advanced Formulas & Functions Essay

Question#1.

Excel is widely used in web pages to help in the business. For example, using on-line Excel spreadsheet manufacturers can submit information about the prices of products on their websites. The advantage of the online versions of Excel is the ability to remotely use the same file by different users. For example, in maykrosoftovskih online document editor Office Web Apps (accessible through SkyDrive and Office 365) have already worked for some time collaborative editing.
Question#2.
Reference is a cell addresses in the formula that you want to count. Sometimes a relative reference Excel, absolute or mixed. Indicating the cell address in the formula, we give the computer a cell reference that you want to add, multiply, etc. Automatically when writing formulas placed relative references.
Relative reference is when copying and transferring of formulas to another location in the formulas change cell addresses relative to the new location.
But sometimes you need to reference in the copied cells remained unchanged, the cell address has not changed. Then come to the aid of an absolute reference Excel. To do this in front of the column name and the name of the line in the formula put the sign "$". For example: a relative reference «A1», but an absolute reference “$A$1”. Now the copy of this cell with an absolute reference to another position in the table, the cell will not change the address. This is necessary when, for example, added rows, columns in a table.
Question#3.
The formula syntax defines the structure and order of the formula. Formulas in Microsoft Excel follow a certain syntax, which includes an equal sign (=), calculated members (operands) and operators. The operands may be: constant references or range references, titles, names or functions.
  By default, Microsoft Excel calculates the formula from left to right, starting with the calculation of the equal sign (=). Using the syntax of writing formulas can manage the process of calculation. For example, the following formula returns the number 11, since multiplication has higher priority over the addition and, therefore, is performed in the first place: the multiplication of the first 2 to 3 (the result of the multiplication is 6), and then the resultant value is added to 5.
 =5+2*3
When syntax changes for use parentheses, the addition occurs first 5 and 2, and then multiplying the result by 3. The following formula returns the number 21.