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

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

3. The intersection of a column and a row in a worksheet is called ____.

4.  What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?

5. The currently selected cell address is displayed in ____.

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

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

8. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

9. What is the correct value of the function? =ROUND (1.2345,2)

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

11.  What function displays row data in a column or column data in a row?

12. The total number of columns in a worksheet?

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

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

15. What dialog box allows you to change a field name in a PivotTable?