Reference no: EM131334689
Spreadsheet Exercise
1. Run the spreadsheet program in your computer and type the following:
|
|
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
PAYROLL
|
|
2
|
XYZ COMPANY
|
Employee Name
|
Department
|
Degree
|
Salary
|
Need Increase?
|
|
3
|
Nasser
|
Mechanical
|
Master
|
15000
|
|
|
4
|
Waleed
|
Electrical
|
Master
|
9500
|
|
|
5
|
Hasan
|
Management
|
PH.D
|
17000
|
|
|
6
|
Khalid
|
Electrical
|
Bachelor
|
8000
|
|
|
7
|
Naif
|
Chemical
|
Bachelor
|
6500
|
|
|
8
|
Mshari
|
English
|
Diploma
|
9500
|
|
|
9
|
Abdullah
|
General
|
Master
|
13500
|
|
|
10
|
Talal
|
Mechanical
|
Diploma
|
8650
|
|
|
11
|
Brekan
|
Electrical
|
PH.D
|
20000
|
|
|
12
|
Nasser
|
Management
|
Master
|
19000
|
|
|
13
|
Hamad
|
Electrical
|
PH.D
|
14500
|
|
|
14
|
The number of employees in the electrical department is
|
|
2. Save the workbook as spreadsheet-exercise-04-YourldNumber in your folder.
3. Calculate the values of Need Increase? Column as follows: If the employee's salary is greater than or equal to 10000, then it is "NO" otherwise "YES".
4. Make 6 copies of sheet 1 and name them as filter a, filter b, filter c, and filter f.
5. Show the following information using the Filter feature in the corresponding sheet
a. The employees whose name is Nasser
b. The employees whose degree is Master
c. The employees whose department is Electrical
d. The employees whose salary is less than 9000 or is greater than 14000
e. The employees whose department is mechanical or management.
f. The employees whose name ends with d.
6. By using Conditional Formatting feature, format all the cells of the degree column that contain the word PH.D. The format is: Green Fill with Dark Green Text.
7. Calculate the number of employees in the electrical department
8. Type your first and last name, your ID number, and section number at the end of the worksheet.
9. Save the changes to the workbook.
|
Find the ethical conflict
: Discuss the interrelationships between the dictates of the ethical issues and those of the professional practice. How might they work together - Developing a Practical Ethical Viewpoint (Have you clearly picked and stated an Ethical Viewpoint)
|
|
Why do we need microeconomics
: Why do we need microeconomics? What makes Perfect competitive firm efficient market? Explain the elasticity of demand and taxes.
|
|
Describe the open source software and how it works
: In MS PowerPoint, create a presentation with slides that describe the open source software and how it works. Discuss the role this open source software has in management information systems.
|
|
Deliver and evaluate a global talent management strategy
: How does an organization design, deliver and evaluate a global talent management strategy?- Which talent management indicators would you include in the Standard Chartered's human capital scorecard?
|
|
Calculate the number of employees in electrical department
: Calculate the number of employees in the electrical department. Type your first and last name, your ID number, and section number at the end of the worksheet.
|
|
What are the major issues related to global t and d
: What are the major issues related to global T&D?- How can the effectiveness of global virtual teams be improved?
|
|
Nordic and scandinavian management culture at tietoenator
: What are the characteristics of the Nordic and Scandinavian management culture at TietoEnator?- What ways can a company use to leverage its knowledge resources globally?
|
|
Influence the economy growth rate
: The government uses policies like student loans and free trade to influence the economy's growth rate. Write a thoughtful and articulate paper that includes the following:
|
|
Address inflation and unemployment
: Compare and contrast the different stages of the business cycle and how inflation and unemployment vary via these different stages. Then discuss the appropriate fiscal and monetary policies to address inflation and unemployment.
|