Question: Please provide the correct formula . Please in A10, use Sort function to sort by first name ascending ? the answer should look like the

Please provide the correct formula . Please in A10, use Sort function to sort by first name ascending ? the answer should look like the table to the right of the rectangle with the directions . Thank you

Please provide the correct formula . Please in
OC K M W H John Doe First Last Grade Full Name Income CORRECT Create(calculate) Full Name in 04 50000 John Doe John Doe 50000 CORRECT Use TestJoin to create Full Name with space in between e.g. John Doe. Skip the second value where it asks for 60000 + Use Autofill to complete rest of rows Row DS thru D8 70000 Jane Doe Jane Doe 60000 In E4 thru Ed insert Income . Use the Sequence function to input income for five people with starting value of 50 6 Bill Smith Bill Smith 70000 80000 Bree Smith 80000 90000 7 Bree Smith Cary Williams Cary Williams 90000 8 Smith Bill Smith 7000 ENTER CORRECT FORMULA In A 10, use Sort function to sort by First name Ascending -- Sort functions need data i.e. A4:E8, Sort column i.e 1 and sort order i.e. Ascending you will type for 1 for Ascending i.e. =sort(X,X,X]. You do not need the last value in the function for COL. Your Answer Should Bree Smith Bree Smi 800( 10 Bill Cary Williams Cary Willi. 9000 F Bree should look like picture shown below Jane Doe Jane DOE 6001 12 Cary John Doe John DOE 13 Jane 14 John

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