Buy Now: A Competitive Mirror for Library and information Science Scholars, By Asheesh Kamal

11. How can you add automatic page numbering in the header of an Ms Word document?

ANSWER: You can insert automatic page numbering into a tab and from header &footer. Click on the insert tab and from the header and footer section click on the header icon.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

12. What is a sorting? How can you sort a cell range in Ms excel?

ANSWER: Sorting arrange the data within a table into Alphabetical or numerical order. Ex: book, address are sorted alphabetically from A-Z and calendar are sorted by data order.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

13. What is a function in Ms Excel? What function is used for counting the number?

ANSWER: A function allows you to calculate a result such as adding numbers together or finding the average of a range of numbers.

Count function: The count function will count up the number of cells which contain number. Ex =COUNT(A1:A5)

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

14.How can you select a range of cells not next to each other ?

An : Sometimes we need to select multiple cells that are not next to each other. To do this click on the first cell, i.e.C3 then while keeping the ctrl key pressed click on the cell G3.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

15.How can you rename a worksheet ?

ANSWER : You can rename a worksheet at bottom left corner of excel window and write down new name than press enter.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

16.What is the advantage of using index in your database.

ANSWER: Access uses indexes much like the table of contents of the beginning of this course ,to help locate and sort information quickly. An index stores the location of records based on the field or fields we chose to index.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

17. How can you create a ms access form?

ANSWER: We can create a form in Ms access by clicking “Forms” Group Within create tab.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

ANSWER: The slide show view fill the whole screen and we can advance to the next slide by clicking the mouse button. It is the view that is used for presentation.

20. What is the slide show View in Ms power point?

ANSWER: Design View displays the working behind the object such as field name , data type and properties.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

19. What is the use of design view in Ms access?

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam

18. Describe the “One –to- many relationships” in Ms Access?

ANSWER: one-to-many relationships occur when each record in table A may have linked record in table B. For example , the relationship between a Teacher table and student tables in an elementary school database.

Click here and BUY NOW for UGC NET  Preparation Book and also useful for Library Trainee Exam Thanks for Visiting  Asheesh Kamal Click here and BUY NOW  for UGC NET Exam Preparation Book