Below is the Excel TV Episode Challenge Question!
Attachment 11422
This week's prize is a free, 12-month membership to Mynda Treacy's Dashboard Course at MyOnlineTrainingHub.com. Good luck!
Printable View
Below is the Excel TV Episode Challenge Question!
Attachment 11422
This week's prize is a free, 12-month membership to Mynda Treacy's Dashboard Course at MyOnlineTrainingHub.com. Good luck!
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.
What if ?
There's no relation between an icon and the macro you can assign to it, let alone a tooltiptext.Code:Sub M_snb()
Application.CommandBars.DisplayKeysInTooltips=false
End Sub
But I could see Opslaan, Knippen, Plakken, Filteren,
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
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