Computer Science MCQ PowerPoint

[ AdSense Top Slot ]

Question 1: In MS Excel if cell A1 contain value 10, then what is the value of    =if(A1>MOD(A1,4),right("NEW DELHI",9),RIGHT("OLD DELHI",13))

  1. NEW
  2. OLD
  3. NEW DELHI
  4. OLD DELHI

Question 2: How to change the order of Slides in Presentation?

  1. On Slide Sorter View, click on the Soft Slides
  2. On Slide Sorter View, click on the slide and drag to required position
  3. On Slide Thumbnail view, click on the slide and drag to required position
  4. Slides order cannot be changed once it created

Question 3: List Box and Text box

  1. Are some other than that in a list box the bullets are enabled
  2. Are different. List boxes are used to present lists and can't be created with text boxes.
  3. Both of above
  4. None of above

Question 4: In MS Excel what is the value of   =AVERAGE(sum(2,4),MOD(20,6))

  1. 2
  2. 3
  3. 4
  4. 7

Question 5: Which command will you choose to convert a column of data into row?

  1. Cut and Paste
  2. Edit >> Paste Special >> Transpose
  3. Both of above
  4. None of above

Question 6: What is defined by Handout Master?

  1. Slide Formatting
  2. Slide Transaction
  3. Layout of Handout
  4. Layout of Slide

Question 7: In MS Excel what is the value of   =if(11<5,LEN("patna"),LEFT("WORLD"))

  1. WORLD
  2. 5
  3. patna
  4. W

Question 8: Find the odd one out.

  1. Whatsapp
  2. Telegram
  3. HIKE   
  4. MX Player

Question 9: In MS Excel what is the value of   =LEFT("patna")

  1. patna
  2. pat
  3. pa
  4. p

Question 10: Give me an correct example of a cell address.

  1. 10 2
  2. 8 A2
  3. 51A
  4. A31

Question 11: In MS Excel what is the value of   =MOD(MOD(33,7),8)

  1. Generate Error
  2. 0
  3. 5
  4. 8

Question 12: What is the maximum number of Hyperlinks in a worksheet?

  1. 66530
  2. 66780
  3. 66785
  4. 65780

Question 13: In Excel, the Fill Color button on the Formatting toolbar is used for what?

  1. To insert a background.
  2. To add borders.
  3. To select a distribution of figures.
  4. To add shading or color to a cell range.

Question 14: Which of the following statements is not true?

  1. You can type text directly into a PowerPoint slide but typing in text box is more convenient.
  2. From Insert menu choose Picture and then From File to insert your images into slides.
  3. You can display a PowerPoint presentation in Normal, Slide Sorter or Slide Show view.
  4. You can show or hide task pane from View >> Toolbars

Question 15: What happens if you edited an image inserted in PowerPoint?

  1. The original file that was inserted is not changed
  2. The original file that was inserted is changed
  3. The original file is changed when you save presentation
  4. None of above

Question 16: Which of the following is not purely output device?

  1. Printer
  2. Speaker
  3. Plotter
  4. Screen

Question 17: Data can be arranged in ascending or descending order by using

  1. Sort command from Table menu
  2. Sort command from Data menu
  3. Sort command from Tools menu
  4. None of these

Question 18: In MS Excel what is the value of   =if(mod(4,13)>20,LEN("patna"),200)

  1. 200
  2. 20
  3. patna
  4. 1

Question 19: Which of the cell pointer indicate that you can move the content to other cell?

  1. Doctor’s symbol (Big Plus)
  2. small thin plus icon
  3. Mouse Pointer with anchor at the tip
  4. None of above

Question 20: which finger is used to press the key  P in keyboard?

  1. J-finger
  2. K-finger
  3. L-finger
  4. ;-finger

Question 21: The value of =ROUNDDOWN (89, -2) equation is:

  1. 89
  2. 90
  3. 91
  4. 0

Question 22: What is the symbol for multiplying?

  1. >
  2. /
  3. !
  4. *
[ AdSense Bottom Slot ]