Excel (Section 6.3)

Where are numbers aligned to?

• Left

• Right

• Centre

• Justified

I want to add decimal places: 5.4 -> 5.40000

• 
• 
• 

I want to remove decimal places: 3.1415 -> 3.1

• 
• 
• 

What is this cell called?

• C15

• 15C

• C

• 15

I want to input a formula, what character should I input first?

• :

• ~

• no need

• =

I want to sum these 3 numbers.

• 2+4+6

• =B2+B3+B4

• B2+B3+B4

• =ADD(B2,B3,B4)

I want to add up A2 and B2 from Sheet2

• =Sheet2:A2+Sheet2:B2

• =Sheet2~A2+Sheet2~B2

• =Sheet2^A2+Sheet2^B2

• =Sheet2!A2+Sheet2!B2

I want to add these 10 numbers together

• =ADD(A1:J1)

• =SUM(A1:J1)

• =ADD(A1:A10)

• =SUM(A1:A10)

I want the average score of student B

• =AVERAGE(B3:B6)

• =MEAN(B3:B6)

• =AVERAGE(C3:C6)

• =MEAN(C3:C6)

I have found average score of student B. I want to find average score of student A.

• Type the formula again

• Drag the formula from C7 to B7

• Drag the formula from B7 to C7