A clear advantage of Materialized Views is that: a. they provide views of data without having to access existing tables at the time they are run b. they simplify query commands c. all these choices d. they save snapshots of data for later use

answer; /// i believe the correct answer is (color filter);

a) click on any cells in the range of data

b) click the data

c) click sort& filter group, click sort

d) select the column to sort by and then select a sort order

e) select the next column to sort by and select the sort order

f) click ok