Q1: Paste Special
What is this Paste Special option known as?
Hint: no hint
To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.
Q2: Keyboard Shortcut
What does this keyboard shortcut do:
Windows: Ctrl + T | Mac: Cmd + T
Hint: Two Words
Q3: Declare Variable
What is the most common keyword used to declare a variable?
Q4: VBA Code
In order to loop through each sheet in the workbook, what is the line of code that is missing?
Hint: For loop syntax
Q5: Keyboard Shortcut
What does this keyboard shortcut do: Windows: Alt + F8 | Mac: Opt + Fn + F8
Q6: Chart Type
What type of chart is this?
Hint: One word.
Q7: What Function
The _____ function returns the value at a given location in a range or array
Q8: Large Data Sets
_____ is a tool in Microsoft Excel that simplifies the process of importing data from different source files.
Hint: Two words.
Q9: Cell Format
Which one of these cells (Left, Middle, Right) is formatted for "Accounting?"
Q10: Data Tab
What is the missing ribbon path: Data > _____ > Goal Seek