Indiana State University IF Function Practice Excel Worksheet I need help to answering questions and making some changes into excel document Is flight dome

Indiana State University IF Function Practice Excel Worksheet I need help to answering questions and making some changes into excel document Is flight domestic or international? If Domestic, display the word True in Column E
Flight #
Airport
Type of flight:
Ticket Price:
BC1
Buffalo
Domestic
299
23XP
Amsterdam
International
759
WN1
Cleveland
Domestic
329
K2N4
Mexico City
International
449
5N7P
Belize City
International
389
Average Ticket Price:
Calculate average of Test 1 and Test 2. For students who got a 60 Average or better, say Pass, for those lower, say Fail
Passing is 60% or better
Name
Test 1
Test 2
Average of Tests
BEEBE, Gala
75
60
BISI, Julia
45
74
BOLAT, Linda
85
83
BRINNEL, Andee
99
48
BRYAN, Valery
100
100
CARUSO ,Grace
63
64
CASILLAS-LUNA, Araceli I.
86
55
Average Test Scores:
Which products are we keeping? Manager says anything less than 15% of Quarterly total sales must be retired.
April
May
June
Exercise Bikes
22657
26805
13393
Ellipitical Machines
29659
18599
19088
Treadmills
24590
19950
18545
Rowing Machines
28366
21553
16728
Weight Bench
29784.3
22630.65
17564.4
Power Tower
19258.45
22784.25
11384.05
Monthly Totals:
How much were this week’s sales? If at least $6500, they get 1% of their salary as a bonus; if less than that, they get flat $250
Employee
Current Salary
This Week sales
Commission
ADAIR, Maggie
98890
8240.833333
ADAMS, Debbie
74569
6214.083333
ARMSTRONG, Lori
82861
6905.083333
AUDETTE, Loree
47322
3943.5
AYALA, Henrietta
94458
7871.5
BEEBE, Gala
31676
2639.666667
BISI, Julia
55837
4653.083333
BOLAT, Linda
BRINNEL, Andee
63806
79837
5317.166667
6653.083333
What was the highest commission? Use a function:
Regular week is 40 hours; anything over 40 hours someone should be paid time and a half (1.5 times hourly rate) of their OT
Employee
Dept
HireDate
Hourly Rate
Blackwell, Dorian
InfoServices
4/12/1984
$18.00
Carter, Sasha
SalesOffice
12/19/1993
$11.00
Chavez, Kevyn
SalesOffice
6/2/1982
$11.00
Church, Deacon
InfoServices
10/2/2006
$21.00
Richards, Wayne
Purchasing
11/13/1987
$13.00
Rivers, Maggie
InfoServices
2/11/2014
$14.00
Schwartz, Eden
Marketing
8/28/2019
$11.00
Shepard, Pandora
Marketing
6/2/1982
$18.00
Strickland, Lawrence
Marketing
10/8/2014
$12.00
Tanner, Fritz
InfoServices
2/25/2008
$19.00
Welch, Mira
Purchasing
1/12/2008
$16.00
Wilkinson, Gemma
SalesOffice
8/5/1992
$21.00
Taxes are 5% of the Sold Price of Property
Agent Comission:
Marion Livingston:
3.5% of Sold Price
Karen or Elizabeth:
2.5% of Sold Price
Dallas County Sal
Listing Number
971108
962528
691977
665784
656597
650680
235641
228286
Sold Price
850653
766396
700286
1117147
663245
1044617
1000742
642159
List Price
ROOMS
851502
776556
707919
1494197
693013
1374635
1144968
692333
19
28
20
28
16
10
14
17
True or False?
say Pass, for those lower, say Fail
Pass or Fail
otal sales must be retired.
Quarterly Totals:
% to Total
onus; if less than that, they get flat $250
Status
half (1.5 times hourly rate) of their OT hours
EmpCategory
CurrWeekHours
Exempt
Exempt
Exempt
NonExempt
NonExempt
NonExempt
NonExempt
NonExempt
Exempt
NonExempt
NonExempt
Exempt
Totals:
Note: Write G to show only regular hours, and then Column H should be F – G
Reg Hours
OT Hours Reg Pay OT Pay
38
44
38
43
42
47
38
47
49
43
35
40
Dallas County Sales
BEDRMS
BATHRMS
9
9
6
9
6
6
7
7
AGE
4
6
3
9
3
4
3
5
ACRES
97
58
60
38
47
102
17
15
0.64
0.33
0.33
2.6
0.25
3.85
2
0.25
TAXES
AGENT
Marion Livingston
Marion Livingston
Elizabeth Glover
Marion Livingston
Karen Hom
Marion Livingston
Marion Livingston
Marion Livingston
then Column H should be F – G
Gross Pay:
Agent Commission
Use this space to store values:
Reg Work week Hours:
Overtime Pay Differential:
40
1.25
Excel 3 20 pts
This homework assignment is for IF Function practice.
Every section should be completed with a fillable IF function written in the top row, and filled down for
the section. That should be done in the highlighted blue cells (on your file).
Some sections need some additional cell calculations to use as a basis for your IF function. All functions
should be written completely with cell references. Find a section (as I did in my pictures below) to store
and label any necessary cells.
To expand on any of these pictures – simply click on them and adjust the borders.
Finished product pictures:
Excel 3 20 pts

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
Indiana State University IF Function Practice Excel Worksheet I need help to answering questions and making some changes into excel document Is flight dome
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Top quality papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional academic writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

Free revisions

If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.

On-time delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & confidential

We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.

Admissions

Admission help & business writing

You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.

Reviews

Editing your paper

Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.

Reviews

Revising your paper

Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers