Question

SELECT THE RANGE G4:G20 and look at the status bas statistics to see that PG-13 comedies earned $954 for the month with 7 films. then set a number filter to display records where revenue is greater than or equal to 125

Answer 1

Answer:

The Filter option given in the top right corner at screen enables you to filter the data as per the requirements, there are options to filter data greater than, equal to, not equal to and less than of certain numeric values data.

Explanation:

The Ms Excel has option to sort and filter data according to the needs of its users. Once you click the filter option you will see a drop down enabled at the top row for the set of data. When you click the drop down menu there is an option for filter by numbers, this is where you can select your preference to filter the data. Once desired filter is selected, data will be filtered in the same manner.

For the given range of G4:G20 select option filter for the revenue and then select option greater than equal to option and select the value 125 in the numeric filter. The data will be filtered in the criteria described. It will display all the values in the data which are greater than 125.