--- type: Quiz title: MS Excel MCQ Quiz for Government Exams - Part 2 canonical: "https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-2" subject: ms-excel questions: 79 free: true updated: null tags: ["mcq", "practice", "ms-excel"] --- # MS Excel MCQ Quiz for Government Exams - Part 2 79 multiple-choice questions with answers. ## Q1. "New Comment" options can be found under _____ tab A. Insert B. Data C. Review D. View **Answer:** c ## Q2. In maximum, how many sheets can be set as a default while creating new workbook? A. 254 B. 255 C. 256 D. No Limit **Answer:** b ## Q3. A typical worksheet has _____ number of columns in Excel 2019. A. 16384 B. 32000 C. 65535 D. 1024 **Answer:** a ## Q4. How many characters can be typed in a single cell in Excel? A. 1024 B. 32767 C. 256 D. 65535 **Answer:** b ## Q5. You can activate a cell by A. Pressing the Tab key B. Clicking the cell C. Pressing an arrow key D. All of the above **Answer:** d ## Q6. Which of the following is not a basic step in creating a worksheet ? A. Save Workbook B. Modify the worksheet C. Enter text and data D. Copy the worksheet **Answer:** d ## Q7. Concatenation of text can be done using A. Apostrophe (') B. Exclamation (!) C. Hash (#) D. Ampersand (&) **Answer:** d ## Q8. Data can be arranged in a worksheet in a easy to understand manner using A. auto formatiing B. applying styles C. changing fonts D. All of above **Answer:** d ## Q9. Which of the following is invalid statement? A. Sheets tabs can be colored B. Some picture can be applied as a background of a sheet C. You can set the column width automatically fit the amount of text D. The width of a row can be specified manually or fit automatically. **Answer:** d ## Q10. When the formula bar is activated, you can see A. The Edit formula button B. The Cancel button C. The Enter button D. All of the above **Answer:** d ## Q11. When you work with large worksheets, you may need to A. Size the worksheet to fit on the specific number of pages B. Add and remove page breaks C. Specify only certain print areas D. All of above **Answer:** d ## Q12. What does the VLOOKUP function do? A. Looks up text that contain B. Checks whether text is the same in one cell as in the next C. Finds related records D. All of above **Answer:** c ## Q13. Which of the following methods can not be used to enter the data in a cell? A. Pressing an arrow key B. Pressing the Tab key C. Pressing the Esc key D. Clicking on the formula bar **Answer:** c ## Q14. Which of the following will not cut information? A. Pressing Ctrl+C B. Selecting Cut from quick access toolbar C. Clicking the cut button on Home Tab D. Pressing Ctrl + X **Answer:** a ## Q15. This type of software is similar to an accountant's worksheet A. Word processing B. Database C. Spreadsheets D. Graphics **Answer:** c ## Q16. Which of the following is the oldest spreadsheet package? A. VisiCalc B. Lotus 1-2-3 C. Excel D. StarCalc **Answer:** a ## Q17. Which of the following is a popular DOS based spreadsheet package? A. Word B. Smart cell C. Excel D. Lotus 1-2-3 **Answer:** d ## Q18. A worksheet range is a A. A command used for data modeling B. A range of values such as from 23 to 234 C. A group of cells D. A group of worksheets **Answer:** c ## Q19. Which of the following formulas will excel not be able to calculate A. =SUM(Sales)-A3 B. =SUM(A1:A5)*.5 C. =SUM(A1:A5)/(10-10) D. =SUM(A1:A5)-10 **Answer:** a ## Q20. To copy cell contents using drag and drop press the A. End key B. Shift key C. Ctrl key D. Esc key **Answer:** c ## Q21. Each excel file is called a workbook beacuse A. It can contain text and data B. It can be modified C. It can contain many worksheets and charts D. You have to work hard to create it **Answer:** c ## Q22. Which button do you click to add up series of numbers? A. The autosum button B. The formula button C. The quicktotal button D. The total button **Answer:** a ## Q23. Which function will you use to enter current time in a worksheet cell? A. = today () B. ctrl + shift + ; C. = now () D. = time () **Answer:** b ## Q24. Which of the following is not a valid Zoom percentage in Excel? A. 10 B. 100 C. 300 D. 500 **Answer:** d ## Q25. When you insert an Excel file into a word document, the data are A. Hyperlinked B. Placed in a word table C. Linked D. Embedded **Answer:** c ## Q26. Macros "run" or executed from the ______ menu A. Insert B. Formats C. View D. Data **Answer:** c ## Q27. How are data organized in a spreadsheet A. Lines and spaces B. Layers and planes C. Rows and columns D. Height and width **Answer:** c ## Q28. In a worksheet you can select A. The entire worksheet B. Rows C. Columns D. a, b and c **Answer:** d ## Q29. Which types of charts can excel produce A. Lines graphs and pie charts only B. Only line graphs C. Bar charts, line graphs and pie charts D. Bar charts and line graph oly **Answer:** c ## Q30. You want to track the progress of the stock market on daily basis. Which type of chart should you use? A. Pie chart B. Row chart C. Line chart D. Column chart **Answer:** c ## Q31. Which of the following is not a way to complete a cell entry? A. Pressing enter B. Pressing any arrow key on the keyboard C. Clicking the Enter button on the Formula bar D. Pressing spacebar **Answer:** d ## Q32. You can use the horizontal and vertical scroll bars to A. Split a worksheet into two panes B. View different rows and columns to edit the contents of a cell C. Edit the content of a cell D. View different worksheets **Answer:** b ## Q33. Which symbol is used before a number to make it a label? A. = (equal) B. "(quote) C. _(underscore) D. (apostrophe) **Answer:** d ## Q34. Right clicking something in Excel A. Nothing the right mouse button is there for left handed people B. Opens a shortcut menu listing everything you can do to the object C. Selects the objects D. Deletes the object **Answer:** b ## Q35. To delete an embedded object, first A. Double click the object B. Select the object by clicking it C. Press the Shift + Delete keys D. Select it and then press the delete key **Answer:** d ## Q36. When creating a vertical page break A. The active cell must be A1 B. The active cell can be anywhere in the worksheet C. The active cell must be in row 1 D. The active cell must be in column A **Answer:** c ## Q37. To create a formula, you can use A. Values or cell references althrough not both at same time B. Values but not cell references C. Cell references but not values D. Values and cell references **Answer:** d ## Q38. Excel probably considers the cell entry January 1, 2000 to be a A. Label B. Value C. Formula D. Text string **Answer:** b ## Q39. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? A. Press Ctrl+Home B. Press Home C. Press Shift+Home D. Press Alt+Home **Answer:** a ## Q40. Which of the following methods can not be used to edit the contents of a cell A. Press the Alt key B. Clicking the formula bar C. Pressing the F2 key D. Double clicking the cell **Answer:** a ## Q41. Microsoft Excel is a powerful ______ A. Word processing package B. Spreadsheet package C. Communication S/W package D. DBMS package **Answer:** b ## Q42. Excel files have a default extension of A. Xlsx B. Xlw C. Wk1 D. 123 **Answer:** a ## Q43. An excel workbook is a collection of A. Workbooks B. Worksheets C. Charts D. Worksheets and Charts **Answer:** d ## Q44. Which of the following is latest version of Excel? A. 2007 B. 2019 C. 2003 D. 2016 **Answer:** b ## Q45. Which area in an excel window allows entering values and formulas? A. Title bar B. Menu bar C. Foumula bar D. Standard toolbar **Answer:** c ## Q46. Which symbol must all formula begin with? A. = B. + C. ( D. @ **Answer:** a ## Q47. Ms-Excel is based on ______? A. Windows B. DOS C. UNIX D. OS/2 **Answer:** a ## Q48. To save a workbook, you: A. Click the save option in File Menu B. Press Ctrl+F5 C. Click Save on Windows Start Button D. Select Edit Save **Answer:** a ## Q49. The first cell in excel worksheet is labeled as A. AA B. A1 C. Aa D. A0 **Answer:** b ## Q50. Excel displays the current cells address in the A. Formula bar B. Status bar C. Name box D. Title Bar **Answer:** c ## Q51. The name box A. Shows the location of previously active cell B. Appers to the left of the formula bar C. Appears below the status bar D. Appears below the menu bar **Answer:** b ## Q52. What is the shortcut key to hide entire row? A. Ctrl + H B. Ctrl + R C. Ctrl + 9 D. Ctrl + - **Answer:** c ## Q53. A worksheet can have maximum ______ number of rows in Excel 2019? A. 256 B. 10,48,576 C. 32000 D. 65535 **Answer:** b ## Q54. What is the shortcut key to replace a data within sheet A. Ctrl + R B. Ctrl + Shift + R C. Ctrl + H D. Ctrl + F **Answer:** c ## Q55. To select an entire column in MS-Excel, press ? A. Ctrl + C B. Ctrl + Arrow Key C. Ctrl + S D. None of the above **Answer:** d ## Q56. What is the shortcut key to highlight the entire column ? A. Ctrl + C B. Ctrl + Enter C. Ctrl + PageUp D. Ctrl + Spacebar **Answer:** d ## Q57. What do you mean by Workspace ? A. Group of columns B. Group of worksheets C. Group of Rows D. Group of Workbooks **Answer:** d ## Q58. The software which contains rows and columns is called ______ A. Database B. Drawing C. Spreadsheet D. Word processing **Answer:** c ## Q59. Which of the following syntax is correct regarding SUM function in Excel? A. = SUM (A1, B1) B. = SUM (A1:B9) C. = SUM (A1:A9, B1:B9) D. All of the above **Answer:** d ## Q60. What is the symbol for dividing ? A. / B. % C. & D. # **Answer:** a ## Q61. What is the symbol of multiplying? A. > B. / C. ! D. * **Answer:** d ## Q62. What is an example of function? A. = add (A1:A2) B. = A1 + A2 C. = SUM (A1:A2) D. A1 + A2 **Answer:** c ## Q63. What is an example of formula ? A. = A1 + A2 B. = add (A1:A2) C. A1 + A2 D. SUM (A1:A2) **Answer:** a ## Q64. Which key do you press to check spelling? A. F3 B. F5 C. F7 D. F9 **Answer:** c ## Q65. Where a row and column meet, what do you call that? A. A cell B. A block C. A box D. None of the above **Answer:** a ## Q66. Which of the following is not a term of MS-Excel? A. Cells B. Rows C. Columns D. Document **Answer:** d ## Q67. Which chart can be created in Excel A. Area B. Line C. Pie D. All of these **Answer:** d ## Q68. Ctrl + D shortcut key in Excel will A. Open the front dialog box B. Apply double underline for the active cell C. Fill down in the selection D. None of the above **Answer:** c ## Q69. In order to perform a calculation in a spreadsheet, you need to use a: A. Table B. Formula C. Field D. variable **Answer:** b ## Q70. Formatting a cell in Currency, you can specify A. Decimal Places B. Currency Symbol C. Both of above D. None of the above **Answer:** c ## Q71. Which of the following is not an option of spelling dialog box? A. Edit B. Ignore C. Ignore all D. Change **Answer:** a ## Q72. You can add image to a template by clicking the picture from ______. A. Design B. Slideslow C. Insert D. Review **Answer:** c ## Q73. Which of the following is not an example of a value? A. 350 B. May 10 2001 C. 0.57 D. Serial Number 50771 **Answer:** d ## Q74. Which of the following options is not located in the Page Setup dialog box? A. Page Break Preview B. Page Orientation C. Margins D. Headers & Footers **Answer:** a ## Q75. Which of the following is not a valid data type in excel A. Number B. Character C. Label D. Date/time **Answer:** b ## Q76. Hyperlinks can be A. Text B. Drawing objects C. Pictures D. All of above **Answer:** d ## Q77. You can open the Sort dialog box by choosing Sort from A. View B. Formats C. Tools D. Data **Answer:** d ## Q78. In Excel, by default Numeric Values appears in A. Left aligned B. Right aligned C. Center aligned D. Justify aligned **Answer:** b ## Q79. What will be the result if you type =A1=B1 in cell C1? A. Yes of No B. True or False C. Value of A1 D. Value of B1 **Answer:** b --- Source: https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-2 Site: https://www.easy2crack.com · Machine index: https://www.easy2crack.com/llms.txt · MCP: https://www.easy2crack.com/mcp