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