1. after inputting a formula or a piece of data into a cell, what happens to the cell pointer when you press enter?
a. it moves to the last cell in the column.
b. it moves down one cell.
c. it moves to the next adjacent cell to the right.
d. it moves up one cell.

you may need to email for some tech support. : )

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok