Microsoft Excel

Describe what all these functions do in excel and how to perform them in excel, along with their short keys if any

a) Wrapped titles that stay wrapped when column width increased b) Named tabs w/ color added c) Chart w/gradient, color font, background d) Date function so date changes when worksheet is opened e) Named range f) Vlookup w/iferror g) IF function h) Color borders i) Color fonts j) Merge & centered data k) Conditional formatting l) Note or comment feature m) Shape feature n) Worksheet protection o) Data validation p) Calculation formulas q) Sorted data r) 2 pivot tables, 1 with a chart s) 2 filtered worksheets t) Data formatted, aligned -consistent, attractive