Conditional Counts and Sums Assessment

This is the file needed to answer this assessment question: Conditional Counts and Sums Question 1

In the file above, you are given the population of every country. Use functions to determine the fraction of countries whose population begins with the digit 1,2,3,4,5,6,7,8 or 9.

This is the file needed to answer this assessment question: Conditional Counts and Sums Question 2

Use Excel Formulas (not a PivotTable) to compute in H5:I36 the total pass completions and attempts for each NFL team.

This is the file needed to answer this assessment question: Conditional Counts and Sums Question 3

In columns B:D you are given for over 6,000 transactions the state, product, and units sold. Without using a PivotTable, determine the total units sold of each product in each state.

This is the file needed to answer this assessment question: Conditional Counts and Sums Question 4

In the file above you are given the price of each product sold and a list of transactions. Compute the total revenue earned each year from each product.