**Working with the Excel Environment **

Excel allows us to calculate numerical information using formulas. In Module 2, we learn how to use cell references to create formulas. In order to create a formula, we need to learn about Excel standard operators for formulas. These operators are a **plus sign (+)** for addition, a **minus sign (-)** for subtraction, an **asterisk (*) **for multiplication, a **forward slash (/)** for division, and a **caret** **(^)** for exponents. Excel uses = sign to start a formula, and that cell must be equal to the formula which is calculated for.

** **

Source: http://www.gcflearnfree.org/excel2013/13

Excel 2013 uses features like the **Ribbon** and **Quick Access** toolbar to perform common tasks. The Ribbon in Excel 2013 uses a tabbed Ribbon system rather the traditional menu. Below is the description of the different tabs in Excel 2010-2013.

**Understanding cell references**

A cell is recognized by its address. The intersection of a columns and a row represent a cell address. For instance, column B and row 3 is the cell B3. The cell value is the value of what we calculate for a specific cell. For instance, if we B1 = 15, B2 = 25, then the value of B3 = B1+B2 or B3 = 15+25=40, therefore, the value of B3 = 40 as shown below.

In formula section we have, Fx =A1+A2

15 |

25 |

B1+B2= 40 |

Please review the following link and watch the following section videos.

Refer to tutorials at http://www.gcflearnfree.org/excel2013

- Formatting Cells
- Worksheet Basics
- Page Layout
- Printing Workbooks
- Simple Formula
- Complex Formulas
- Relative Absolute Cell References
- Functions

**SLP Assignment **

Please note that SLP 2 Assignment has the following exercises and basic spreadsheet exercises from the Abacus Training site.

Use the table below to do the following.

A | B | C | D |

11 | 30 | 36 | |

20 | 2 | 70 | |

31 | 11 | 35 | |

45 | 35 | 14 | |

= A1+A2+A3+A4

= B4 – B2

= C4/B2

= C3/5

A4^2

Write the cell address according above table for the following:

Gas used for June | 36 | |

Gas used for May | 45 | |

Total used gas | 81 |

- Use the below table to calculate the total for each item; however, instead of manual work, use the formula function. For example, to calculate each item, you need to do the following.

- Place = on the formula bar in the Total column
- Multiple Quantity X Unit Price in the Total column

Fast Shop | ||||||

Item | Quantity | Unit price | Total | |||

Lighter | 25 | $1.99 | ||||

Pepsi | 17 | $1.73 | ||||

Hot dog | 47 | $1.05 | ||||

Ice bag | 11 | $2.21 | ||||

After completing the Excel exercise above, please continue developing the Abacus Excel spreadsheet exercises located at http://www.abacustraining.biz/Exercises/Excel/BasicSS/BasicSS_EX006.htm and as noted below.

Exercise 1 – Sales for the Month

Exercise 2 – Sales and Produce Department

Exercise 3 – Mike’s Stationery Order

Create an Excel file with designated folders 1-4 to develop the above exercises.