Excel Module 2

Front

The ____________ function displays the highest value in a range.

Back

MAX

Front

The __________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Back

Accounting number format

Front

The default view in Excel is called ________ view.

Back

Normal

Front

The ________ function determines the lowest number in a range.

Back

MIN

Front

What cell style do you use in the Total line?

Back

Total

Front

What cell style do you use in the Title?

Back

Title

Front

What do you press to place lines of text on multiple lines within the cell, it's button is called Wrap Text?

Back

Alt Enter

Front

Which functions sums the number and then divides by the number of values? Options: SUM, MAX, AVERAGE, MIN

Back

AVERAGE

Front

When you need the width of the column to increase or decrease so the widest entry will fit?

Back

Auto Fit

Front

What is an excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells. Example – email addresses.

Back

Flash Fill