Hitchhikers

Daily Quiz Streak: 0

Quiz Accuracy Streak: 0

Question 1 of 5

Can you take action on multiple cells at a time in a data set?

Yes, you can select multiple cells in a variety of ways to take action on them.

No, you can only affect single cells at a time.

Question 2 of 5

What is a common use case for using the Length function?

Confirming validity of Address 1 values

Confirming validity of Address 2 values

Confirming validity of City values

Confirming validity of US Postal Code values

Question 3 of 5

What function removes leading and trailing white space from the contents of selected cells?

Proper

Substitute

Trim

Match

Question 4 of 5

What are the options for selecting a delimiter in Text to Columns? (Select all that apply)

Tab

Semicolon

Comma

Space

Other (any letter or symbol)

Question 5 of 5

What would be the most efficient way to paste the data in Example A in the format you see in Example B?

Copy and paste “2” and “3” individually to place them below “1”

Use “Transpose” (option in Paste Special)

Use the Proper function

Use Find and Replace

Way to go, you passed! 🏁