What

is the total number of “Environmentally Conscious” customers?

Refer to your Pivot Table to answer this question.

Which category had the HIGHEST Total Sales amount in 2022?

Refer to your Pivot Table to answer this question.

Which MONTH in 2022 had the HIGHEST Total Sales amount in the Office category?

What was the Delivery Time (in days) for the following transaction:

• Customer name: Olivia Taylor
• Sale Date: 29 July 2023

What is the Total Sales Price amount for the following transaction:

• Customer name: Chris Martin
• Sale Date: 31 May 2023

Refer to your Pivot Table to answer this question.

In which TWO months did Bolt Logistics have the LEAST number of deliveries?

Before you answer this question, please check that you have done the following:

• cleaned and formatted the data in “Module 2 Excel Training Data.xls"
• imported the data from the image "Module 2 Excel Training Additional Data" into your spreadsheet
• appended the image data with “Module 2 Excel Training Data.xls"

Refer to your Pivot Table to answer this question.

Which are the TWO busiest months of the year i.e. where there are peaks in delivery?

Before you answer this question, please check that you have done the following:

• cleaned and formatted the data in “Module 2 Excel Training Data.xls"
• imported the data from the image "Module 2 Excel Training Additional Data" into your spreadsheet
• appended the image data with “Module 2 Excel Training Data.xls"

What is the Total Sales Value for all the transactions?

Hint: You will need to integrate the data from Module 1 Excel Training Data 1 and Module 1 Excel Training Data 2.