901In Excel, what does ’Scenario Manager’ (part of What-If Analysis) allow you to do?
902What is a ’macro’ in Excel used for?
903What does ’Solver’ (an Excel add-in) help with?
904What is the purpose of ’Data Bars’, ’Color Scales’, and ’Icon Sets’ in Excel?
905What does ’Consolidate’ in Excel help you do?
906What is the purpose of the ’INDEX’ and ’MATCH’ functions when used together in Excel?
907What does ’Power Query’ in modern Excel versions help with?
908What is a ’PivotChart’ in Excel?
909What does ’Sparklines’ in Excel refer to?
910What is the purpose of ’Data Validation – List’ in Excel?
No Comments