Formula & Function year 5

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

Which symbol must all formula begin with?

• =
• +
• (
• @

_____ are vertical. 

• Rows
• Columns

________ are horizontal

• Rows
• Columns

A(n) _________ is a prewritten formula that is built into EXCEL. 

• function
• problem
• equation
• equal sign

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

• Cell address
• Worksheet
• Formula

Excel allows you to

• read stories
• work with data
• invent ideas

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

Which of the following option is a formula?

• A. =SUM(A1:A5)

• B. Add A1 - A5

• C. Subtract the numbers

• D. A1 = A5