Volume II – Unit 1: Microsoft Excel 2016
Session 1: Formulas
A. Introduction
In MS Excel, we can compute from basic arithmetic to Statistics using formulas. But one thing should be sure for it to work, you have to follow the syntax. This session will cover formulas, its elements, the frequently used formulas, and their corresponding syntaxes.
B. Specific Objectives
At the end of this session, the trainees should be able to:
- Memorize the symbols needed in typing formulas.
- Type the syntax for the different formulas.
- Compute mathematical problems using formulas.
C. Materials
- Laptop/Desktop
- Trainer’s Manual
- Speaker
- Headset
D. Activities
3. Demonstration: Computing with MS Excel
In this instance, we are going to apply different formulas in MS Excel. Open a blank Excel file, save it as Formulas – your name and we will solve simple mathematical problems through these steps:
- In cell A3, type Formulas.
- In cell A5, type Getting the Sum as the column header.
- In cell A6, type =5+6 then press Enter.
- Press the Up arrow and listen to what NVDA says.
- It says, “11 has formula.”
- Once you hear NVDA that way, it means that the cell you focused on has a formula.
- You can press Ctrl + ` on the focused cell to display the formula you typed.
- Pressing Ctrl + ` on the same cell will return to the displayed result.
- In cell A 7, type 5 and in cell A8, type 6.
- In cell A9, type =A7+A8.
- In cell A10, type =A6+A7+A9.
- In cell A11, type =A6+A7+A8+A9+A10).
Did you get the results? That is how to compute numbers in MS Excel using formulas. Here are some helpful formulas for you to compute other mathematical problems that you may encounter in your daily lives:
Shape | Perimeter | Area |
Triangle | = 3s | = 1/2 x b x h |
Square | = 4s | = l x w |
Rectangle | = 2(l) + 2(w) | = l x w |
Circle | = 2 (Pi) (r ) | = (Pi) (r ) 2 |
Copying a Formula
We are now going to demonstrate how to copy formulas from one cell to another.
- Go to Cell B5 and type Getting the Total.
- Type any numbers in cell B7 to B10.
- Execute the copy command on cell A11.
Note: Once you have copied the data, avoid pressing any key except the arrow keys for navigation. Pressing an unrelated key, especially Escape will remove the highlight of the copied data.
- Go to cell B11.
- Go to Home
- In the Clipboard group, tab to Paste split button and open the menu.
- Scroll down to Paste Special… and press Enter. The Paste Special dialog box opens.
- You can also use the context menu for pasting by pressing the Application
- Scroll down to Paste Special… and press Enter. The Paste Special dialog box opens.
You can also press Ctrl + V on a focused cell to paste the formula that you copied.
You can download the full version of this lesson through this link: Volume II – Unit 1: Microsoft Excel 2016
Want a full version of this manual? Join our training of trainers. Watch-out for the announcements of trainings here on our website or like and visit our official Facebook page at https://www.facebook.com/atrievofficial.
See you there!