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

61. Write down the keyboard shortcut for the following functions of MS Word:-

a) Opening the File Open dialogue box: ANSWER: Ctrl + O

b) Saving the current document: ANSWER: Ctrl + S

c) Opening the Print dialogue box: ANSWER: Ctrl + P

d) Closing the current document: ANSWER: Ctrl + W

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

62. What is chart in MS Excel? Name three types of charts?

ANSWER: charts present data in a visual way that makes it easier to see the meaning behind the numbers.

1. Column chart

2. Line chart

3. Bar chart

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

63. How can you select a range of cells located next to each other?

ANSWER: Select the first cell-> shift + Click to the last cell to select the range of cell.

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

64. What is AutoFill in MS Excel 2007?

ANSWER: Auto fill is a process in MS Excel which is used to replicate a series of numbers, number and text combination, dates or time periods, Formulas, functions based on a pattern that we establish.

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

Q.No-65.What is a Function In MS Excel? How can you display the maximum value within the range C4:C9?

ANSWER:

Function in MS excel: A function allows you to calculate a result such as adding numbers together, or finding the average of a range of numbers.

Show the maximum value C4:C9 =MAX(C4:C9)

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

Q.No-66.What are the available data types in MS Access 2007 ?

ANSWER: Available data types in MS access:1.Text 2.Memo 3.Number 4.Auto number 5.Date/Time 6.Currency 7.OLE Object 8.Attachment 9.Yes/No

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

Q.No-67. How can you add criteria to an MS Access query?

ANSWER: we can add criteria in ms access query from the design view of query object. For example: >=01/01/2006 AND <=01/06/2006, >=60, Like “*joh*”

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

Q.No-68.What are Wildcards?

ANSWER: Wildcards are special characters that use within a query to specify or exclude certain characters. Wildcard character example %,?,* etc

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

Q.No-69.What are the uses of database?

ANSWER: Database mainly used for —

1.A phone Directory 2.To identify criminals and store records.

3. Patients records 4.Tax details e.t.c

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

Q.No-70.What is slide shorter view in MS PowerPoint?

ANSWER: Slide shorter view in PowerPoint is a window that displays thumbnail versions of all our slides, arranged in horizontal rows/grids.

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

Q.No-71. Write the steps to change background color on all the slides within a presentation?

ANSWER:

Open MS PowerPoint –> Design Tab-> background style –>format background –>Select color –>apply to all.

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

Q.No-72. How can you apply automatic slide numbering in your presentation?

ANSWER: Open MS PowerPoint->Insert Tab-> header & footer->Slide tab->Check the slide number->save our change.

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

Q.No-73.What is search engine?

ANSWER: a search engines holds information about pages on websites throughout the internet. It has only information about websites which have been to it, or ones that it has found out about automatically. Ex. Google, Bing, Yahoo etc

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

Q.No-74.What are the issues to consider when sending file attachments in your mail?

ANSWER:

Attachments should not contain executable (.exe) files.

Attachments should not contain virus.

File size should be less than the declared file size in email.

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

Q.No-75. What are the full forms of the abbreviations: HTTP, FTP, WWW?

ANSWER: HTTP: Hyper Text Transfer Protocol.

FTP: File Transfer Protocol.

WWW: World Wide Web. 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