ICF 8 (FUNCTIONS)

Multiple Choice

6. 1. What does the function =SUM(A1:A10) do in Excel?

• A. Adds the values in cells A1 to A10
• B. Multiplies the values in cells A1 to A10

• C. Divides the values in cells A1 to A10

• D. Subtracts the values in cells A1 to A10

Multiple Choice

7. 2. Which of the following functions is using the correct syntax?

• A. SUM(A2:A8,E2:E8)=

• B. SUM=(A2:A8,E2:E8)

• C.=A2:A8(SUM)E2:E8

•   D. =SUM(A2/A8,E2:E8)

Multiple Choice

3. Which symbol precedes a formula in Excel?

• A. !

• B. @

• C. = 

•   D. #

Multiple Choice

9. 4. Which formula is used to calculate the total count of cells in a range that contain numbers? 

• A. Count

• B. CountIf

• C. Sum

• D. Average

Multiple Choice

9. 5. It is a powerful application program that is designed to tabulate data and generate report.

• 9.   A. Microsoft Word

• 9. B. Microsoft Excel

• 9. C. Microsoft PowerPoint

• 9. D. Microsoft Publisher

Multiple Choice

9. 6. What is the default extension of an Excel file? 

• 9. A. .csv    

• 9. B. .xls    

• 9. C. .xlsx

• 9. D. .txt

Multiple Choice

9. 7. Which Excel feature allows you to protect cells from being edited?

• 9. A. Cell Lock   

• 9.   B. Protect Sheet

• 9. C. Cell Guard   

• 9. D. Lock Cells