Question Details

ITM 301 Module 2 SLP
IT GOVERNANCE AND DECISION MAKING
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
1.	Formatting Cells [video 9]
2.	Worksheet Basics [video 10]
3.	Page Layout [video 11]
4.	Printing Workbooks [video 12]
5.	Simple Formula [video 13]
6.	Complex Formulas [video 14]
7.	Relative Absolute Cell References [video 15]
8.	Functions [video 16]
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	 
7.	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 athttp://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.