Question

1. Shalini generated a spreadsheet containing a list of books, their authors and year of
publication. Which of the columns can be used to sort d
ata in the spreadsheet


​

Answer 1

Explanation:

Its upto you

How to sort data by name of book, by name kf author or by year of publications

Select a cell in the column you want to sort by. ...

Click the Data tab, then select the Sort command.

The Sort dialog box will appear. ...

Click Add Level to add another column to sort by.

Select the next column you want to sort by, then click OK. ...

The worksheet will be sorted according to the selected order.

All the best