Need help figuring out the right formula for rank that doesn't sort the data by displacement

The RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time) values, using an optional order argument. The MINIFS function returns the smallest numeric value that meets one or more criteria in a range of values. The MAXIFS function returns the largest numeric value that meets one or more criteria in a range of values. Both functions can be used with criteria based on dates, numbers, text, and other conditions. MAXIFS supports logical operators (>,,=) and wildcards (* ? ?) for partial matching. Starting in cell G3, create a formula to display the rank of each car in ascending order of displacement. Do not sort the data by Displacement! Next complete the table below using the MINIFS and MAXIFS functions to identify the minimum and maximum horsepower for cars with different cylinders. Click here to jump back to the Introduction sheet The RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time) values, using an optional order argument. The MINIFS function returns the smallest numeric value that meets one or more criteria in a range of values. The MAXIFS function returns the largest numeric value that meets one or more criteria in a range of values. Both functions can be used with criteria based on dates, numbers, text, and other conditions. MAXIFS supports logical operators (>,,=) and wildcards (* ? ?) for partial matching. Starting in cell G3, create a formula to display the rank of each car in ascending order of displacement. Do not sort the data by Displacement! Next complete the table below using the MINIFS and MAXIFS functions to identify the minimum and maximum horsepower for cars with different cylinders. Click here to jump back to the Introduction sheet