Microsoft Excel Computer Operator MCQ on Excel (Set 1) February 16, 2021February 16, 2021 Tech4nep 0 Comments computer, computer operator, computer operator quiz, excel, Loksewa, loksewa aayog, mcq, MS excel, PSC, public service commission Hello every one this is our first computer operator mcq set on excel. Here we are trying to collect multiple choice question form Microsoft excel. Welcome to your Computer Operator MCQ on Excel 1. The default row height in a MS excel worksheet is .. points.10.7512.7513.7515.75 2. Which of the following formula is true in excelB6+C6=B6+C6A6+B6A6+C6= 3. Operator used to combine text form two cells into one cell& (ampersand)= (Equal sign)(Space)All 4. Which symbol is used before a number to make it into a label in Ms excel?" (Quote)= (Equal)_ (Underscore)' (ampostrophe) 5. Which of the following is not valid data type in Ms Excel?NumberCharacterLabelData/time 6. In Ms Excel, commentes put in cell are called.....Smart tipCell tipWeb tipSoft tip 7. Workbook is a collection ofCellsWorksheetsWorkspaceProjects 8. Shortcut key to bring format cell dialog box is:Ctrl+FCtrl+ECtrl+1Ctrl+D 9. The cell reference $A$5 is a....Relative cell referenceAbsolute cell referenceMixed cell referenceNone of the above 10. 'OR' operator shows 'TRUE' value when..All conditions are falseAny one conditions is trueBote condition are trueBoth B and C 11. Xls is the file extension for ... 2003.MS WordMS XlsMS ExcelNone 12. The formula is MS Excel start with../ (divide)+ (plus)= (Equal)None 13. The advantage of using the spreadsheed is:Calculation can be done automaticallyChanging data automatically updates calculationMore flexibilityAll 14. These are the three types of data found in spreadsheets.Data, words, numbersEquation, data, numbersWords, Numbers, labelsNumbers, formula, labels 15. To merge a cells which tab do you use form the format cell menu?Number tabAlignment tabFont tabMarge tab 16. How do you rearrange the data in ascending or descending order?Data, sortData, formData, tableData, subtotal 17. Which of the following is an aubulate cell reference?!A!!#A#1$A$1A1 18. which symbols formula beings with?=+(@ 19. To add two cells (A1 and A2) together you use the following formula=A1+A2=add(A1+A2)=together(A1:A2)A1 plus A2 20. On the excel sheet the active cell in indicate bya dark wide boardera dotted boardera blinking boarderNone of the above Time is Up! click here to find more MCQ Sets.