Spreadsheets and data analysis — tasks with solutions

In cell B2 there is a price of PLN 12.50 and in C2 there is a number of pieces 4. What formula will you type in D2 to calculate the purchase value?

In D2, there's a formula =B2*C2. You copy it one row down to D3. What will the formula look like in D3?

In B2, there is a net amount and in F1, a fixed rate of 23%. In C2 you want to calculate the tax and copy the formula down. How do I write the F1 reference so it doesn't move?

Explain the difference between A$1 and $A1. What's blocked in each of them?

In B2:B6 there are five measurements: 8, 10, 7, 9, 11. What is their sum and average and what functions of the sheet can be used?

The student wants to add cells B2, B3 and B4, but writes =B2+B3*B4. Why can the result be different from the expected and how to improve the formula?

The table has columns: Name, Class, Result. You want to set the students from the highest score to the lowest score. Why shouldn't you just sort the result columns without the other columns?

You have 200 sales records and you want to see only lines with the category of Books and values above 100 PLN. Is it better to remove other rows or use a filter?

You have sales in four categories: books 40, games 25, notebooks 20, other 15. You want to easily compare the size of the category. What simple type of chart will be a good choice and why?

Two values are 98 and 100. The bar diagram starts with a vertical axis of 97, making the second bar look several times higher. Why can a graph be misleading?

In the column Ages there are values: 14, 15, no, 150, 14. Did you just count the average? What do you need to check out?

You have a table of class expenses project: Date, Category, Amount, Person. Set up an analysis plan that uses formulas or functions, sorting/filtering and chart.