# ITM 301 Module 1 SLP Latest-Trident

\$22.00

Categories: , .

## ITM 301 Module 1 SLP Latest-Trident

ITM 301 Module 1 SLP Latest-Trident

ITM301

ITM 301 Module 1 SLP Latest-Trident

Module 1 – SLP

DATA, INFORMATION, AND ORGANIZATIONAL KNOWLEDGE

In this module, you will be introduced to Excel and some of its basic functions. After watching the recommended videos, do the following:

Open the Excel software.

You will see a blank worksheet. Click on the file tab and click Save As.

Next to File name, type Module1-exercise.

Choose where on your computer to save the file, and click the Save button.

Close the worksheet.

Locate the assignment file Module1-exercise and open it.

Enter the following data into the worksheet, starting from cell A2 (the intersection of column A and row 2) on the left side, and perform the functions below. For the three exercises below, you can use the same Excel worksheet with proper spacing between each assignment. Always remember to save the file to your local drive every so often.

For the first table, add the numbers in cells A2 through D2 and give a sum in cell E2. Add the numbers in the next three rows and give sums in the E column.

A B C D E

2 5 9 75 51

3

4 421 700 985 854

5

6 3352 6578 99655 9876

7 13 15 17 21

8

For the second table, add cells A1 through A5 and give a sum total in cell A6. Do the same in columns B and C respectively.

A B C

1 2 1 254

2 23 3 7523

3 2 3 234

4 7 48 105

5 23 68 22

6

Use Save As to make a copy as Module 1- Exercise 2.

Create a third table within the same Excel worksheet and perform the following.

Enter the following data and use Calibri font size 11 pt. and AutoFit text to column width.

Change the fonts and size to Georgia and 14 pt., then AutoFit to column width again.

Jack Johnson

Rayon Robinson

Alex Hollywood

Change page orientation and change margin to “narrow.” Save the file.

Desired margin: Narrow.

After completing the Excel exercises, please upload the Excel file with your results to SLP 1 Dropbox.

SLP Assignment Expectations