MS Excel Practice Session 2Basic Instructions for MCQ OnlineThe examination will comprise of Objective type Multiple Choice Questions (MCQs)All questions are compulsory and each carries One mark.There will be NO NEGATIVE MARKING for the wrong answers. 1. Which key do you press to check spelling? F4 F7 F12 F62. In Microsoft Excel spreadsheets, COLUMNS are labelled as _______ I,II,III,….. A,B,C,…. A1,B1,C1…. 1,2,3,…..3. Can we view gridline and heading in print preview ? No Yes4. Which of the following options is not located in the Page Setup dialog box? Margins Headers and Footers Page Break Preview Page Orientation5. To activate Microsoft excel through run command, the keyword is Excel Msexcel microsoftexcel Winexcel6. Which option is used to join the selected cells into single cell and center the content of cell ? Merge Across Merge & Center Merge Cell Unmerge ell7. Which of the following is not a term of MS-Excel? Columns Document Cells Rows8. Which of the following methods are used to edit cell Formula tab Name box F1 F29. In MS Excel, keyboard shortcut keys to create a new workbook is _____ Alt + N Shift + N Ctrl + W Ctrl + N10. Which of the following methods cannot be used to enter data in a cell Clicking on the formula bar Pressing an arrow key Pressing the Esc key Pressing the Tab key11. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data. Worksheet ARRAY Workbook Spreadsheet12. Which of the following is the latest version of Excel Excel 2016 Excel 2007 Excel 2010 Excel 201913. In a worksheet you can select Rows The entire worksheet Columns All of these14. In Microsoft Excel spreadsheets, CELLS are labelled as _______ 1,2,3,….. A,B,C,…. I,II,III,….. A1,B1,C1….15. Which symbol must all formula begin with? @ # = +16. Which key is used for help in MS excel? F1 F4 F2 F317. You can edit a cell by Using Name Box Selecting Edit > Edit Cell from the menu Double clicking the cell to edit it in-place Clicking the formula button18. Which Chart can be created in Excel? Line Area All of the these pie19. MS Excel stands for ___________ Micromax Excel Microsoft Excess Microsoft Excel Management Excel20. Which of the following is not the correct method of editing the cell content? Double click the cell Press the F2 key Press the Alt key Click the formula bar21. Open “Microsoft Office Excel Help”. F11 F2 F1 F1022. Excel displays the current cell address in the ________ Title Bar Name Box Formula bar Status Bar23. MS-EXCEL is based on ________ DOS UNIX OS/2 WINDOWS24. A formula in Excel always begins with an ____ Sign Multiply Equal Minus Plus 25. Which menu option can be used to split windows into two Format > window Window > split View > split View > window > split26. You can activate a cell by All of the above Pressing the Tab key Pressing an arrow key Clicking the cell27. Which shortcut key is used to comment to cell Ctrl + F2 F3 F2 Shift + F228. The name box Appears to the right of the formula bar Shows the location of the active cell Appears below the menu bar Appears below the status bar29. Can we use table in excel to create filter ? No Yes30. Which area in an Excel window allows entering values and formulas? Standard Tool Bar Menu Bar Title Bar Formula Bar31. An Excel Workbook is a collection of ________ Workbooks Worksheets and Charts Worksheets Charts32. Comments put in cells are called Web Tip Soft Tip Cell Tip Smart Tip33. In Microsoft Excel spreadsheets, rows are labelled as _______ A1,B1,C1…. 1,2,3,….. I,II,III,….. A,B,C,….34. Comments can be added to cells using Insert > Comments Review > Comments File > Comments Edit > Comments35. Which term is used to join the selected cells in to one cell? Clear formatting Wrap text Merge & Center wrap36. Comments can be edited using _____ Edit > Comments File > Comments Review > Comments Insert > Comments37. Which is used to perform what if analysis? All of these Scenario Manager Data Table Goal seek38. The intersection of a column and a row in MS Excel worksheet is known as _______ Cell Tab Columns Rows39. Can we use formula bar to edit formula ? No Yes40. How many worksheets can we added in a workbook? 105 255 256 25741. Excel files have a extension ___________ txt doc xlsx xlm42. Which of the following methods can be used to edit the contents of a cell? Pressing the F2 key Clicking the formula bar Press the Alt key Double clicking the cell43. A ________ is a grid with labeled columns and rows. Worksheet Clipboard Dialog box Toolbar44. _____ can be used as a keyboard shortcut key to check spelling in MS Excel. F7 F2 F11 F645. All of the above Today () Now () Time () Date ()46. A typical worksheet has ________ number of rows 1048577 1048567 1047859 104857647. Microsoft Excel is a powerful ________ DBMS package Communication S/W Package Word processing package Spreadsheet package48. Which area in an excel window allows entering values and formulas Title bar Formula bar Menu bar Name Box49. MS Excel is a ________ Spreadsheet software Presentation software Workbook software Database Management software50. Excel is a program that is used to prepare a Database Text document Slide presentation Spreadsheet51. To view a cell comment Position the mouse pointer over the cell Click the display comment command on the window menu Click the edit comment command on the insert menu Click the comment command on the view menu52. The first cell in excel worksheet is _______ AB AA A1 B153. Which of the following methods can not be used to edit the contents of a cell? Pressing the F2 key Press the Alt key Clicking the formula bar Double clicking the cell54. What is the shortcut key to replace a data with another in sheet? Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R55. A typical worksheet has ________ number of columns 16384 16348 16844 16843 Loading …Question 1 of 55