Advance Ms Excel Welcome to your Advance Ms Excel MCQ Full Name 1. What is the intersection of a column and a row on a worksheet called ? Column Cell Value Address 2. Which function in Excel tells how many numeric entries are there ? CHKNUM COUNT NUM SUM 3. Which one is not a Function in MS Excel ? AVG MAX SUM MIN 4. Functions in MS Excel must begin with ___ A Plus Sign A > Sign An () sign An Equal Sign 5. In Excel, Columns are labelled as ___ A1, A2, etc 1,2,3 etc A, B, C, etc $A$1, $A$2, etc 6. In Excel, Rows are labelled as ______ A, B, C, etc $A$1, $A$2, etc 1,2,3 etc A1, A2, etc 7. What do you use to create a chart? Pie Wizard Chart Wizard Data Wizard Excel Wizard 8. How many sheets are there, by default, when we create a new Excel file? 3 5 10 1 9. An Excel file is generally called a / an : Workbook Woorksheet Sheet E-Spreadsheet 10. Which Key Is Used For Help In Ms Excel? F4 F2 F1 F3 11. A Spreadsheet contains? rows and columns rows columns None of above 12. Which among following is associated with excel ? Spreadsheet Word Processor Presentation Graphic program 13. Protection and the Protect Sheet options can be selected from ? Data Format Tools Edit 14. Which of the following is not a valid Zoom percentage in Excel ? 400 100 500 10 15. Which among following is divide symbol in excel ? % / \ Div 16. Shortcut to edit the selected cell ? F8 F3 F4 F2 17. Shortcut to enter current date ? Ctrl + ; Alt + ; Shift + ; Home + ; 18. This is not a function category in Excel. Logical Data series Financial Text 19. Which bar show the used formula of selected active cell? Formula bar Menu bar Ribbon Scroll bar 20. Comments put in cells are called Web tip Soft tip Smart tip Cell tip 21. Which is used to perform what if analysis? Data Table All of these Goal seek Scenario Manager 22. Which of the following options is not located in the Page Setup dialog box? Margins Page Orientation Headers and Footers Page Break Preview. 23. Which of the following is an absolute cell reference? #a#1 A1 !A!1 $A$1 24. Which symbol must all formula begin with? @ = < # 25. Which of the following formulas is not entered correctly? =10+50 10+50 =B7+14 =B7*B1 26. Which of the following formulas will Excel Not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)*.5 27. NOT, AND, OR and XOR are ________ Relational operators None of the above Logical Operators Arithmetic operators 28. What is the symbol for multiplying in excel? * / X # 29. Which of the following is correct? All these Answer =AVERAGE(A1:A9, B1:B9) =AVERAGE(A1, B1, C1) =AVERAGE(4, 5, 6, 7) 30. Which of the following function will return a value of 8? ROUNDDOWN(8.4999, 0) and ROUND(8.4999, 0) ROUNDDOWN(8.4999, 0) ROUND(8.4999, 0) ROUNDUP(8.4999, 0) 31. Which of the following function will use to find the highest number in a series of number? HIGH (B1:B3) MAX(B1:B3) MAXIMUM (B1:B3) HIGHEST(B1:B3) 32. What value will display if the formula = “$55.00″+5 is entered into a cell? $60.00 $60 “$55.00″+5 60 33. Which of the following syntax is correct regarding to SUM function in Excel? =SUM (A1:B9) =SUM (A1:A9, B1:B9) =SUM (A1, B1) All these Asnwer 34. Which of the following is correct syntax in Excel? =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult) =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) =IF(LogicalTest, (TrueResult, FalseResult)) =IF(LogicalTest, TrueResult, FalseResult) 35. Which of the following is correct? =POWER(2,3) =POWER(2#3) =POWER(2*3) =POWER(2^3) 36. Which command will you choose to convert a column of data into row? Edit >> Paste Special >> Transpose Copy Containt and Press Right >> Go to Paste Option >> click on Transpose. Edit >> Paste Special >> Transpose and Copy Containt and Press Right >> Go to Paste Option >> click on Transpose. Both Cut and Paste 37. To return the remainder after a number is divided by a divisor in EXCEL we use the function? DIV ( ) MOD ( ) FACT ( ) ROUND ( ) 38. Which function is not available in the Consolidate dialog box? Average Max Pmt Sum 39. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′? 5436.8 6.8 5436.80 5430 40. How do you display current date and time in MS Excel? date() today() now() time() 41. Which language is used to create macros in Excel? Java C++ Visual Basic Visual C++ 42. Conditional Formationg Option available in _____ tab file view insert home 43. Wrap text Option available in ______ alignment style Number font 44. Pivot Table Option in _________ tab. Data Insert Home View 45. Which is a mini chart create in single cells Pivot Chart Pai Chart Column Chart SparkLines 46. Print Area is Used for________ Select Specific data and Print Page Page Setup Print Page Find out area. 47. If we want to display formula how we can see? Doble click on specific formula Click on cell and formula display in formula bar Formula>> Show Formula All of these... 48. Import Data from following Option available in Excel.... Text & sql server Web Ms Access All these option 49. Developer option Not Available in Excel. False True 50. Vlookup Formula find data from leftmost column of a table. False True Share