>Logic Formulas
. In column M, if the employee is from , then enter a “1” in column M, otherwise enter a “ ”
0, then place the salary in the cell in column N, otherwise do not enter anything (leave blank).
. In column O, if the employee has a master’s degree and more than years of professional experience then place the the employee ID in the corresponding O cell, otherwise place “No promotion”
department or department, place “1” in the corresponding cell, otherwise place a “0” (zero).
1 15 5
2 0 2 Bachelor’s 2 2 Maryland Full Time Ms. 2 981
Software Development Bachelor’s 2 5 Full Time Developer Ms. 2 37
Finance/Accounting Bachelor’s 2 4 Virginia Full Time Ms. 2 Software Development $47 Bachelor’s 2 1 Full Time Developer Mr. 1 Finance/Accounting Bachelor’s 2 3 New York Full Time Analyst Mr. 1 11
Software Development Bachelor’s 2 2 Delaware Full Time Developer Ms. 2 Software Development $52 Bachelor’s 2 3 Maryland Full Time Developer Ms. 2 IT Bachelor’s 2 6 New York Full Time IT Specialist Mr. 1 Software Development Bachelor’s 2 4 Virginia Full Time Developer Ms. 2 Finance/Accounting Bachelor’s 2 6 Maryland Full Time Ms. 2 Finance/Accounting Bachelor’s 2 4 Virginia Full Time Analyst Ms. 2 Software Development Bachelor’s 2 5 Delaware Full Time Developer Ms. 2 Sales $68 Bachelor’s 2 8 New York Full Time Ms. 2 Sales Bachelor’s 2 5 New York Full Time Manager Ms. 2 Bachelor’s 2 7 New York Full Time Mr. 1 Software Development $39 1 4 Delaware Full Time Developer Mr. 1 Software Development High School 1 5 Maryland Full Time Developer Ms. 2 Finance/Accounting High School 1 3 Maryland Full Time Analyst Mr. 1 138
Software Development 3 1 Maryland Full Time Manager Ms. 2 Master’s 3 20 Virginia Full Time Senior Staff Mr. 1 Master’s 3 26 Virginia Full Time Senior Staff Mr. 1 Master’s 3 18 New York Full Time CEO Software Development $39 Bachelor’s Maryland Full Time Developer Software Development $45 Bachelor’s Delaware Full Time Developer Finance/Accounting $47 Bachelor’s Virginia Full Time Analyst Software Development $52 Bachelor’s Delaware Full Time Developer Software Development $59 Master’s Maryland Full Time Manager Mr. Software Development Bachelor’s New York Developer Ms. Software Development Bachelor’s New York Part Time Developer Ms. Sales Bachelor’s Virginia Part Time Representative
2
LOGIC FORMULAS
1
Virginia
0
2. In column N, if the employee’s salary is less than
6
3
4
4. In column P, if the employee is in the
Finance/Accounting
Sales
Name
Title
Title Code
Employee ID
Job Series
Salary in $1000
Degree
Degree Code
Yrs. Prof. Experience
Home State
Work Schedule
Rank
Logic Formula 1
Logic Formula 2
Logic Formula 3
Logic Formula 4
Uniform
Mr.
5
8
Software Development
$39
Bachelor’s
Maryland
Full Time
Developer
Sierra
Ms.
31684
IT
$44
IT Specialist
Foxtrot
2
7
$45
Delaware
Mike
1
20
$47
Analyst
Whiskey
76744
New York
Oscar
62958
$48
X-ray
3
18
$52
Quebec
34441
Juliet
82912
$55
Delta
96689
$56
Papa
10641
$61
Manager
Echo
29584
$62
Lima
49776
$68
India
47611
Representative
Hotel
24581
$71
Golf
13302
Analytics
$85
Senior Staff
November
47389
High School
Victor
44791
$41
Romeo
73891
$49
Yankee
26
$59
Master’s
Bravo
96491
CIO
$135
Charlie
76850
CFO
$143
Alpha
96572
CEO
$155
PivotTables
PIVOT TABLES
1. Using the below data set, create a pivot table with its upper corner at or near cell L6. This pivot table needs to show the average
salary for all employees by degree level (Bachelor’s degre average salary, Master’s degree average salary, High School degree
average salary).
2. Using the below data set, create a pivot table with its upper left corner at or near cell L20. This pivot table needs to show only
people having a Master’s degree; show the count of each job series by home state.
Name Title Employee ID Job Series Salary in $1000 Degree Home State Work Schedule Rank
Uniform Mr.
51585
Sierra Ms. 31684 IT $44 Bachelor’s Maryland Full Time IT Specialist
Foxtrot Ms.
27981
Mike Ms.
12037
Whiskey Ms. 76744 Software Development $47 Bachelor’s New York Full Time Developer
Oscar Mr. 62958 Finance/Accounting $48 Bachelor’s New York Full Time Analyst
X-ray Mr.
31811
Quebec Ms. 34441 Software Development $52 Bachelor’s Maryland Full Time Developer
Juliet Ms. 82912 IT $55 Bachelor’s New York Full Time IT Specialist
Delta Mr. 96689 Software Development $56 Bachelor’s Virginia Full Time Developer
Papa Ms. 10641 Finance/Accounting $61 Bachelor’s Maryland Full Time Manager
Echo Ms. 29584 Finance/Accounting $62 Bachelor’s Virginia Full Time Analyst
Lima Ms. 49776 Software Development $68 Bachelor’s Delaware Full Time Developer
India Ms. 47611 Sales $68 Bachelor’s New York Full Time Representative
Hotel Ms. 24581 Sales $71 Bachelor’s New York Full Time Manager
Golf Ms. 13302 Analytics $85 Bachelor’s New York Full Time Senior Staff
November Mr. 47389 Software Development $39 High School Delaware Full Time Developer
Victor Mr. 44791 Software Development $41 High School Maryland Full Time Developer
Romeo Ms. 73891 Finance/Accounting $49 High School Maryland Full Time Analyst
Yankee Mr.
26138
Bravo Ms. 96491 CIO $135 Master’s Virginia Full Time Senior Staff
Charlie Mr. 76850 CFO $143 Master’s Virginia Full Time Senior Staff
Alpha Mr. 96572 CEO $155 Master’s New York Full Time CEO
Kilo
19547
$24
Part Time
Tango
49040
$25
Zulu
53729
$31
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.