SpreadSheet

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 correct example using the AUTOSUM function?

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

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

• =Sum(A1-A10)
• =Sum(A1:A10)
• =A1+A2+A3+...+A10
• =Sum(A1+A2+A3+...+A10)

In the picture, why is D2 through D5 placed in paranthesis?

• So Excel knows to total the cells before performing the next operation.
• So the total of the cells can be multiplied rather than added.

If the parenthesis is removed, what will 9.5% be multiplied by? 

• D2 +D3+D4+D5
• D5
• D2
• None

The discount formula can be explained by saying the _______ minus 10% of the ___________.

• total
• Sum

Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.

• True
• False

What would be a correct formula for SUM in excel?

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