Extra programming list in Excel 1-3

•0•0Comment iconComment iconComment iconComment icon

More exercises to improve your knowledge in Excel or Google Sheets

Writer image

翻訳者Editorial

Writer image

改訂者Editorial

Edit Article

Class 1 Exercises

Access here the spreadsheet that will be used for the next exerciseslink outside website

1. What is the average number of dengue cases for cities with more than zero cases?

2. How many cities are above the latitude coordinate of -30 degrees?

3. What is the total population of the cities below latitude -24 degrees?

4. How many cities have longitude above -20 degrees?

5. How many cases occur on average for cities below -20 degrees longitude?

Class 2 Exercises

Access here the spreadsheet that will be used for the next exerciseslink outside website

1. How many trees are of native origin?

2. What is the alternative name of the Gochnatia polimorpha tree?

3. What is the scientific name of the Pau-brasil tree?

4. Which family has the most trees?

5. How many trees have more than 70 cm of CBH and good phytosanitary condition?

6. How many trees have "tree tree distance" between 1 and 3 meters?

7. What is the average "tree tree distance" for trees of native origin?

8. What is the sum of the heights of trees of native origin, from the Fabaceae family, with good phytosanitary condition?

9. Use the SEARCH or SPLIT formula and check in which observations the word "copa" appears

10. Use the SEARCH or SPLIT formula and check in which observations the word "Uma" appears

Now using Pivot Table:

11. Separate the authors into a tab by number of trees

12. Separate the trees into a tab by origin with the total sum of heights. Filter to show only trees from the "Fabaceae" family

Class 3 Exercises

Access here the spreadsheet that will be used for the next exerciseslink outside website

1. Which page has the highest bounce rate?

2. Which page has the lowest % exit?

3. Which page has the third highest number of unique views?

4. Which page has the longest time on page?

5. Which article page has the shortest time on page?

Create a column that divides the time in seconds on a page by the bounce rate and another that divides it by the exit rate

6. Which page has the highest value in this new column linked to bounce rate?

7. Which page has the lowest value in this new column linked to exit rate?

Now using Pivot Table:

8. Which page has the highest number of pageviews?

9. Which medium produces the highest number of pageviews?

10. Which pages have the highest bounce rate?

11. Which article pages have the highest bounce rate?

12. Which article pages have the shortest time on page?

ニュースを送信する

トピック

excel programação informática
Telegram logo

こんにちは、Whatsapp にコミュニティがあります。について話してみましょう 高度なコンピューティング ここに!