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
Get step-by-step solutions from verified subject matter experts
