Computer Science Set-10 | Qu-50 | MCQ | PGT | BPSC TRE | STET | UGC Net

Computer Science MCQ SET-10 (50 Qu.)

Question 151: In MS Excel what is the value of   =FLOOR(sum(9,3.27), product(1,2))

1. 13
2. 12
3. 11
4. 10

Question 152: In MS Excel , if A1 contains 11 , then  what is the value of  =IF(A1=11,Average(8,4),sum(2,5))

1. 6 
2. 7
3. 12
4. 11

Question 153: In MS Excel if A1 cell contains -20  and  A2 cell contains 20  then what is the value of  =ABS(A1)+ABS(A2) ?

1. - 20        
2. 0
3. 40
4. 20

Question 154: Which of the following option is not located in Page Setup dialog box?

1. Page Break Preview
2. Page Orientation
3. Margins
4. Head and Footers

Question 155: The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called

1. freezing
2. locking
3. selecting
4. fixing

Question 156: Which of the following is not the correct method of editing the cell content?

1. Press the Alt key
2. Press the F2 key
3. Click the formula bar
4. Double click the cell

Question 157: What will excel consider, if we put January 1, 2000 in any cell?

1. Label
2. Value
3. Formula
4. Text String

Question 158: How to create additional Guide Lines?

1. by holding Ctrl key, click on existing Guide Line and drag
2. by holding Alt key, click on existing Guide Line and drag
3. by holding Ctrl + Alt key, click on existing Guide Line and drag
4. Additional Guide Lines cannot be created

Question 159: In MS Excel  which function is used to  returns the first character or characters in a text string, based on the number of characters you specify.

1. LEFTCHAR()   
2. FIRSTCHAR()
3. LEFT()
4. FIRSTNSTR()

Question 160: Excel displays the current cell address in the ..........

1. Formula bar
2. Status Bar
3. Name Box
4. Title Bar

Question 161: In a PowerPoint presentation

1. Sound clips can be inserted but not movie clips
2. Movie clips can be inserted but not sound clips
3. Both cannot be inserted
4. Both can be inserted

$ads={1}

Question 162: In MS Excel what is the value of    =LEFT("NEW DELHI",15)

1. NEW
2. N
3. NEW DELHI
4. None of these

Question 163: What are the three options available in Insert >> Picture menu?

1. Clipart, Pictures, Shapes
2. Clipart, From File, Shapes
3. Clipart, From Files, AutoShapes
4. Clipart, Pictures, AutoShapes

Question 164: In MS Excel what is the value of   =ABS(if(3>2,sum(-3,2),-44))

1. -1
2. 44
3. -44
4. 1

Question 165: If you want all of the white cats grouped together in the database, you need to sort by ________.

1. Color, then Gender
2. Pet Type, then Color
3. Pet Type, then Gender
4. Color, then Pet Name

Question 166: What happens if you select first and second slide and then click on New Slide button on toolbar?

1. A new slide is inserted as first slide in presentation
2. A new slide is inserted as second slide in presentation
3. A new slide is inserted as third slide in presentation
4. None of above

Question 167: In MS Excel what is the value of   =IF(2>3,”T”,”F”)

1. T
2. F
3. 2>3
4. 1

Question 168: When integrating Word and Excel, Excel is usually the ______.

1. Server
2. Client
3. Source
4. None of these

Question 169: What is to be use to add text in Slide?

1. Text Box
2. Note Box
3. Text Layer
4. Comment Box

Question 170: Find the odd one out.

1. KitKat 
2. Oreo
3. Eclair
4. Cadbury         

Question 171: An Excel Workbook is a collection of .......

1. Workbooks
2. Worksheets
3. Charts
4. Worksheets and Charts

Question 172: What is the shortcut key for repeat the recent find?

1. CTRL + F4
2. SHIFT + F4
3. CTRL + F5
4. SHIFT + F5

Question 173: Which of the following series type is not valid for Fill Series dialog box?

1. Linear
2. Growth
3. Autofill
4. Time

Question 174: Choose the one which is different from other three.

1. ZOOM
2. MS Word
3. Microsoft Team
4. Cisco Webex     

