1. Which function would you use to add several numeric values?

a. TOTAL b. AVERAGE c. SUM d. COUNT

2. Which of the following is the correct way to write the IF function?

a. =IF(condition, condition if false, condition if true) b. =IF(condition:condition if true:condition if false) c. =IF(condition, condition if true, condition if false) d. None of the above

3. VLOOKUP in VLOOKUP function stands for Vertical Lookup.

a. True b. False

4. If you see ##### code, what do you need to do?

a. Check your function syntax b. Use a different function c. Re-enter the function formula d. Widen the column

5. Which function in Excel checks whether a condition is true or not ?

a. SUM b. COUNT c. IF d. AVERAGE

6. What type of chart is useful for showing trends or changes over time ?

a. Pie b. Column c. Line d. Dot

7. Getting data from a cell located in a different sheet is called:

a. Referencing b. Accessing c. Functioning d. None of the above

8. Show do you rearrange the data in ascending or descending order?

a. Data>Sort b. Data>Form c. Data>Table d. None of the above

9. What are the tabs that appear at the bottom of the each workbook called?

a. Location Tab b. Sheet Tab c. Reference Tab d. None of the above

10. What is entered by the function =today()

a. Todays date as text format b. Time value according to system clock c. Date value for the day according to system clock d. None of the above