Question: Need help with question 5 &6 ood euu 9:320. Wlhecty in the nested function. Copy the function from J8 to the range Enter a nested

Need help with question 5 &6

ood euu 9:320. Wlhecty in the nested function. Copy the function from J8 to the range Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specfic 4 sales record. For example, using the current data, you want the function to return the third Click the Database worksheet tab and enter conditions in the Criteria Range for Domestic sales reps that made 240000 or more in sales. Perform an advanced filter er to copy the new 6 In cell J7, enter a database function to calculate the number of reps meeting the carteria. In cell 8, enter a database function to calculate the highest total sales for records meetingo 8 the criteria. In cell J9, enter a database function to calculate the average sales for records meeting the criteria. Words: 21/670C pter 12.pp

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 Databases Questions!

Points Possible Step Download and open the file named exploring e0Z grader al Salesxdsx, and then save the file as exploring_e07_grader_al_Sales LastFirst, replacing LastEicst with your name. 0.000...

EX16_XL_CH07_GRADER_CAP_AS - Sales Data 1.6 This is an excel grader project. P lease include a detailed explanation of steps and multiple screenshots of the excel spreadsheets. That would be amazing...

I need help with this homework! Here are clearer photos that are more zoomed in as well. Step Points Possible Instructions Download and open the file named exploring e07 grader al Sales.xlsx, and...

EX16_XL_CH07_GRADER_CAP_AS - Sales Data 1.3 Project Description: Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the...

2 On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 3 On the Sales...

Hello! I am in an Info System Fundamentals class, and need help desperately on this homework. If you could explain step-by-step how to complete these questions I'd be so grateful! Below are the...

EX16_XL_CH07_GRADER_CAP_AS - Sales Data 1.0: PROJECT DESCRIPTION - Your assistant created a spreadsheet that lists names, hire dates, quarterly sales, and total sales for 2018. You will calculate the...

2. On the Sales worksheet, enter a date function in cell C8 to calculate the number of years the first representative has worked for your company. Copy the function to the range C9:C20. 7 3 7 On the...

Help, I done step 2, and 3. I just need from 4th and on... ' EX16 XL CH07 GRADER CAP AS Sales Data 1.1 Project Description: Your assistant created a spreadsheet that lists names, hire dates,...

The third picture is the sales tab the second is database tab and the third is the addition tab. Instructions Step Download and open the file named exploring ed7_grader al Sales.xlsx, and then save...

Refer to the information for Adrian Express in E125. Industry averages for the following profitability ratios are as follows: Gross profit ratio ...... 25% Return on assets ........ 15% Profit margin...

Kohlbeck Corporation, a manufacturer of steel products, began operations on October 1, 2011. The accounting department of Kohlbeck has started the fixed-asset and depreciation schedule presented on...

Saving for Retirement. You plan to retire in 4 0 years. To provide for your retirement, you initiate a savings program of $ 4 , 0 0 0 per year yielding 7 percent. What will be the value of the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

5. How does the protean career concept differ from the traditional career concept on the following dimensions: pattern, development sources, goal, and responsibility for management?

9. If you were asked to develop a career management system, what would it look like? How might you evaluate whether it was effective? What information would you use to develop the system?

7. What are the managers roles in a career management system? Which role do you think is most difficult for the typical manager? Which is easiest? List the reasons why managers might resist...