Advance Ms ExcelWelcome to your Advance Ms Excel MCQ Full Name 1. What is the intersection of a column and a row on a worksheet called ?ValueColumnAddressCell2. Which function in Excel tells how many numeric entries are there ?NUMCHKNUMCOUNTSUM3. Which one is not a Function in MS Excel ?SUMAVGMAXMIN4. Functions in MS Excel must begin with ___An () signA Plus SignA > SignAn Equal Sign5. In Excel, Columns are labelled as ___1,2,3 etcA, B, C, etc$A$1, $A$2, etcA1, A2, etc6. In Excel, Rows are labelled as ______A1, A2, etc1,2,3 etcA, B, C, etc$A$1, $A$2, etc7. What do you use to create a chart?Chart WizardExcel WizardData WizardPie Wizard8. How many sheets are there, by default, when we create a new Excel file?310159. An Excel file is generally called a / an :WorkbookWoorksheetE-SpreadsheetSheet10. Which Key Is Used For Help In Ms Excel?F1F3F4F211. A Spreadsheet contains?rowscolumnsrows and columnsNone of above12. Which among following is associated with excel ?PresentationWord ProcessorGraphic programSpreadsheet13. Protection and the Protect Sheet options can be selected from ?DataEditToolsFormat14. Which of the following is not a valid Zoom percentage in Excel ?1001050040015. Which among following is divide symbol in excel ?%\Div/16. Shortcut to edit the selected cell ?F8F2F4F317. Shortcut to enter current date ?Home + ;Ctrl + ;Alt + ;Shift + ;18. This is not a function category in Excel.TextData seriesLogicalFinancial19. Which bar show the used formula of selected active cell?RibbonScroll barMenu barFormula bar20. Comments put in cells are calledSoft tipSmart tipWeb tipCell tip21. Which is used to perform what if analysis?Data TableAll of theseGoal seekScenario Manager22. Which of the following options is not located in the Page Setup dialog box?Headers and FootersPage OrientationMarginsPage Break Preview.23. Which of the following is an absolute cell reference?A1#a#1$A$1!A!124. Which symbol must all formula begin with?<#=@25. Which of the following formulas is not entered correctly?=B7*B1=10+50=B7+1410+5026. Which of the following formulas will Excel Not be able to calculate?=SUM(Sales)-A3=SUM(A1:A5)-10=SUM(A1:A5)/(10-10)=SUM(A1:A5)*.527. NOT, AND, OR and XOR are ________Relational operatorsLogical OperatorsNone of the aboveArithmetic operators28. What is the symbol for multiplying in excel?/X*#29. Which of the following is correct?=AVERAGE(A1, B1, C1)=AVERAGE(A1:A9, B1:B9)All these Answer=AVERAGE(4, 5, 6, 7)30. Which of the following function will return a value of 8?ROUNDDOWN(8.4999, 0)ROUNDUP(8.4999, 0)ROUNDDOWN(8.4999, 0) and ROUND(8.4999, 0)ROUND(8.4999, 0)31. Which of the following function will use to find the highest number in a series of number?HIGHEST(B1:B3)MAX(B1:B3)HIGH (B1:B3)MAXIMUM (B1:B3)32. What value will display if the formula = “$55.00″+5 is entered into a cell?$60.0060“$55.00″+5$6033. Which of the following syntax is correct regarding to SUM function in Excel?=SUM (A1:B9)=SUM (A1, B1)All these Asnwer=SUM (A1:A9, B1:B9)34. Which of the following is correct syntax in Excel?=IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)=IF(LogicalTest, TrueResult, FalseResult)=IF(LogicalTest, (TrueResult, FalseResult))=IF(LogicalTest, TrueResult), IF(LogicalTest, 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?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. BothCut and PasteEdit >> Paste Special >> Transpose37. To return the remainder after a number is divided by a divisor in EXCEL we use the function?FACT ( )DIV ( )ROUND ( )MOD ( )38. Which function is not available in the Consolidate dialog box?SumMaxPmtAverage39. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?54305436.805436.86.840. How do you display current date and time in MS Excel?time()today()date()now()41. Which language is used to create macros in Excel?Visual BasicVisual C++JavaC++42. Conditional Formationg Option available in _____ tabinserthomeviewfile43. Wrap text Option available in ______fontalignmentNumberstyle44. Pivot Table Option in _________ tab.InsertDataViewHome45. Which is a mini chart create in single cellsSparkLinesPai ChartColumn ChartPivot Chart46. Print Area is Used for________Find out area.Print PagePage SetupSelect Specific data and Print Page47. If we want to display formula how we can see?All of these...Doble click on specific formulaFormula>> Show FormulaClick on cell and formula display in formula bar48. Import Data from following Option available in Excel....Ms AccessAll these optionText & sql serverWeb49. Developer option Not Available in Excel.TrueFalse50. Vlookup Formula find data from leftmost column of a table.FalseTrueRelatedShare