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:
I. 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.
II. Close the worksheet.
III. Locate the assignment file Module1-exercise and open it.
IV. 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:
|
|
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.
|
Add numbers in columns:
|
|
A
|
B
|
C
|
|
1
|
2
|
1
|
254
|
|
2
|
23
|
3
|
7523
|
|
3
|
2
|
3
|
234
|
|
4
|
7
|
48
|
105
|
|
5
|
23
|
68
|
22
|
|
6
|
|
|
|
V. 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.
SLP Assignment Expectations
Your assignments will be following these expectations:
• The assignment file must be developed in Excel and saved as .xls file.
• Precision: the questions asked are answered.
• 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.