Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were...

Mr Michael Mwamburi realized that after sorting the names of Form III class list based on the First Name column in ascending order, there were some ties on similar names that appeared in a disorganized manner.
Advise him on how to break the tie.

Answers

Maurice
(a) He should break the tie by further sorting the names on probably Last name column, that is, if there is a tie on 1st column, he can now sort again on the 2nd column ascending.

(b) To do this:

(i) First highlight the entire worksheet area containing data to be sorted.

(ii) Go to Data Menu from the Menu bar.

(iii) Select the sort submenu.

(iv) Select first Sort by Column A or First name.

(v) Select Then By Column B or Last name.

(vi) Click Ok button.
maurice.mutuku answered the question on April 10, 2018 at 08:46

Answer Attachments

Next: Why would you prefer to use forms for data entry in a worksheet than entering data directly onto the cells?

Previous: What are the types of charts in a spreadsheet?

View more Computer Studies Questions and Answers  |  Return to Questions Index

Exams With Marking Schemes

Related Questions