Microsoft Office Excel is the most common application used to work with relatively small amounts of data. This spreadsheet editor provides the ability to use a fairly wide set of built-in functions for mathematical and statistical processing of user-entered values. Often such functions require specifying the range of table cells from which they should take data for their work.
Necessary
spreadsheet editor Microsoft Office Excel
Instructions
Step 1
Start Microsoft Excel, load the required table, position the cursor in the cell where the formula should be placed and click on the corresponding icon to the left of the formula bar. In the dialog that opens, find the desired function, select it and click the OK button. The Formula Insert Wizard will open a dialog box and position the cursor in the first field of the form.
Step 2
Select with the mouse the required range of table cells - it can be several cells in one of the columns or rows, or an entire area that includes a set of cells of several rows and columns. If you want to specify an entire column or row as a range of cells, just click on its heading. Excel itself will encode everything that you have selected as needed, and will place the corresponding record in the form field where the input cursor is located.
Step 3
Repeat this operation to specify the desired range in each field as required. After you finish entering the function arguments and click OK, the formula, along with the ranges, will be placed in the table cell.
Step 4
You can enter a range of cells "manually", that is, do not use the ability of the spreadsheet editor to automatically detect and convert the selected area with the mouse to the corresponding record. To do this, after turning on the mode for editing the contents of a cell with a formula (F2), place the cursor in the place where the range indication should be placed. Then enter a reference to the first (top left) cell, put a colon and enter a reference to the last (bottom right) cell.
Step 5
Typically, a link contains one or two letters of the Latin alphabet (indicates a column) and a number (indicates a string). However, if a different link style is specified in the settings, then both of its parts will be numbers, but before the column number you will need to put the letter C (this is an English letter), and before the row number - R. To refer to all cells of a row or column, do not specify both parameters required - for example, the entire column D can be labeled D: D.
