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