Excel Challenge #2

 

Over the next two email challenges, we will transform the dataset shown in Fig 1 into final data table format shown in Fig 2, and create the focus pivot table and pie chart (visible by scrolling down in the Play Store Apps – DATASET worksheet).

Figure 1

 

Figure 2

Tasks

  1. Create a new column at the right-end of the table which provides the price of the App (if paid for) in GBP.
  2. Give the column a relevant name.
  3. Use the exchange rate of £1 = $1.37 to convert to GBP.
  4. Wherever there is no price paid, show the entry in this column as a blank.
  5. Set any total in the column to 2 decimal places.

Stuck on the tasks?

+ Reveal Step-By-Step Instructions


Sharpen your skills with our range of Excel courses designed to turn you from a table trainee to spreadsheet specialist here >