Question: Assn #4 - Second Excel Assignn Task 3 - Determine Regional Manager Add a new column to the right of the Cabin Rentals Sheet; it

Assn #4 - Second Excel Assignn Task 3 - Determine Regional Manager Add a new column to the right of the Cabin Rentals Sheet; it should be c column heading in P1 is: Regional Manager Each of the 9000+ data rows in column P should list the correct regional name. Use the Excel logical functions covered in week 6. Here are the r function must use: o If the state is Florida, the manager is Clint. o If the state is Georgia or Alabama, the manager is Peggy. For oth + manat c Robin

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!

Task 3 - Determine Regional Manager Add a new column to the right of the Cabin Rentals Sheet; it should be column P. The column heading in P1is: Regional Manager Each of the 9000+ data rows in column...

BATCH 1 2 3 4 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 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Business Intelligence Case P r o ject Background Mell Industries is a national manufacturing firm that specializes in textiles based out of Chicago. Starting out as a small factory in Warrenville,...

Prepare your analysis for Management. Create a Table of Contents. Create a new worksheet and move it to the beginning. This worksheet should list the contents of the workbook along with the purpose...

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

I need help with a project management case study CASE STUDY: VIDEO GAME DELIVERY PROJECT Part 1: Project Integration Management An international marketing and distribution company has decided to...

Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales...

Gift Shop Sales Project Description: The sales team at the Painted Treasures Gift Shop would like to review its staffs sales after some of the new staff members have finished a sales training...

Ammonium perchlorate (NH,CIO) is a powerful solid rocket fuel, used in the Space Shuttle boosters. It decomposes into nitrogen (N) gas, chlorine (CI) gas, oxygen (O) gas and water vapor, releasing a...

Woz Enterprises specializes in electrical components. The market for one particular component is perfectly competitive and in long-run equilibrium. Marginal cost is constant at 30. Woz can develop a...

Which of the following financial statements would be most useful if an analyst wants to know the likelihood of repayment of business debts? Question content area bottom Part 1 A. statement of cash...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...