Quiz 1

Due: 4 PM, Wed, 2099-12-31

Q1: Paste Special

Categories: Excel

Difficulty: Easy

What is this Paste Special option known as?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q2: Keyboard Shortcut

Categories: Excel

Difficulty: Medium

What does this keyboard shortcut do: Windows: Ctrl + T | Mac: Cmd + T

Triviafy question image

Hint: Two Words

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q3: Declare Variable

Categories: Excel

Difficulty: Hard

What is the most common keyword used to declare a variable?

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q4: VBA Code

Categories: Excel

Difficulty: Hard

In order to loop through each sheet in the workbook, what is the line of code that is missing?

Triviafy question image

Hint: For loop syntax

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q5: Keyboard Shortcut

Categories: Excel

Difficulty: Medium

What does this keyboard shortcut do: Windows: Alt + F8 | Mac: Opt + Fn + F8

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q6: Chart Type

Categories: Excel

Difficulty: Medium

What type of chart is this?

Triviafy question image

Hint: One word.

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q7: What Function

Categories: Excel

Difficulty: Medium

The _____ function returns the value at a given location in a range or array

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q8: Large Data Sets

Categories: Excel

Difficulty: Medium

_____ is a tool in Microsoft Excel that simplifies the process of importing data from different source files.

Triviafy question image

Hint: Two words.

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q9: Cell Format

Categories: Excel

Difficulty: Medium

Which one of these cells (Left, Middle, Right) is formatted for "Accounting?"

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Q10: Data Tab

Categories: Excel

Difficulty: Easy

What is the missing ribbon path: Data > _____ > Goal Seek

Triviafy question image

Hint: no hint

To Answer Quiz Questions: Create Account > Add To Slack > Select your team's Slack channel.

Share This Quiz PDF With Team
Logo cheering purple