can someone help me with these excel related questions for my intro computer science course? thank you :)

Question 1 (1 point]When applying a filter to a table within Excel. data that is filtered out is ___? deleted from the table. moved to a separate sheet. hidden from 1ul'ieylr. stored in a temporary file. Question 2 (1 point]1|l"‘.ihat is the purpose of a pivot table? To look pretty To display all of your data at once To create a plot summarizing your data To easily organize and summarize important data To sort your data alphabetically