Question: In cell C4 , using the Asset ID in C3 , use HLOOKUP to find the Employee ID assigned to C3's asset ID. Then nest

  1. In cell C4, using the Asset ID in C3, use HLOOKUP to find the Employee ID assigned to C3's asset ID. Then nest that formula into a VLOOKUP formula as the lookup value to find the name of the assigned employee. Use the following named ranges.
  2. In cell C8, create a SUMIFS formula to return the sum of the pay for employees in the Legal department. Use the defined names for the array ranges.
  3. In cell C9, create an AVERAGEIFS formula to find the average pay of full-time employees in the IT department. Use the following named ranges.
    • Department: IT
    • Job_Type: FTE

Complete the following tasks on the Sales Level sheet:

  1. Select cell D2 and create an IFS formula to determine the employee's sales level based on their level number.
  2. Select the range C2:C38 and only allow whole numbers between 1 a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Heres a detailed answer for the tasks based on the available information Cell C4 Use the HLOOKUP fun... View full answer

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 General Management Questions!

Q:

In cell C 4 , using the Asset ID in C 3 , use HLOOKUP to find the Employee ID assigned to C 3 ' s asset ID . Then nest that formula into a VLOOKUP formula as the lookup value to find the name of the...

Q:

Complete the following tasks on the Query sheet: In cell C4 , using the Asset ID in C3 , use HLOOKUP to find the Employee ID assigned to C3's asset ID. Then nest that formula into a VLOOKUP formula...

Q:

In cell C 4 , using the Asset ID in C 3 , use HLOOKUP to find the Employee ID assigned to C 3 ' s asset ID . Then nest that formula into a VLOOKUP formula as the lookup value to find the name of the...

Q:

1) In cell D4, enter a formula that calculates customer tenure, in years, using absolute and structured references. The formula should calculate tenure based on subtracting the value in the First...

Q:

Sam Project for Advanced functions and conditional formatting Excel 2013 I am having trouble with questions 14-19. Assignment do tomorrow Computer Software 178 New Perspectives Excel 2013 Tutorial 8:...

Q:

PROJECT STEPS 1. Go to the CustomerList worksheet and complete the following actions: a. Apply a conditional formatting rule to the range A4:A32 that formats any duplicate values with Yellow Fill...

Q:

Please just write the formulas of the ones that require it! Thank you 1. Alex Makula is a project manager for the Content Shop, an online firm based in New Haven, Connecticut, that provides written...

Q:

a. b. PROJECT STEPS 1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and has offered to compile data on the swim club employees and teams. She needs your...

Q:

PROJECT STEPS 1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melboume, Forida, and has offered to complle data on the swim club employees and teams, She needs your help...

Q:

Unit 6 AS2: Mastering Excel Attached Fles: 06 Mastering Instructions.docx (449.198 KB) 06. Mastering Starting file.xlsx (19.029 KB) The purpose of this assignment is to exhibit the skills learned in...

Q:

(GUN) manufactures gold jewelry in India from gold imported using contracts denominated in USD. Presently the company has no hedging strategy for its market risks. It plans to buy a significant...

Q:

Write the specification on design simple full-screen editor on video display terminal documentation to use exceptions.

Q:

Concealment of income or false claims to reduce tax liability are cases of - - - - - - Question 4 Answer a . Tax evasion b . Tax planning c . Tax avoidance d . Tax management

Q:

Is this correct or should I have included the negative? The per-unit standards for direct materials are 2.6 pounds at $5.18 per pound. Last month, 3,100 pounds of direct materials that actually cost...