create query block

[Emily1250]

Hi am having difficulty in creating a query block for an exercise i'm trying to complete for the module develop and use complex spreadsheets(excel 2013). I've completed previous exercises for this workbook Cycle Stuff Sales- January 

[#2]

is anyone able to help??

[#3]

@Emily1250 In the attached workbook I created the "query block" for you, based on the textbook picture you uploaded. By looking at the picture, I suspect that the underlying schedule contains merged cells. Since you are learning Excel, it may be wise to learn NOT use merged cells as they often create problems. Better to look into the various other Alignment options Excel offers and choose "center across selection".