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.

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.

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)

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.

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.

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.

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.

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.

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

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.