Tolong bantu jangan ngasal!kalo gak tau gak usah jawabb!!​

1. Relative Reference produces a formula whose cell address changes according to the new cell location while Absolute Reference will produce a formula whose cell address does not change wherever the formula is copied, the combination of the two will produce a Mixed Reference.

2. Advanced Filter allows you to use complex criteria.

3. If the numbers are written from the smallest number to the largest number, then the numbers are ascending order. If the number is written from the largest number to the smallest number, then the number is descending order.

4. ???

5. Chart Area includes charts and the entire element related to the chart. Plot Area does not cover entire element of chart. It only includes the graphical representation of the charts.