Question: What happens to worksheet rows that do not match the filtercriteria? What happens to the data they contain? When multiplefilter buttons are used with a

What happens to worksheet rows that do not match the filtercriteria? What happens to the data they contain? When multiplefilter buttons are used with a data range, how are criteria in dif-ferent fields combined? When would you use an advanced filter inplace of the filter buttons? What happens to banded rows in anExcel table when you insert or delete a row? What is the referenceto the Income field from the Employees table? What is the formulato calculate the average of the Income field from the Employeestable? What is the structural reference to the table headerrow?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!