Practice Questions on Calculations

Answer these questions using the Superstore sample data.

1. Find the total profit for the South region for items ordered in 2011.

2. Which product subcategory has the highest ratio of profit to sales?

3. Find the total number of Small Business customers placing orders from the superstore.

4. What is wrong with this If Statement

If [Sales] > 100 and "Delivery Truck" then 0
else [Shipping Cost]
End

5. What will the function Left(3,"Tableau") return?

Be sure to click Submit Quiz to see your results!

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top