Excel Jeopardy

Excel Basics

100

A feature that automatically fills in cells with patterned values.

Autofill 

200

What character type signifies a row

Numbers

300

What character type signifies a column

Letters

400

Provides easy access to frequently used commands.

What is a Quick Access Toolbar?

500

An active cell reference on the left side of the formula bar.

What is a name box?

Math Functions

100

A function that adds all numbers in a range of cells

SUM

200

A function that returns the average of all numbers in a range of cells

AVERAGE

300

function in Excel returns the highest value in a range of cells or values

MAX

400

function in Excel returns the lowest value in a range of cells or values

MIN

500

A statistical function that counts the number of cells that contain a number.

COUNT

Text Functions

100

This function Converts text to uppercase. 

UPPER

200

This function Converts text to lowercase. 

LOWER

300

This function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter.

CONCAT

400

This function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.

TEXTJOIN

500

This function in Excel counts the number of cells in a range that contain any type of data, including numbers, letters, spaces, and empty text.

COUNTA