Question

You are a student who is new to the more advanced features of Excel. You have a lot of familiarity with ranges from an earlier Excel class, but you know that there is an alternative that will give you access to additional features that you do not have with a cell range. What is that option?

Convert the range to a PivotChart.

You are wrong; the range has as many features as any Excel alternative.

Convert the range to a table.

Convert the range to an index.

Answer 1

Convert the range to a table using Excel

These are the steps to follow.

1. Create the table in Excel and Select the whole table in Excel.

2.Click Home -> Format Table dropdown and pick what style you want.Then,the table ranges are automaticaly comes in "Format as table", check the my table as header and click OK.

3.You can see the dropdwn at the top in header. Use it and filter the table. you can see the example of cell range to table

Convert the range to an Index using Excel

Index: In Index Function it can return the value at a given position in a range or array.

1. Create the table in Excel.

2. Index Formula (fx) you can choose the row and column in array syntax.

Syntax: Index (array, row num,[col num],[array num])

3.You can choose the value that you want to return.

For e.g Fx= Index (A6:E11,3,4) // Return 96 (Subject2)

4. This is the way you can find the index value from the cell range. Below example of range to Index

These are the steps to convert Table and Index from cell Range.