itm301 slp 1

profileberard6

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:

  1. Open the Excel software.
    1. You will see a blank worksheet. Click on the file tab and click Save As.
    2. Next to File name, type Module1-exercise.
    3. Choose where on your computer to save the file, and click the Save button.
  2. Close the worksheet.
  3. Locate the assignment file Module1-exercise and open it.
  4. 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.

Add numbers in rows:
 ABCDE
2597551       
3     
4421700985854 
5     
633526578996559876 
713151721 
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.

Add numbers in columns:
 ABC
121254
22337523
323234
4748105
5236822
6   
  1. 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.

  1. Enter the following data and use Calibri font size 11 pt. and AutoFit text to column width.  
  2. Change the fonts and size to Georgia and 14 pt., then AutoFit to column width again. 
    1. Jack Johnson
    2. Rayon Robinson
    3. Alex Hollywood
  3. Change page orientation and change margin to “narrow.” Save the file.

Desired margin: Narrow.

Save your file.

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

    • 8 years ago
    • 20
    Answer(3)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      itm301_slp_1.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      itm_301_module_1_slp_data_information_and_organizational_knowledge.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      module1.zip
    Bids(1)