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 ?
2. Which function in Excel tells how many numeric entries are there ?
3. Which one is not a Function in MS Excel ?
4. Functions in MS Excel must begin with ___
5. In Excel, Columns are labelled as ___
6. In Excel, Rows are labelled as ______
7. What do you use to create a chart?
8. How many sheets are there, by default, when we create a new Excel file?
9. An Excel file is generally called a / an :
10. Which Key Is Used For Help In Ms Excel?
11. A Spreadsheet contains?
12. Which among following is associated with excel ?
13. Protection and the Protect Sheet options can be selected from ?
14. Which of the following is not a valid Zoom percentage in Excel ?
15. Which among following is divide symbol in excel ?
16. Shortcut to edit the selected cell ?
17. Shortcut to enter current date ?
18. This is not a function category in Excel.
19. Which bar show the used formula of selected active cell?
20. Comments put in cells are called
21. Which is used to perform what if analysis?
22. Which of the following options is not located in the Page Setup dialog box?
23. Which of the following is an absolute cell reference?
24. Which symbol must all formula begin with?
25. Which of the following formulas is not entered correctly?
26. Which of the following formulas will Excel Not be able to calculate?
27. NOT, AND, OR and XOR are ________
28. What is the symbol for multiplying in excel?
29. Which of the following is correct?
30. Which of the following function will return a value of 8?
31. Which of the following function will use to find the highest number in a series of number?
32. What value will display if the formula = “$55.00″+5 is entered into a cell?
33. Which of the following syntax is correct regarding to SUM function in Excel?
34. Which of the following is correct syntax in Excel?
35. Which of the following is correct?
36. Which command will you choose to convert a column of data into row?
37. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
38. Which function is not available in the Consolidate dialog box?
39. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
40. How do you display current date and time in MS Excel?
41. Which language is used to create macros in Excel?
42. Conditional Formationg Option available in _____ tab
43. Wrap text Option available in ______
44. Pivot Table Option in _________ tab.
45. Which is a mini chart create in single cells
46. Print Area is Used for________
47. If we want to display formula how we can see?
48. Import Data from following Option available in Excel....
49. Developer option Not Available in Excel.
50. Vlookup Formula find data from leftmost column of a table.

Leave a Comment