EXCEL

1

100

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. 

IF

200

Returns the current date and time formatted as a date and time.

NOW

300

Concatenates a list or range of text strings. 

CONCAT

400

Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase. 

PROPER

2

100

Goal seek pathway...

Data>Forecast>What If Analysis

200

Freeze panes pathway

View>Window>Freeze Panes

300

WordArt pathway

Insert>Text>WordArt

400

Solver Pathway

File>Options>Add ins>Solver

3

100

Quickly add a snapshot of any window that's open on your desktop to your document. 

Screen Clipping 

200

Prevent unwanted changes from others by limiting their ability to edit.

Protect Worksheet

300

Choose rows and columns you'd like to repeat on each printed page, such as those with labels or headers.

Print Titles

400

Shows arrows that indicate which cells affect the value of the currently selected cell. 

Trace Precedents

4

100

COUNT

Counts the number of cells in range that contains numbers.

200

RIGHT

Returns the specified number of characters from the end of a text string. 

300

INDEX

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.  

400

FORECAST

Calculates, or predicts, a future value along a linear trend by using existing values.

5

100

What do you use to filter data?

Slicer

200

How do you trace an error?

Formulas>Formula Auditing>Error Checking

300

True or False- You can create a Defined Name

True

400

True or False- Once solver is added, it appears in the Formulas tab.

False