Question

if you categorise the data using the following lookup chart in which category will 41 appear
​

Answer 1

Answer:

The value you want to look up, also called the lookup value. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C.

Answer 2

Answer:

Select the cell range you want to sort. ...

Select the Data tab on the Ribbon, then click the Sort command.

The Sort dialog box will appear. ...

Decide the sorting order (either ascending or descending). ...

Once you're satisfied with your selection, click OK.

The cell range will be sorted by the selected column.