Issue in executing few functions in excel

Dear sir, I have been facing issue regarding hands-on practice in excel. Some of the formulas are not executing perfectly. The functions which are taught in class like filter and some more where full range of array table results shown after entering the function. Mine in excel is not showing peroperly. Its showing only either coumns or rows. Here are some screenshot ofclasses how result are showing versus mine. Kindly help me in this.