Identifies the highest number in the listĬounts the number of numerical items in the listĬounts the number of alphabetical items in the listĬounts the number of items that satisfy certain criteriaĮ.g. SUM and AVERAGE are two of the most common, below are a few more: There are many functions that you could explore with time. The address of the first cell in the list is A3.Ī colon : separates this cell address from the last cell in the list, which is A30.Īdds list of values from cell B3 to cell B9Īverages the values from cell B3 to cell B9 The list of numbers is indicated in brackets. SUM is a function, meaning that it sums (adds up) the list of numbers. These formulas are used for working with long lists of numbers. Subtract the value (number) in C2 from the value (number) in A2. That way, if a value changes in a cell, the answer to the formula changes with it.Īdd the value (number) in A2 to the value (number) in C2. Refer to the cell address instead of the value in the cell e.g. Press Enter once you have typed the formula. Notice also that the labels (composed of letters) are all left justified and the values (composed of numbers) are all right justified in their cells.Ĭlick the cell in which you want the answer (result of the formula) to appear. The numbers, which can later be used in formulas, are called values. Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data.Īll words describing the values (numbers) are called labels.
0 kommentar(er)
