ICT 0417 Spreadsheets - Functions and Formulae

What do all formulas begin with?

• %
• [ ]
• =
• :

What symbol do we use for multiplication in a Spreadsheet program? 

• /
• =
• ^
• *

What symbol do we use for addition in a Spreadsheet program? 

• /
• +
• =
• *

Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?

• A4-A3=
• A3-A4=
• =A4-A3
• =A3-A4

Which of the following formulas will add cells A1 thru A5?

• =SUM(A2+A5)
• =A1+A2+A3+A4+A5
• =A1:A5
• =A1-A2-A3-A4-A5

Which of the following is a formula that will multiply cells A1 and A2?

• A1*A2
• =A1:A2
• =A1*A2
• =Multiply(A1:A2)

Which of the following is a formula that will divide cell D10 by 2?

• =D10/A2
• 10/2
• =D10*2
• =D10/2

Which of the following is a formula that will subtract cell B4 from cell B3?

• =3-4
• =B3-B4
• =B3*B4
• B3-B4

Which of the following is a formula that will divide cell A10 by cell A1?

• =A10/A1
• =A1/A10
• =A10*A1
• =Divide(A10:A1)

Which of the following is a correct example using the AUTOSUM function?

• sum(D14:D19)
• =D14:d19
• =sum(D14:D19)
• =D14+D15+D16+D17+D18+D19