Which function sorts a spreadsheet range between cells G1 and H60 in ascending order by the first column, Column G?

In Google Sheets, you can use the SORT function to sort a range of cells in ascending order by the first column. Here's how you can do it:

1. Click on the cell where you want the sorted data to appear.
2. Type =SORT(G1:H60, 1, TRUE) and press Enter.

Explanation:

• G1:H60 is the range of cells you want to sort.
• 1 is the column index by which you want to sort. Since you want to sort by the first column, Column G, the index is 1.
• TRUE indicates that you want to sort in ascending order. If you wanted to sort in descending order, you would use FALSE.

Remember, the sorted data will appear starting from the cell where you typed the formula. The original data in the range G1:H60 will remain unchanged.