EXCEL CALCULATIONS
CONTENT
- Introduction
- Addition: Using the SUM Function
- Subtraction: Using the IMSUB Function
- Average
- Count
- Multiplication
- Division
- Printing of Worksheet
Introduction
The basic and most powerful feature of Microsoft Excel is the ability to accept formula into the worksheet. A Formula is an instruction that is entered to tell Excel how to Add, Subtract, Multiply, Divide, or otherwise perform calculation by using the content of other cells. It is advisable to construct formula that makes reference to cells in the worksheet so that the result can be instantly generated even the values are changed.
When working on Excel calculations, the following guidelines should be considered;
- To enter a formula, first select the cell that will contain the formula.
- All formula must begin with equal (=) sign tells Excel to treat the cells contents as a formula.
- The formula should not be more than 1024 characters.
- The function name (e.g. SUM, AVERAGE) which is preceded by equal (=) sign must be selected and followed by the desired argument, i.e.
You are viewing an excerpt of this lesson. Subscribing to the subject will give you access to the following:
- NEW: Download the entire term's content in MS Word document format (1-year plan only)
- The complete lesson note and evaluation questions for this topic
- The complete lessons for the subject and class (First Term, Second Term & Third Term)
- Media-rich, interactive and gamified content
- End-of-lesson objective questions with detailed explanations to force mastery of content
- Simulated termly preparatory examination questions
- Discussion boards on all lessons and subjects
- Guaranteed learning