Google

How would you rate your proficiency in Google Sheets?

• Beginner

• Intermediate

• Advanced

• Expert

How many hours per year could be saved using keyboard shortcuts?

• 85

• 50

• 64

• 72

What does the combination Ctrl + Shift + 5 do in Google Sheets?

• Format as percentage

• Format as date

• Format as time

• Format as currency

What is the keyboard shortcut to copy in Google Sheets?

• Ctrl + C

• Ctrl + O

• Ctrl + H

• Ctrl + X

What does Ctrl + Z do in Google Sheets?

• Save your sheet

• Undo your previous action

• Center align

• Fill range

How do you view the parameters needed in a Google formula?

• Ctrl + /

• F1

• Shift + F11

• F9

If I want to only paste as values, what is the associated keyboard shortcut?

• Ctrl + B

• Ctrl + Shift + V

• Shift + F11

• Ctrl + H

What does Ctrl + Shift + 3 do in Google Sheets?

• Format as Date

• Insert Note

• Hide Row

• Clear formatting

If you would like to quickly navigate to the last rows of a column, what keyboard combination would you use?

• Ctrl + D

• Alt + Down Arrow

• Ctrl + Down

• Alt + Enter

You noticed an error in a Google Sheet. What keyboard combination would you use to insert a comment?

• Ctrl + Alt + M

• Alt + Shift + X

• Ctrl + Shift + 6

• Alt + Shift + 2