Excel- Labels, Values, and Formulas
Excel Labels, Values, and Formulas Labels and 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. All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values. 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. Simple Formula: Click the cell in which you want the answer (result of the formula) to appear. Press Enter once you have typed the formula. All formulas start with an = sign. Refer to the cell address instead of the value in the cell e.g. =A2+C2 instead of 45+57. That way, if a value changes in a cell, the answer to the formula changes with it.
Functions These formulas are used for working with long lists of numbers. A typical function looks like this: =SUM(A3:A30)
Other functions: There are many functions that you could explore with time. SUM and AVERAGE are two of the most common, below are a few more:
|
This work is licensed under a  Creative Commons Attribution 3.0 United States License