Microsoft Excel (Basic-Advance Knowledge|Govt Exams/Competitive exam) MCQ's




Question 421 :
By default the cell pointer moves down when you press Enter. From where can you change this setting?

  1. Tools > > Options ? View tab
  2. Tools ? Options ? Calculation tab
  3. Tools ? Options ? Edit tab
  4. Tools ? Options ? Transition tab
  

Question 422 :
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

  1. Re-format the spreadsheet
  2. Insert a row
  3. Increase the column width
  4. Use the spacebar
  

Question 423 :
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

  1. Point to speech on the tools menu, and then click show text to speech toolbar.
  2. Click validation on the data menu
  3. Point to speech on the tools menu, and then click speech recognition
  4. All of above
  

Question 424 :
Which of the following types of tables constraints will prevent the entry of duplicate rows?

  1. Primary key
  2. Unique
  3. Null
  4. Foreign key
  
Pages