Each cell holds information which can be a label, a value, date or a formula,
Share
Each cell holds information which can be a label, a value, date or a formula,
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Explanation:
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.
+ means add
e.g. A2+C2
Add the value (number) in A2 to the value (number) in C2.
- means subtract
e.g. A2-C2
Subtract the value (number) in C2 from the value (number) in A2.
* means multiply
e.g. A2*4
Multiply the value (number) in A2 by 4.
/ means divide
e.g. A2/3
Divide the value (number) in A2 by 3.