Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In cell E4 enter an INDEX function that incorporates the INDIRECT function for the array argument to retrieve the bonus amount the event coordinator will

In cell E4 enter an INDEX function that incorporates the INDIRECT function for the array argument to retrieve the bonus amount the event coordinator will receive. Format the result as Accounting and copy the formula down through E9.image text in transcribedimage text in transcribedimage text in transcribed

File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Comments X Calibri - A A WA a Wrap Text General 2? O 4 6 i Insert DX Delete It Format Pasta BIU Av Sensitivity E Merge & Center Conditional Format as Cell Formatting Table Styles Sart & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity E4 x A B D E F G . 1 j L N 1 Event Analysis 2 3 4 Bonus EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-C32 EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study TotalRegistrants 23 66 27 38 21 24 Action Goal_Met Promote Event Goal_Met Promote_Event Goal Met Promote Event Registration Goals EventID RegistrationGoal EVNT-0037 20 EVNT 0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ S Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $ 160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ $ $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $ 150.00 $ 180.00 $ 200.00 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $ 110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $90.00 $ 110.00 $ 130.00 $ 150.00 ClientRegistration EventDetails EventAnalysis + File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Share Commer X Insert Calibri v 11 - A ' + V 2 Wrap Text Custom === Es DX Delete Paste BIU ;-;- : A $ -% - ) Merge & Center Sensitivity Conditional Format as Cell Formatting Table Styles Styles Formal Sort & Find & Filter Select Editing Analyze Data Analysis Clipboard Fant Alignment Number Cells Sensitivity Event Details EVNT-0037 B C D E F H 1 J K 1 Event Details 2 3 4 5 6 EventID EventName EventType Registration Fee EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $ 120.00 EVNT-0012 January HR Peer Networking Peer Networking $ 180.00 EVNT-0042 Toyota Plant Tour Plant Tour $ 250.00 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $ 190.00 EVNT-0017 Human Resource Professionals Peer Networking $ 110.00 EVNT-0032 State of the Industry Survey/Study $ 180,00 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ClientRegistration EventDetails EventAnalysis + + RY M Average 19-Jun-op Count 24 Sum: 25-Oct-02 File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Comments X Calibn 11 - A A ab Wrap Text General L 2PG 4 Insert DX Delete Format Paste BIU A + Merge & Center $ -% -3 Conditional Format as Formatting Table Styles Styles Sensitivity Surt & Find Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity 111 X D E F H K Client Registrations 2 3 4 5 6 7 Board Member Discounts Discount EventType 5% Annual Conference 5 5% Peer Networking 7% Plant Tour 10% Survey/Study 9 9 Registration Fees Board Member Discount Event Discount Friends Discount 10 Guests Board Member Yes 12 1 2 1 1 2 15 Yes Yes Yes Contact Firstname CN-0001 Charity CN-0003 Justin CN-0004 Sydnee CN-0005 Blake CN-0006 Christine CN-0007 Cassidy CN-0008 Sloane CN-00010 Wing CN-00011 Avram CN-00012 Adena CN-00013 Barrett CN-00014 Angelica CN 00015 Christine CN-00016 Kevyn CN-00020 Heidi CN-00022 Rebecca CN-00023 Josephinc CN-00025 Fiona CN-00026 Jeremy CN 00027 Dora Lastname Calhoun Wallace Washington Bryan Tyson Lowe Shaffer Oneil Conrad Henry Gurizales Marquez Hughes Lara Estes Greene Henson Oneil Sullivan Delacruz Company Name SEA-LECT Plastics Corporation SMT LLC Southern Indiana Plastics Southwest Molding SPI Industries Inc Stcinwall Inc Stihl Incorporated Tasus Corporation - Alabama Tasus Corporation - Texas Team 1 Plastics Technical Industries Inc. Thogus Products Company Trademark Plastics Inc. Treemen Industries Inc Vantec Inc Venture Plastics Wabash Plastics Inc. GTM Plasties Inc. GTR Enterprises Hansen Plastics Corporation 17 18 19 20 21 22 23 24 25 26 27 Date Registered 11-Jan-191 17-Dec-18 16-Feb-18 09-Feb-19 07-Apr-19 30-Mar-181 23-Jul-191 17-Feb-18 05-May-18 22-Aug-18 01-Apr-18 01-Nov-18 14 Jun 19 10-Mar-18 21-Jul-18 28-Nov-19 24-May-181 01-Jul-18 04-Feb-18 22-Jun-18 EventID EVNT-0037 EVNT-0037 EVNT-0012 EVNT-2017 EVNT-00412 EVNT-0022 EVNT-0022 EVNT-0042 EVNT-0017 EVNT-0022 EVNT-0012 EVNT-0037 EVNT 0037 CVNT-0022 EVNT-0017 EVNT-0022 EVNT-0032 EVNT-2012 EVNT-0032 EVNT-0022 1 1 5 1 1 3 Yes 2 1 1 3 1 1 Yes Yes 1 3 2 1 29 30 71 32 33 34 ClientRegistration Event Details EventAnalysis + File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Comments X Calibri - A A WA a Wrap Text General 2? O 4 6 i Insert DX Delete It Format Pasta BIU Av Sensitivity E Merge & Center Conditional Format as Cell Formatting Table Styles Sart & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity E4 x A B D E F G . 1 j L N 1 Event Analysis 2 3 4 Bonus EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-C32 EventType Annual Conference Peer Networking Plant Tour Plant Tour Peer Networking Survey/Study TotalRegistrants 23 66 27 38 21 24 Action Goal_Met Promote Event Goal_Met Promote_Event Goal Met Promote Event Registration Goals EventID RegistrationGoal EVNT-0037 20 EVNT 0012 70 EVNT-0042 25 EVNT-0022 40 EVNT-0017 20 EVNT-0032 25 Annual Conference Peer Networking Plant Tour Survey/Study $ $ $ S Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $ 160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ $ $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $ 150.00 $ 180.00 $ 200.00 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $ 110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $90.00 $ 110.00 $ 130.00 $ 150.00 ClientRegistration EventDetails EventAnalysis + File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Share Commer X Insert Calibri v 11 - A ' + V 2 Wrap Text Custom === Es DX Delete Paste BIU ;-;- : A $ -% - ) Merge & Center Sensitivity Conditional Format as Cell Formatting Table Styles Styles Formal Sort & Find & Filter Select Editing Analyze Data Analysis Clipboard Fant Alignment Number Cells Sensitivity Event Details EVNT-0037 B C D E F H 1 J K 1 Event Details 2 3 4 5 6 EventID EventName EventType Registration Fee EVNT-0037 2019 Benchmarking Conference Attendee Annual Conference $ 120.00 EVNT-0012 January HR Peer Networking Peer Networking $ 180.00 EVNT-0042 Toyota Plant Tour Plant Tour $ 250.00 EVNT-0022 Marsh Bellofram Plant Tour Plant Tour $ 190.00 EVNT-0017 Human Resource Professionals Peer Networking $ 110.00 EVNT-0032 State of the Industry Survey/Study $ 180,00 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ClientRegistration EventDetails EventAnalysis + + RY M Average 19-Jun-op Count 24 Sum: 25-Oct-02 File Home Insert Draw Page Layout Formulas Data Review View Help 3 Share Comments X Calibn 11 - A A ab Wrap Text General L 2PG 4 Insert DX Delete Format Paste BIU A + Merge & Center $ -% -3 Conditional Format as Formatting Table Styles Styles Sensitivity Surt & Find Filter Select Editing Analyze Data Clipboard Font Alignment Number Cells Analysis Sensitivity 111 X D E F H K Client Registrations 2 3 4 5 6 7 Board Member Discounts Discount EventType 5% Annual Conference 5 5% Peer Networking 7% Plant Tour 10% Survey/Study 9 9 Registration Fees Board Member Discount Event Discount Friends Discount 10 Guests Board Member Yes 12 1 2 1 1 2 15 Yes Yes Yes Contact Firstname CN-0001 Charity CN-0003 Justin CN-0004 Sydnee CN-0005 Blake CN-0006 Christine CN-0007 Cassidy CN-0008 Sloane CN-00010 Wing CN-00011 Avram CN-00012 Adena CN-00013 Barrett CN-00014 Angelica CN 00015 Christine CN-00016 Kevyn CN-00020 Heidi CN-00022 Rebecca CN-00023 Josephinc CN-00025 Fiona CN-00026 Jeremy CN 00027 Dora Lastname Calhoun Wallace Washington Bryan Tyson Lowe Shaffer Oneil Conrad Henry Gurizales Marquez Hughes Lara Estes Greene Henson Oneil Sullivan Delacruz Company Name SEA-LECT Plastics Corporation SMT LLC Southern Indiana Plastics Southwest Molding SPI Industries Inc Stcinwall Inc Stihl Incorporated Tasus Corporation - Alabama Tasus Corporation - Texas Team 1 Plastics Technical Industries Inc. Thogus Products Company Trademark Plastics Inc. Treemen Industries Inc Vantec Inc Venture Plastics Wabash Plastics Inc. GTM Plasties Inc. GTR Enterprises Hansen Plastics Corporation 17 18 19 20 21 22 23 24 25 26 27 Date Registered 11-Jan-191 17-Dec-18 16-Feb-18 09-Feb-19 07-Apr-19 30-Mar-181 23-Jul-191 17-Feb-18 05-May-18 22-Aug-18 01-Apr-18 01-Nov-18 14 Jun 19 10-Mar-18 21-Jul-18 28-Nov-19 24-May-181 01-Jul-18 04-Feb-18 22-Jun-18 EventID EVNT-0037 EVNT-0037 EVNT-0012 EVNT-2017 EVNT-00412 EVNT-0022 EVNT-0022 EVNT-0042 EVNT-0017 EVNT-0022 EVNT-0012 EVNT-0037 EVNT 0037 CVNT-0022 EVNT-0017 EVNT-0022 EVNT-0032 EVNT-2012 EVNT-0032 EVNT-0022 1 1 5 1 1 3 Yes 2 1 1 3 1 1 Yes Yes 1 3 2 1 29 30 71 32 33 34 ClientRegistration Event Details EventAnalysis +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Portfolio Theory and Investment Analysis

Authors: Edwin Elton, Martin Gruber, Stephen Brown, William Goetzmann

9th edition

ISBN: 9781118805800, 1118469941, 1118805801, 978-1118469941

More Books

Students also viewed these Finance questions

Question

8. Describe the step-by-step procedure used to handle exceptions.

Answered: 1 week ago

Question

Explain the chemical properties of acids with examples.

Answered: 1 week ago

Question

Write the properties of Group theory.

Answered: 1 week ago