Spreadsheets 2 - Basics and SUM Formula

Spreadsheets are made up of rows and columns.

• True

• False

What is found at the top of every column?

• Letter

• Number

What is found at the end of every row?

• Letter

• Number

What is the name of the program we use to create and edit spreadsheets?

• Excel

• Word

• PowerPoint

• Access

What formula is the same as: =D4+D5+D6+D7

• =SUM(A1:A3)

• =SUM(B2:B6)

• =SUM(D4:D7)

• =SUM(D4:D10)

What formula is the same as =SUM(A2:A5)

• =D1+D2+D3

• =H3+H4+H5+H6

• =A1+A2+A3+A4+A5

• =A2+A3+A4+A5

Which one of the following is a division formula?

• =C4+C6

• =C4*C6

• =D2-D3

• =D7/D8

Which one of the following is a multiplication formula?

• =B1*C6

• =D3-G5

• =H1/D2

• =E1-E2

What is the cell reference of the highlighted cell?

• B6

• D7

• G1

• A2

• D6

What is the cell reference of the highlighted cell?

• A7

• B1

• C5

• B11

• B12