Excel TV Episode 3 Challenge Question

[jpo645]

Below is the Excel TV Episode Challenge Question!



This week's prize is a free, 12-month membership to Mynda Treacy's Dashboard Course at MyOnlineTrainingHub.com. Good luck!

[SamT]

Oh, WOoow Man, that's hard. It will really test someone's knowledge of EXCEL.

As much as I like the prize, I'm not purchasing and installing the latest and greatest version of Office to answer it.

[snb]

What if ?

Sub M_snb()
    Application.CommandBars.DisplayKeysInTooltips=false
End Sub

There's no relation between an icon and the macro you can assign to it, let alone a tooltiptext.
But I could see Opslaan, Knippen, Plakken, Filteren,

[jazzman831]

Stupid question... what prevents someone from just taking my answer? Anyway, some were easy (already in my QAT) and some were tricky, but I got 'em all (highlight below):

A = Save
B = Symbol
C = Record Macro
D = Filter
E = Cut
F = Wrap Text
G = Erase Border
H = Merge & Center
I = Solver (Solver Add-In)
J = Data Analysis (Analysis Toolpak Add-In)
K = Remove Duplicates
L = Watch Window

[Danny_Boy]

Here is my answer:

A Save
B Symbol
C Record Macro
D Filter
E Cut
F Wrap Text
G Clear
H Merge
I Solver
J Data Analysis Tools
K Remove Duplicates
L Watch Window