3rd PT - Computer

Which of the following is the argument that pertains to the sum of my allowance for Week 1?

• A1:A7
• =SUM(B5:B7)
• B1:B7
• B4:B7

Which of the following formulas will compute for my monthly allowance for Meals alone?

• =SUM(B4:E4)
• =SUM(B4:E7)
• =SUM(B4:B7)
• all of the above

Which of the following formulas will compute for the sum of my Week 4 allowance?

• =(E4+E5+E6+E7)
• =SUM(E4:E7)
• =SUM(E4,E5,E6,E7)
• all of the above

Which of the following formulas will compute the sum of my Week 1 and Week 2 allowance?

• =SUM(B4:B7,C4:C7)
• =SUM(B4:C7)
• =SUM(B4:B7)+SUM(C4:C7)
• all of the above

Which of the following formulas will compute for my monthly allowance for Requirements alone?

• =SUM(B7:E7)
• =SUM(B4:E7)
• =SUM(E4:E7)
• All of the above

In =SUM(A5:A12), what is the function name?

• =
• SUM
• A5:A12

In =SUM(A5:A12), what is the argument?

• =
• SUM
• A5:A12

Formatting tools in MS Excel are located on the _________ group box on the Home Tab.

• Font and Alignment
• Clipboard
• Number
• Style
• Cell

If you want to make the size of the text bigger or smaller.

• change the font size
• change the font
• change font color
• change the fill color

If you want to change the text from Times New Roman to Comic Sans.

• change the font size
• change the font
• change font color
• change the fill color