Quiz 1

Due: Fri, 2 PM See Rules
×

Quiz Rules

  • First place = 1 'Bragging-Right-Card' & 10 'Bragging-Right-Cards' = Gift Card Prize!
  • Think for yourself. Looking up anything = cheating.
  • Spelling errors should not affect score, but try your best.
  • Answers should only contain letters, numbers, and spaces. No special characters.
  • Answers should not be more than 100 characters.
  • Email: [email protected] with any feedback.

Triviafy

Q1: Paste Special (Easy)

Categories: Excel Candidates

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 (Medium)

Categories: Excel Candidates

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 (Hard)

Categories: Excel Candidates

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 (Hard)

Categories: Excel Candidates

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 (Medium)

Categories: Excel Candidates

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 (Medium)

Categories: Excel Candidates

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 (Medium)

Categories: Excel Candidates

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 (Medium)

Categories: Excel Candidates

_____ 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 (Medium)

Categories: Excel Candidates

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 (Easy)

Categories: Excel Candidates

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