Ex_class_2

Use AVERAGE to find the average number of Republican congressional seats for the top 3 states

What would =AVERAGE(D2) return?

What would =AVERAGE(1, 1, 1, 1, 1, 1, 1) return?

The MAX function returns the highest number from a list, and ignores text values. Write a MAX() to return the highest number (10).

The MIN function obviously returns the minimum value. Write a MIN function on the correct cell range to get the smallest value (-1).

Use the MAX function to return the highest value from the list.

All formulas in Excel start with = .

Type the formula to Find the total January revenue

A better way to add numbers is to use the SUM function.

Find total January revenue by using =SUM() Notice: the function's arguments are separated by commas

You can pass a group of cells to a function by using a colon.

B2:B4 tells Excel "every cell from B2 to B4".

Find January Revenue by using =SUM() and the correct cell range

use the SUM function to find total revenue for February