II BCOM CA

1.  Explain the features of MS Excel.

2.  Explain the parts of MS Excel.

3.  Explain different types of Charts in MS Excel.

4.  Explain Macros in MS Excel.

5.  Explain function and different types of function.

6.  What are the features of MS Access.

7.  What is Query? Explain different types of queries.

8.  How to create and print reports in database?

9.  What are the data types in MS Access.

10.              Explain Scenarios.

11.              Explain Multi Level Sorting in Access.

12.              Write about Cross tab queries.

13.              Explain cell references, absolute cell.

14.              Creation of table using design view in MS Access.

15.              Explain What if Analysis.

16.              What is Relationship? Explain types of Relationships.

17.              Explain Auto fill and custom fill in MS Excel.

18.              Write about formatting option in MS Excel.

19.              What are the advantages of function.

20.              What are the features of MS Access.

21.              Explain form Wizard in MS Access.