Question: Study the screenshot below. It shows some information for employees working at a company XYZ Inc. The codes F and M represent females and males

Study the screenshot below. It shows some information for employees working at a company XYZ Inc. The codes F and M represent females and males respectively; PT and FT represent Part time and Full time respectively. We want to know the total salaries paid out to female employees working in the Sales department. A B D XYZ Inc. Employee Part time/ Monthly 2 Name Gender Department Full time Salary 3 Julia F Sales PT $ 1,500 4 Marks M Sales FT $ 3,500 5 Simon M Finance FT $ 4,500 Hari F Sales FT $ 4,000 7 Timmy M Finance FT $ 4,800 8 Johnson F Quality Assurance FT $ 2,500 9 Lena M RD FT $ 3,500 S 10 Padmini F Human Resources FT $ 4,300 11 Singh M Sales FT $ 3,000 29 12 Parata M Sales PT $ 2,200 13 Persaud F Human Resources PT $ 2,500 38 14 King M Manufacturing FT $ 3,750 15 Queen F Sales FT $ 3,200 16 Will M Manufacturing FT $ 3,500 Finish 17 Jimmy M Quality Assurance FT $ 3,700 18 Kary RD FT $ 4,200 Following are the formats of the COUNTIFS and SUMIFS functions: COUNTIFS(criteria_range1, criteria1, criteria_range2, criteria2....) =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2....) Which of the following functions would accomplish this? (This question is worth 2 marks) Select one: O a. =COUNTIFS(E3:E18. B3:818, "F". C3:C18, "Sales") O b. =SUMIFS(83:818, "F",C3:C18,"Sales", E3:E18) C. =COUNTIFS(B3:B18, "f, C3:C18, "Sales", E3:E18) Activate O d. =SUMIFS(A3:E18, B3:B18, Sales, C3:(18, F) Go to Setting O e. =SUMIFS(E3:E18. B3:B18, "F", C3:(18, "Sales")

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

In this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset. Steps Open the Heart Rate Excel Data Set and identify the quantitative variables...

You need to make business plan for music company. company name is mg3. you can make plan according to you im attaching example of plan of another company, you can get idea from that example. do like...

importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...

Given the findings presented by Desir et al. 2010, what evidence do they provide that might explain why there were so many people who opposed the proposed standard to enhance disclosures on expected...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

I've attached the assignment as a word file, thanks! You can use the class readings for this week's assignments. c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page...

Multiple Choice Questions 1. Suppose 2 identical copper bars, A and B, with initial temperatures of 25C and 75C, respectively, are placed in contact with each other. If the specific heat of copper is...

On September 1, Flint Office Supply had an inventory of 30 calculators at a cost of $12 each. The company uses a perpetual inventory system. During September, the following transactions occurred....

I've always believed that business should not exist in isolation from the world around it. As someone working in the nonprofit sector, I see how much impact organizations can have when they choose to...

Brad was hired as a new security engineer to build a new security network infrastructure for Zee Corp. Zee e-Commerce systems was not properly protected against cyber-attack. One major safeguards...