Excel Basics

Functions

2

This excel function outputs the highest value within the range.

MAX

100

This function adds up all values within the range.

SUM

300

This function displays the smallest value within the selected range.

MIN

500

This useful function calculates the average between all the numbers in the range.

AVG

10000

This EVIL excel function displays values within the range that meet certain criteria specified by the user.

FILTER

Formatting

2

How do you open Excel?

Click on it

100

How do you move down a cell (when not clicking)?

tab

300

What do you insert into your text to absolute reference a cell?

$

500

How do you copy a formula-filled cell and paste only the value?

Paste Special/Value only

10000

This EVIL formatting trick hides cell values from view?

;;;

Shortcuts

2

This shortcut selects the text in a cell to be copied to another cell.

ctrl c

100

This shortcut undoes the most recent action.

ctrl z

300

This shortcut applies bold formatting to the content of the cell. 

ctrl b

500

This shortcut goes to the home tab.

alt h

10000

This EVIL shortcut freezes or unfreezes the current selected panes.

alt w f f

Tech Traditions

2

When was Michigan Tech founded?

1885

100

Where do you eat breakfast during the winter carnival all nighter?

Suomi's

300

How early do you get in line for the hockey game against NMU?

8am or earlier

500

Where do you go cliff diving within an hour drive?

Canyon Falls

10000

Where is the stairway to nothing?

in the MUB

Extra Bonus Points

2

What's your LEAP Leader's name?

ME

100

Which LEAP leader is colorblind?

Gavin

300

How many Head Leap Leaders do you have?

2

500

Which LEAP leaders have a birthday during winter carni?

Shelby and Andy

10000

Which leap leader(s) are in a band?

ALL of them