Question 175: Excel is a

1. Graphic program
2. None of these
3. Data processor
4. Spreadsheet

Question 176: who is the Sender in terms of email.

1. Person who receives the mail
2. Person who Hack your mail
3. Person who sends the e-mail
4. Person who help you to create an e-mail

Question 177: To select an entire column in Excel, press ______.

1. Ctrl + Spacebar
2. CTRL + SHIFT + :(colon)
3. CTRL + F10
4. None of the above

Question 178: The balance sheet contains 5 pages but there is requirement of third page only. How would you print 5 copies of third page?

1. Select File ->Properties and type 3 in page from & 3 in page to, then click print
2. Select File -> Print from the menu, then type 3 in page from & 3 in page to, then Hit 5 from Keyboard then press Enter
3. Select File -> Print from the menu, then type 3 in page from & 3 in page to, then type 5 in copes then press Enter
4. Press Ctrl+P+3+5

Question 179: Excel displays the current cell address in the _______.

1. Name box
2. Formula box
3. Text box
4. None of the above

Question 180: In MS excel, we use Auto Sum to

1. Add grand totals to a range containing other totals
2. Total any selected range
3. Locate and total the rows or columns in a range nearest to the current cell
4. All of the above

Question 181: In MS Office 2007, how many sheets are there in Excel Workbook by default?

1. 2
2. 3
3. 4
4. 5

$ads={2}

Question 182: If you want to insert some slides from other presentation into current one choose

1. From Insert menu choose Slides from Files
2. From Insert menu choose Slides from Presentation
3. From Insert menu choose Slides
4. None of above

Question 183: What is entered by the function =today()

1. The date value for the day according to system clock
2. The time value according to system clock
3. Today’s date as Text format
4. All of above

Question 184: During typing thumbs rest on the which key of the keyboard.

1. Enter Key
2. Spacebar
3. Shift Key
4. Control Key

Question 185: A numeric value can be treated as label value if ______ precedes it.

1. /
2. "
3. ?
4. .

Question 186: Which of the following can be use as slide background?

1. Gradient
2. Texture
3. Picture
4. All of the Above

Question 187: Which is the correct way to calculate average of the numbers in Ms Excel.

1. = AVERAGE(1,2,3)
2. =AVG(1,2,3)
3. Both  Can Be used
4. None of  These

Question 188: In MS Excel , if E1 cell contain -3.56  then what is the value of   =FLOOR(E1, -2)

1. -3
2. -1
3. -4
4. -2

Question 189: How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

1. F8
2. F9
3. F10
4. F11

Question 190: In MS Excel , if A1 cell contain 9.5 then what is the value of   =CEILING(A1,2)

1. 9
2. 10
3. 9.5
4. 11

Question 191: Programs stored in ROM are called-

1. Hardware
2. Firmware
3. Freeware
4. Software

Question 192: Which function is used to remove the fractional part of the number in Excel?

1. SQRT
2. TRUNC
3. ABS
4. SLN

Question 193: ______ stores data in a table.

1. Row
2. Column
3. Cell
4. Grid

Question 194: What does =COUNTA () function do?

1. counts cells having alphabets
2. counts empty cells
3. counts cells having number
4. counts non-empty cells

Question 195: Which of the following format you can decide to apply or not in AutoFormat dialog box?

1. Number format
2. Border format
3. Font format
4. All of above

Question 196: You can move a sheet from one workbook into new book by

1. From Edit menu choose Move or Copy sheet, mark the Create a copy and Click OK
2. From Edit menu choose Move of Copy then choose (Move to end) and click OK
3. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
4. None of above

Question 197: To join two or more strings in Excel which of the following function is used?

1. Concatenate()
2. Join()
3. Add()
4. All of the above

Question 198: Pressing Shift + F11 will ______ a new worksheet

1. Insert
2. Delete
3. Edit
4. Save

Question 199: How do you tell one cell from another?

1. By numbers
2. By letters
3. By its address
4. by color

Question 200: In MS Excel what is the value of   =LEN(CONCATENATE("patna","hello"))

1. 12 
2. 10
3. patna
4. 5