ITM 301 MODULE 2 SLP LATEST-TRIDENT

1 / 4

ITM 301 MODULE 2 SLP LATEST-TRIDENT - PowerPoint PPT Presentation

nVisit Below Link, To Download This Course:nnhttps://www.tutorialsservice.net/product/itm-301-module-2-slp-latest-trident/nnOr nEmail us onnSUPPORT@TUTORIALSSERVICE.NETnnITM 301 Module 2 SLP Latest-TridentnITM301nITM 301 Module 2 SLP Latest-TridentnModule 2 â€“ SLPnIT GOVERNANCE AND DECISION MAKINGnWorking with the Excel EnvironmentnExcel 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.n

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

ITM 301 MODULE 2 SLP LATEST-TRIDENT

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

ITM 301 MODULE 2 SLP LATEST-TRIDENT

https://www.tutorialsservice.net/product/itm-301-module-2-slp-latest-trident/

Or

Email us on

SUPPORT@TUTORIALSSERVICE.NET

ITM 301 Module 2 SLP Latest-Trident

ITM301

ITM 301 Module 2 SLP Latest-Trident

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.

SLP2 Excel Operations

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 (video 9)

Worksheet Basics (video 10)

Page Layout (video 11)

Printing Workbooks (video 12)

Simple Formula (video 13)

Complex Formulas (video 14)

Relative Absolute Cell References (video 15)

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

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

Lighter

Pepsi

Hot dog

Ice bag

Quantity

25

17

47

11

Unit price

\$1.99

\$1.73

\$1.05

\$2.21

Total

After completing the Excel exercise above, please continue developing the Abacus Excel spreadsheet

Concepts-Exercises.pdf 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.

SLP Assignment Expectations

The SLP should be developed in Excel. Your assignments will be graded following these expectations:

Clarity: Your answers are clear and show your good understanding of the topic.

Breadth and depth: The scope covered in your paper is directly related to the questions of the

assignment and the learning objectives of the module.

Critical Thinking:It is important to read the “required readings” posted in the background

material plus others you find relevant. Your paper should include important concepts from these

readings and incorporate your reactions and examples that illustrate your reflective judgment and

good understanding of the concepts.