1.  Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

2. Excel is a program that is used to prepare a

3. Which function is used to return the number of cells in a range that meet a condition set forth in the formula?

4. What is the correct syntax of IF() function?

5.  MS-Excel uses the ______ Function when creating a data table

6. In MS Excel, ‘Merge and Center’ is used to ____.

7. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

8. Which function is used to get days, months, or years between two dates?

9. What function will produce results that indicate whether a student has passed or failed a course by enter the text “Pass” or “Fail”?

10. A worksheet range is a

11.  Which function is used to create a date with year, month, and day?

12. Which function is used to remove extra spaces from the text in MS Excel?

13. Shortcut key CTRL + D is used to ____.

14. Excel is a program that is used to prepare a

15. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array