5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum of Percentage" value. Do not select the Grand Total range in the function. 6. Using the MATCH function only, write a formula in cell G7 of Top10_Pivot Sheet to find the Row Number of Maximum Sum of percentage. 7. Using the INDEX function only, write a formula in cell H7 to find the state name having the maximum "Sum of Percentage". The formula should include the value(row number) that is calculated in G7.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
5. Using the Max function, write a formula in cell F7 of Top10_Pivot Sheet to find the maximum "Sum of Percentage" value. Do not select the Grand Total range in the function.
6. Using the MATCH function only, write a formula in cell G7 of Top10_Pivot Sheet to find the Row Number of Maximum Sum of percentage.
7. Using the INDEX function only, write a formula in cell H7 to find the state name having the maximum "Sum of Percentage". The formula should include the value(row number) that is calculated in G7.
Step by step
Solved in 4 steps with 6 images
