What is wrong with this formula?
=Sum(A2+B2
Missing the other parenthesis
=Sum(A2+B2)
what is the formula for finding the minimum number in a range of cells?
=Min(range)
When multiplying one cell to another, you use what symbol?
*
How would I calculate the average of cells W12 through W30?
=Average(W12:W30)
How would I calculate the total of A2, B2 and C2?
=Sum(A2:C2)
=Sum(A2+B2+C2)
=A2+B2+C2
What is the formula for finding the largest number in a range of cells?
=Max(range)
When dividing two different cells, you use what symbol?
/
What is wrong with this formula?
=Avg(A2:A6)
=Average(A2:A6)
The Auto Sum button is the same as entering a sum formula into a selected cell?
True
Write me a formula to find the largest number in cells, A2, F55, R12 and W44.
=Max(A2,F55,R12,W44)
How would you write the formula to subtract cell D55 from cell D56?
=D55-D56
Every equation needs to start with ______
Write me a formula to add A2 and C2 and then multiply that answer by 3?
=(A2+C2)*3
Write me a formula to find the smallest number in the range of cells between D2 and D122.
=Min(D2:D122)
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
What is the order of operations?
PEMDAS
How would I write adding cells D14 all the way through D39, in the shortest way possible?
=sum(D14:D39)
=Max(A2:A15) / (B2:B4)
=sum(A2:A77) / (B2:B77)
Name the steps needed to add a 2D chart to your excel document:
Highlight Data
Insert - 2D Chart