| 
   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. 
 
 
  
   | 
 
0 Comments