Excel Questions

1. An array is a systematic arrangement of similar objects, usually in rows and columns.

2. The NOW function calculates the difference in days between two dates.

3. Which function returns the current date?

4.  What is the default file name of Microsoft Excel file?

5. Which function will you use to enter current date and time in a worksheet cell?

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

7. A worksheet range is a

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

9.  IF Statement can be written to carry out an action

10.  The ____ function is used to convert to text in a number format in MS Excel.

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

12. Which function is used to trap and handle errors?

13.  In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu

14. Which bar show the used formula of selected active cell?

15. In ______ tab you will find AutoSum button.