In cell I2 , write a formula to determine the position of the ( character in cell B2 Extend the formula to I3 I11 (4 points) In cell J2 , write a formula to determine the position of the ) character in cell B2 Extend the formula to J3 J11 (4 points) In cell K2 , write a formula to determine the position of the character in cell B2 Extend the formula to K3 K11 (4 points) In cell E2 , write a formula to extract the country code from a phone number The country code is the digits after the character and before the ( character You should use the position of the ( character in cell I2 in the formula Extend the formula to E3 E11 (4 points) In cell F2 , write a formula to extract the area code from a phone number The area code is the digits between the () characters You should use the position of the ( character in cell I2 and the position of the ) character in J2 in the formula Extend the formula to F3 F11 (4 points) In cell G2 , write a formula to extract the prefix from a phone number The prefix is the digits after the ) character and before the character You should use the position of the ) character in cell J2 and the position of the character in K2 in the formula Extend the formula to G3 G11 (4 points) In cell H2 , write a formula to extract the local number from a phone number The local number is the last 4 digits in a phone number Extend the formula to H3 H11 (4 points) Paste ge Center Conditional Format Formatting as Table Cell Styles 12 v fx A L M N E Country Code F Area Code G Prefix H Local I Pos J Pos2 K Pos3 1 FullName Phone Number Trimmed Names 2 Oliver Rogers 1(415)555 2671 Oliver Rogers 3 Andres Williams 44(20)7183 8750 Andres Williams 4 Cesar Cannon 1(303)555 1234 Cesar Cannon 5 Tracy Byrd 52(35)5566 1212 Tracy Byrd Olivia Rodriguez 91(40)7766 1313 Olivia Rodriguez RUFUS JORDAN 1(720)556 4321 RUFUS JORDAN 8 Eduardo Gray 86(35)8766 3312 Eduardo Gray 9 sheila underwood 51(970)556 3344 sheila underwood 10 Freda Curry 44(20)9576 3112 Freda Curry 11 Miranda Gomez 52(41)8766 9812 Miranda Gomez 12 Propper Names Oliver Rogers Andres Williams Cesar Cannon Tracy Byrd Olivia Rodriguez Rufus Jordan Eduardo Gray Sheila Underwood Freda Curry Miranda Gomez 13 14 15 16 17 18 19 20 21 22 23 24 25 26

The Answer is in the image, click to view ...

Question: In cell I2 , write a formula to determine the position of the ( character in cell B2. Extend the formula to I3:I11. (4 points)

In cell I2, write a formula to determine the position of the ( character in cell B2. Extend the formula to I3:I11. (4 points)
In cell J2, write a formula to determine the position of the ) character in cell B2. Extend the formula to J3:J11. (4 points)
In cell K2, write a formula to determine the position of the - character in cell B2. Extend the formula to K3:K11. (4 points)
In cell E2, write a formula to extract the country code from a phone number. The country code is the digits after the + character and before the ( character. You should use the position of the ( character in cell I2 in the formula. Extend the formula to E3:E11. (4 points)
In cell F2, write a formula to extract the area code from a phone number. The area code is the digits between the () characters. You should use the position of the ( character in cell I2 and the position of the ) character in J2 in the formula. Extend the formula to F3:F11. (4 points)
In cell G2, write a formula to extract the prefix from a phone number. The prefix is the digits after the ) character and before the character. You should use the position of the ) character in cell J2 and the position of the -character in K2 in the formula. Extend the formula to G3:G11. (4 points)
In cell H2, write a formula to extract the local number from a phone number. The local number is the last 4 digits in a phone number. Extend the formula to H3:H11. (4 points)

Paste ge & Center Conditional Format Formatting as Table Cell Styles 12 . * v fx A L M N E Country Code F Area Code G Prefix H Local I Pos J Pos2 K Pos3 1 FullName Phone Number Trimmed Names 2 Oliver Rogers +1(415)555-2671 Oliver Rogers 3 Andres Williams +44(20)7183-8750 Andres Williams 4 Cesar Cannon +1(303)555-1234 Cesar Cannon 5 Tracy Byrd +52(35)5566-1212 Tracy Byrd Olivia Rodriguez +91(40)7766-1313 Olivia Rodriguez RUFUS JORDAN +1(720)556-4321 RUFUS JORDAN 8 Eduardo Gray +86(35)8766-3312 Eduardo Gray 9 sheila underwood +51(970)556-3344 sheila underwood 10 Freda Curry +44(20)9576-3112 Freda Curry 11 Miranda Gomez +52(41)8766-9812 Miranda Gomez 12 Propper Names Oliver Rogers Andres Williams Cesar Cannon Tracy Byrd Olivia Rodriguez Rufus Jordan Eduardo Gray Sheila Underwood Freda Curry Miranda Gomez 13 14 15 16 17 18 19 20 21 22 23 24 25 26

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

Question 1) answer the following questions by using conditional summary functions (20 points). a) Make a table with cells A1 to I21 with name EmpTable, a heading row, banding rows, no total row, and...

I am looking for some help on finding the answers for these. Thank you! M2 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign2.xls (where XX is your Group Name), and...

1 Open the ClothingTech Pre-Project Analysis - Start workbook. 2 Cutt-Off Test: In steps 3 6 below, you are going to determine if there were any 2016 sales that were not shipped until 2017. While...

Question 4) Write formulas to determine if the salary of an employee is above or below the average salary for the employees state and employee title. ( 15 points ) In cell H2 (Average Salary), write...

Simple Linear Romanian Brey's Accounting & Tax Services is a small accounting fim in Sioux City, I which completes taxes for individuals. Hvery yow, firms like Bret's decide how much they will charge...

PLEASE EMAIL YOUR ANSWER AT @cybersafetygyaan Excel - Employee Payroll Project In this Project, your task is to create an Excel worksheet with formulas where needed to calculate Employee Payroll....

New Perspectives Microsoft Office 365 & Office 2019 Introductory (1st Edition) Chapter EXM.3, Problem 1CCP Can I get a textbook solution for this case problem? Case Problem 2 CHALLENGE Data File...

answer it please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/Ea6JKeTr8SFHt2qszPDUavcBHxD6zFZUCXvCFivFNs4Kuw?e=h6i4EF 5 Write a formula in the yellow cell...

answer this workbook please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=12fYP0 18 19 Horizontal Analysis 0...

Q: What is horizontal line test? Q2: write down application of homogenous differential equations

A shoreline observation post is located on a cliff such that the observer is 420 feet above sea level. When initially spotted, the angle of depression (the angle at which an observer needs to look...

PLEASE HELP WITH ONLY REQUIRED 3 , REQUIRED 4 AND REQUIRED 5 Hillyard Company, an office supplies specialty store, gathered the following information to prepare its master budget for the first...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...