E-Mail : support@onlinemathsguru.com
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 for addition, a for subtraction, an for multiplication, a for division, and a for exponents. Excel uses = sign to start a formula, and that cell must be equal to the formula which is calculated for. Source: Excel 2013 uses features like the and 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. 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 Please review the following link and watch the following section videos. Refer to tutorials at 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. = A1+A2+A3+A4 = B4 – B2 = C4/B2 = C3/5 A4^2 Write the cell address according above table for the following: After completing the Excel exercise above, please continue developing the Abacus Excel spreadsheet exercises located at 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.