Google Sheets Jeopardy

Tips & Tricks

100

I want to capitalize full names I have in a sheet

What is =UPPER(Cell) ?

200

Extension that allows you to pull data from reports

What is G-Connector

300

I can use this to multiply two numbers together 

What is =PRODUCT(,)

400

I can use this function to see today's date as a data point (don't overthink this one) 

What is =TODAY()

500

Function that allows you to test whether a condition is true

What is IF?

Functions

100

Function that allows you to vertically lookup for a specified value

What is VLOOKUP?

200

A function that allows you to join two pieces of text

What is CONCATENATE

300

You want to look at specific row in a range you have specified

What is INDEX?

400

I can use this function to transform any date or time into a number

What is =VALUE()?

500

I want to extract "ing" off of "running". I would use this formula to extract it. 

=regexextract(cell, "ing")

Formatting

100

How to change a fully capitalized name back into lower case

What is =lower() ?

200

Ordering data in a cell by A-Z order

What is ASCENDING?

300

This function takes off unnecessary white space in a cell

What is TRIM

400

Function that allows you to keep headers as you scroll down a sheet.

What is FREEZE?

500

You can find the ability to remove duplicates in your data with this function

What is DATA CLEANUP

Keyboard Shortcuts

100

This shortcut allows you to select an entire column 

What is control + space?

200

Use this shortcut to see all your formulas 

What is Ctrl + ~ ?

300

Use this shortcut to format number into percentages

Control + shift + 5

400

Use this shortcut to be able to insert today's date into your sheet

What is command + ;

500

Use this shortcut that takes you to the format menu 

control + shift + o

Use Cases

100

I want to use this function to separate a group of first and last names into two columns. 

What is SPLIT()

200

I have email copy in a cell that is in a foreign language, I can use this function to translate the copy into English

What is =googletranslate(cell)

300

I want to copy a set of data from another sheet into the one I am working

What is IMPORT RANGE?

400

I could use this formula to find the number of cells in a range of cells 

What is an array formula?

500

I could use this visualization tool to display which reps are performing the best over the past month

What is a pivot table?