Homework Help is Here – Start Your Trial Now!
Math
Statistics
What are the formulas for Q#(A) to (k).  there is the correct answers for reference below.

What are the formulas for Q#(A) to (k).  there is the correct answers for reference below.

College Algebra
College Algebra
10th Edition
ISBN:9781337282291
Author:Ron Larson
Publisher:Ron Larson
Chapter6: Systems Of Equations And Inequalities
Section: Chapter Questions
Problem 17PS: Cholesterol Cholesterol in human blood is necessary, but too much can lead to health problems. There...
See similar textbooks
icon
Related questions
Question

What are the formulas for Q#(A) to (k). 
there is the correct answers for reference below. 

AutoSave OFF Home Paste G20 A Insert 20 March 21 March 22 April 23 April 24 April 25 April 26 May 27 May 28 May 29 May 30 June 31 June 32 June 33 June 34 July 35 July 36 July 37 July 38 Aug 39 Aug 40 Aug 41 Aug 42 Sep 43 Sep 44 Sep 45 Sep 46 Oct 47 Oct 48 Oct 49 Oct 50 Nov 51 Nov 52 Nov 53 Nov 54 Dec 55 Dec 56 Dec 57 Dec 58 59 60 61 19 March Owen Smith V A B C Page Layout X Calibri B Draw BIUV H Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Yes C Yes Yes Yes Yes No No Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes Yes Yes Yes No Yes Yes Yes Bailey Cunningham Yes Meredith Palmer Brenden Calderon Owen Smith No Yes Bailey Cunningham Yes Meredith Palmer Yes Brenden Calderon Yes Owen Smith No Yes Yes Yes Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Yes Yes Yes D Open recovered workbooks? Your recent changes were saved. Do you want to continue working X ✓ fx Compute the Minimum monthly sales generated by Owen Smith when 91 138 123 119 V 11 133 134 113 124 93 100 109 134 135 91 91 132 91 107 113 115 136 103 127 120 99 139 129 120 93 117 118 102 121 102 123 103 131 97 138 V E F (J) Q# Formulas V ✓ A A А. (J) Data Review View Te (K) = 20 == = = = = = V ab v (K) Compute the Minimum monthly sales generated by Owen Smith when the tar Correct Answer M G H 1 J K L Compute the Maximum monthly sales generated by Brenden Calderon when met Questions asked by Sales Manager (A) Compute the total number of times the target was met across all salespe Compute the total Sales generated in the month of March (B) (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (E) Compute the total number of times the target was met by Brenden Calder (F) Compute the total sales generated by Bailey Cunrt tham when the target (G) Compute the average Sales generated by Owen Smith when the target wa (H) Compute the Maximum monthly sales generated by Brenden Calderon (1) Compute the Minimum monthly sales generated in the month of April Compute the Maximum monthly sales generated by Brenden Calderon whe target was met Compute the Minimum monthly sales generated by Owen Smith when the NOT met
Transcribed Image Text:AutoSave OFF Home Paste G20 A Insert 20 March 21 March 22 April 23 April 24 April 25 April 26 May 27 May 28 May 29 May 30 June 31 June 32 June 33 June 34 July 35 July 36 July 37 July 38 Aug 39 Aug 40 Aug 41 Aug 42 Sep 43 Sep 44 Sep 45 Sep 46 Oct 47 Oct 48 Oct 49 Oct 50 Nov 51 Nov 52 Nov 53 Nov 54 Dec 55 Dec 56 Dec 57 Dec 58 59 60 61 19 March Owen Smith V A B C Page Layout X Calibri B Draw BIUV H Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Yes C Yes Yes Yes Yes No No Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes Yes Yes Yes No Yes Yes Yes Bailey Cunningham Yes Meredith Palmer Brenden Calderon Owen Smith No Yes Bailey Cunningham Yes Meredith Palmer Yes Brenden Calderon Yes Owen Smith No Yes Yes Yes Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Yes Yes Yes D Open recovered workbooks? Your recent changes were saved. Do you want to continue working X ✓ fx Compute the Minimum monthly sales generated by Owen Smith when 91 138 123 119 V 11 133 134 113 124 93 100 109 134 135 91 91 132 91 107 113 115 136 103 127 120 99 139 129 120 93 117 118 102 121 102 123 103 131 97 138 V E F (J) Q# Formulas V ✓ A A А. (J) Data Review View Te (K) = 20 == = = = = = V ab v (K) Compute the Minimum monthly sales generated by Owen Smith when the tar Correct Answer M G H 1 J K L Compute the Maximum monthly sales generated by Brenden Calderon when met Questions asked by Sales Manager (A) Compute the total number of times the target was met across all salespe Compute the total Sales generated in the month of March (B) (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (E) Compute the total number of times the target was met by Brenden Calder (F) Compute the total sales generated by Bailey Cunrt tham when the target (G) Compute the average Sales generated by Owen Smith when the target wa (H) Compute the Maximum monthly sales generated by Brenden Calderon (1) Compute the Minimum monthly sales generated in the month of April Compute the Maximum monthly sales generated by Brenden Calderon whe target was met Compute the Minimum monthly sales generated by Owen Smith when the NOT met
Home Insert 2 3 AutoSave OFF 4 G20 5 Paste Month Salesperson 9 10 Jan 11 Jan 12 Jan 13 Jan 14 Feb 15 Feb 16 Feb 17 Feb 18 March 19 March 20 March 21 March 22 April 23 April 24 April 25 April 26 May 27 May 28 May 29 May 30 June 31 June 32 June 33 June 34 July 35 July 36 July 37 July 38 Aug 39 Aug 40 Aug 41 Aug 42 Sep A B C Page Layout Ready Draw Calibri BI U v Owen Smith A B с E F G H He has asked you some questions, you need to construct Excel Formula to answer his queries. Most of his questions can be answered by creating formula using Countl F, SumIF, Averagel F, CountIFS, SumIFS, AveragelFS, MAXIFS, MINIFS functions Questions asked by the manager is mentioned in the G10 to G20. Your answers should be in N10 to N20. Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X вести fx Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met Target Met Yes Yes Yes Yes No No Yes Yes Yes Yes D Yes Yes Yes Bailey Cunningham Yes Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham No Meredith Palmer No Brenden Calderon Yes Owen Smith Yes Bailey Cunningham No Meredith Palmer Brenden Calderon Owen Smith Yes Yes Yes Yes Yes No Yes Yes Bailey Cunningham No Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Yes Meredith Palmer No Brenden Calderon Yes Yes Yes Instructions Sales Amount ($ '000) 120 128 114 132 140 109 92 104 130 91 ✓ 138 123 119 133 134 113 124 93 100 109 134 135 91 91 132 91 107 113 115 136 103 127 120 11 P1 Accessibility: Investigate Q# (G) (H) (1) (5) *** Q# Formulas Data Review View Tell me Α' Α΄ A V (J) = (K) = 三三三 P2 1 J (A) Compute the total number of times the target was met across all salesperson (B) Compute the total Sales generated in the month of March (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (E) Compute the total number of times the target was met by Brenden Calderon (F) Compute the total sales generated by Bailey Cunningham when the target was met Questions asked by Sales Manager K (K) Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met Correct Answer ab Wrap Text v L Merge & Center v Questions asked by Sales Manager Compute the average Sales generated by Owen Smith when the target was met Compute the Maximum monthly sales generated by Breen Calderon Compute the Minimum monthly sales generated in the month of April Compute the Maximum monthly sales generated by Brenden Calderon when the target was met (A) Compute the total number of times the target was met across all salesperson (B) Compute the total Sales generated in the month of March (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (F) (E) Compute the total number of times the target was met by Brenden Calderon Compute the total sales generated by Bailey Cunningham when the target was met (G) Compute the average Sales generated by Owen Smith when the target was met (H) Compute the Maximum monthly sales generated by Brenden Calderon (1) Compute the Minimum monthly sales generated in the month of April SampleAnswer + M Compute the Maximum monthly sales generated by Brenden Calderon when the target was met NOT met Compute the Minimum monthly sales generated by Owen Smith when the target was MiniCase9_144 Your Answer N Your Answer General 10 1009 115.44 140.00 $ % 9 38 482 1360 118.33 113 134 91 482 0 O
Transcribed Image Text:Home Insert 2 3 AutoSave OFF 4 G20 5 Paste Month Salesperson 9 10 Jan 11 Jan 12 Jan 13 Jan 14 Feb 15 Feb 16 Feb 17 Feb 18 March 19 March 20 March 21 March 22 April 23 April 24 April 25 April 26 May 27 May 28 May 29 May 30 June 31 June 32 June 33 June 34 July 35 July 36 July 37 July 38 Aug 39 Aug 40 Aug 41 Aug 42 Sep A B C Page Layout Ready Draw Calibri BI U v Owen Smith A B с E F G H He has asked you some questions, you need to construct Excel Formula to answer his queries. Most of his questions can be answered by creating formula using Countl F, SumIF, Averagel F, CountIFS, SumIFS, AveragelFS, MAXIFS, MINIFS functions Questions asked by the manager is mentioned in the G10 to G20. Your answers should be in N10 to N20. Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? X вести fx Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met Target Met Yes Yes Yes Yes No No Yes Yes Yes Yes D Yes Yes Yes Bailey Cunningham Yes Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham No Meredith Palmer No Brenden Calderon Yes Owen Smith Yes Bailey Cunningham No Meredith Palmer Brenden Calderon Owen Smith Yes Yes Yes Yes Yes No Yes Yes Bailey Cunningham No Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Meredith Palmer Brenden Calderon Owen Smith Bailey Cunningham Yes Meredith Palmer No Brenden Calderon Yes Yes Yes Instructions Sales Amount ($ '000) 120 128 114 132 140 109 92 104 130 91 ✓ 138 123 119 133 134 113 124 93 100 109 134 135 91 91 132 91 107 113 115 136 103 127 120 11 P1 Accessibility: Investigate Q# (G) (H) (1) (5) *** Q# Formulas Data Review View Tell me Α' Α΄ A V (J) = (K) = 三三三 P2 1 J (A) Compute the total number of times the target was met across all salesperson (B) Compute the total Sales generated in the month of March (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (E) Compute the total number of times the target was met by Brenden Calderon (F) Compute the total sales generated by Bailey Cunningham when the target was met Questions asked by Sales Manager K (K) Compute the Minimum monthly sales generated by Owen Smith when the target was NOT met Correct Answer ab Wrap Text v L Merge & Center v Questions asked by Sales Manager Compute the average Sales generated by Owen Smith when the target was met Compute the Maximum monthly sales generated by Breen Calderon Compute the Minimum monthly sales generated in the month of April Compute the Maximum monthly sales generated by Brenden Calderon when the target was met (A) Compute the total number of times the target was met across all salesperson (B) Compute the total Sales generated in the month of March (C) Compute the total Sales generated by Owen Smith (D) Compute the average Sales generated by Meredith Palmer (F) (E) Compute the total number of times the target was met by Brenden Calderon Compute the total sales generated by Bailey Cunningham when the target was met (G) Compute the average Sales generated by Owen Smith when the target was met (H) Compute the Maximum monthly sales generated by Brenden Calderon (1) Compute the Minimum monthly sales generated in the month of April SampleAnswer + M Compute the Maximum monthly sales generated by Brenden Calderon when the target was met NOT met Compute the Minimum monthly sales generated by Owen Smith when the target was MiniCase9_144 Your Answer N Your Answer General 10 1009 115.44 140.00 $ % 9 38 482 1360 118.33 113 134 91 482 0 O
Expert Solution
steps

Step by step

Solved in 7 steps with 11 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS