Question

Mr. Ibanez has shared a spreadsheet with his students. The first column is blank. The second column contains names in random order in cells B3:B13. Additional data is located in columns C and D. He asks the students to alphabetize the names in descending order while maintaining the correlating data. The students correctly highlight cell range B3:D13 and then:

Answer 1

Sort by Column B, ZA

Step-by-step explanation:

The spreadsheet is the software which enables the accountants and business managers to handle complex calculation with ease. Mr.Ibanez has asked students to organize the spreadsheet with names according to descending order. The names are listed in column B. The student should select the area and then click sort option. The dialogue box will appear which will ask to sort according to ascending or descending.