+
Highs and Lows
- / *
Random
100

What is wrong with this formula? 

=Sum(A2+B2

Missing the other parenthesis

 =Sum(A2+B2)

100

what is the formula for finding the minimum number in a range of cells? 

=Min(range)

100

When multiplying one cell to another, you use what symbol? 

*

100

How would I calculate the average of cells W12 through W30?

=Average(W12:W30)

200

How would I calculate the total of A2, B2 and C2? 

=Sum(A2:C2)

=Sum(A2+B2+C2)

=A2+B2+C2

200

What is the formula for finding the largest number in a range of cells? 

=Max(range)

200

When dividing two different cells, you use what symbol? 

/

200

What is wrong with this formula?
=Avg(A2:A6)

=Average(A2:A6)

300

The Auto Sum button is the same as entering a sum formula into a selected cell? 

True

300

Write me a formula to find the largest number in cells, A2, F55, R12 and W44. 

=Max(A2,F55,R12,W44)

300

How would you write the formula to subtract cell D55 from cell D56?

=D55-D56

300

Every equation needs to start with ______

=
400

Write me a formula to add A2 and C2 and then multiply that answer by 3? 

=(A2+C2)*3

400

Write me a formula to find the smallest number in the range of cells between D2 and D122. 

=Min(D2:D122)

400

Write me a formula to multiply the sum of A2 and A3 by 5

=(A2+A3)*5

=SUM(A2+A3)*5

=SUM(A2,A3)*5

400

What is the order of operations? 

PEMDAS

500

How would I write adding cells D14 all the way through D39, in the shortest way possible? 

=sum(D14:D39)

500
Write me a formula to find the largest number of cells A2 through A15 and then divide that total by the total of cells B2,B3 and B4. 

=Max(A2:A15) / (B2:B4)

500
How would you write a formula to divide the sum of cells A2 through A77 by the sum of cells B2 through B77?

=sum(A2:A77) / (B2:B77)


500

Name the steps needed to add a 2D chart to your excel document: 

Highlight Data
Insert - 2D Chart