Skip to content
Gallery
Excel: Beginner to Advanced
Excel: Beginner to Advanced
Share
Explore
Milestone -3

Chapter -8 : Practice Questions & Materials

Raw data has order level information one of the largest Supermart in USA. Us the data to create the following tables:

Count city wise orders.
Calculate customer type wise customer payable.
Identify product category wise highest price.
Customer type wise average quantity ordered.
Salesman – City wise total customer payable.
Product Container – Delivery speed wise total orders.
Ship mode – city wise average delivery charges.
Customer Type – Delivery speed wise total customer payable.
Total saving in different product category.

Dataset -

⁠
workbook .xlsx
396.3 kB
⁠
⁠

Solution sheet-

⁠
3.1 Workbook - Conditional Functions Solution.xlsx
865.3 kB
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.