--- type: Quiz title: MS Excel MCQ Quiz for Government Exams - Part 1 canonical: "https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-1" subject: ms-excel questions: 80 free: true updated: null tags: ["mcq", "practice", "ms-excel"] --- # MS Excel MCQ Quiz for Government Exams - Part 1 80 multiple-choice questions with answers. ## Q1. MS-Excel provides the default value for steps in Fill Series dialog box? A. 2 B. 1 C. 5 D. 10 **Answer:** b ## Q2. In the formula, which symbol specifies the fixed columns or rows? A. $ B. * C. % D. & **Answer:** a ## Q3. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the A. Unfreeze panes command on the Insert Menu B. Freeze panes command on the View Menu C. Hold titles command on the Data Menu D. Split command on the window menu **Answer:** b ## Q4. You can enter which type of data into worksheet cells? A. Labels, Values, Formulas B. Labels and Values but not formulas C. Values and Formulas but not labels D. Formulas only **Answer:** a ## Q5. Which tool you will use to join some cells and place the content at the middle of joined cell A. From View Tab click on Merge cells check box B. From format cells dialog box select the centered alignment C. From Insert Tab choose Merge and Center D. Click on Merge and Center tool on Home Tab **Answer:** d ## Q6. Which button do you click to add up a series of numbers? A. The autosum button B. The formula button C. The quick button D. The total button **Answer:** a ## Q7. Which of the following Excel screen components can NOT be turned on or off? A. Formula bar B. Status bar C. Toolbar D. None of the above **Answer:** d ## Q8. Which of the following option is not available in Paste Special dialog box? A. Add B. Subtract C. Divide D. SQRT **Answer:** d ## Q9. Which command will you choose to convert a column of data into row? A. Cut and Paste B. Right Click>>Paste Special>>Transpose C. Both of above D. None of above **Answer:** b ## Q10. Long text can be broken down into many lines within a cell. You can do this through A. Wrap Text from Home Tab B. Justify in Edit>>Cells C. Wrap Text >Cells ,Layout tab D. All of above **Answer:** a ## Q11. Which of the following series type is not valid for Fill Series dialog box? A. Linear B. Growth C. Autofill D. Time **Answer:** d ## Q12. Which of the following you can use in Paste Special command A. Validation B. Formats C. Formulas D. All of the above **Answer:** d ## Q13. To return the remainder after a number is divided by a divisor in EXCEL we use the function A. ROUND( ) B. FACT( ) C. MOD( ) D. DIV( ) **Answer:** c ## Q14. How do you rearrange the data in ascending or descending order A. Data , Sort B. Data, Form C. Data , Table D. Data Subtotals **Answer:** a ## Q15. How many worksheets can a workbook have ? A. 3 B. 8 C. 255 D. Limited by Available memory **Answer:** d ## Q16. Which would you choose to create a bar diagram? A. Edit, Chart B. Insert, Chart C. Tools, Chart D. Format, Chart **Answer:** b ## Q17. Which setting you must modify to print a worksheet using letterhead? A. Paper B. Margin C. Layout D. Orientation **Answer:** b ## Q18. We can save and protect the workbook by A. Write Reservation Password B. Protection Password C. Read Only Recommended D. Any of above **Answer:** d ## Q19. In order to perform a calculation in a spreadsheet, ou need to use a : A. Table B. Formula C. Field D. Variable **Answer:** b ## Q20. You accidentally erased a record in the sheet. What command can be used to restore it automatically? A. Insert B. Copy C. Undo D. Replace **Answer:** c ## Q21. NOT, AND, OR and XOR are A. Logical operators B. Arithmetic operators C. Relational operators D. None of above **Answer:** a ## Q22. MS-Excel can be used to automate A. Financial statements, Business forecasting B. Transaction registers, Inventory control C. Accounts receivable, accounts payable D. Any of above **Answer:** d ## Q23. What is the shortcut key to hide entire column? A. Ctrl + - B. Ctrl + 0 C. Ctrl + H D. Ctrl + C **Answer:** b ## Q24. What is the shortcut key to insert new sheet in current workbook? A. F11 B. Alt + F11 C. Ctrl + F11 D. Shift + F11 **Answer:** d ## Q25. Multiple Calculations can be made in a single formula using A. Standard formula B. Array Formula C. Complex formula D. Smart formula **Answer:** b ## Q26. How do you wrap the text in a cell? A. Format cells, font B. Format cells, protection C. Format cells, number D. Format cells, alignment **Answer:** d ## Q27. When working in the page break preview, you can A. View exactly where each page break occurs B. Add or remove page breaks C. Change the print area D. All of above **Answer:** d ## Q28. Excel uniquely identifies cells within a worksheet with a cell name A. Cell names B. Column number and row letters C. Column letters and row numbers D. All of above **Answer:** c ## Q29. 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. Specific only certain print areas D. All of above **Answer:** d ## Q30. Data can be arranged in a worksheet in an easy to understand manner using A. Auto formatting B. Applying styles C. Changing fonts D. All of above **Answer:** d ## Q31. Rounding Errors can occur A. When you use multiplication, division, or exponentiation in a formula B. When you use addition and subtraction in a formula C. Because excel uses hidden decimal places in computation D. When you show the results of formulas with different decimal places that the calculated results **Answer:** a ## Q32. Which of the following is correct? A. =AVERAGE(4,5,6,7) B. =AVERAGE(A1,B1,C1) C. =AVERAGE(A1:A9,B1:B9) D. All of above **Answer:** d ## Q33. Excel worksheet cells work very similarly to what comman element of the window graphical user interface. A. Option buttons B. List boxes C. Text boxes D. Combo boxes **Answer:** c ## Q34. When you use the fill effects in the format data series dialog box, you can not A. Rotate text on the chart B. Select a fore ground color C. Select a pattern D. Select a background color **Answer:** a ## Q35. Except for the ______ function, or formula with a logical function shows the word "TRUE" or " FALSE" as a result A. IF B. AND C. OR D. NOT **Answer:** a ## Q36. Chart tips can A. Show the formatting of a data label B. Show the name of a data series C. Show the value of data point D. b and c **Answer:** d ## Q37. To view a cell comment A. Click the edit comment command on the insert menu B. Click the display comment command on the window menu C. Position the mouse pointer over the cell D. Click the comment command on the view button **Answer:** c ## Q38. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? A. Work sheet B. Chart sheet C. Module sheet D. Data sheet **Answer:** d ## Q39. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? A. Rows and columns B. Headings C. Speed D. None **Answer:** c ## Q40. When you print preview a worksheet A. The entire worksheet is displayed B. The selected range is displayed C. The active portion of the worksheet is displayed D. a , b and c **Answer:** d ## Q41. When you see a cell with a red triangle in the top right corner, what does this signify? A. There is an error in the cell B. There is a comment associated with the cell C. The font color for text in the cell is red D. A formula cannot be entered into the cell **Answer:** b ## Q42. Which of the formulas will Excel Not be able to calculate A. =10+50 B. =B7+B1 C. =B7+14 D. 10+50 **Answer:** d ## Q43. You can use drag and drop method to A. Copy cell contents B. Move cell contents C. Add cell contents D. A and B **Answer:** d ## Q44. It is acceptable to let long text flow into adjacent cells in a worksheet when A. Data will be entered in the adjacent cells B. No data will be entered in the adjacent cells C. There is not suitable abbreviation of the text D. There is no time to format the text **Answer:** b ## Q45. The Paste Special command lets you copy and paste A. Multiply the selection by a copied value B. Cell comments C. Formatting options D. The resulting values of a formula instead of the actual formula **Answer:** d ## Q46. To insert three columns between D and E you would A. Select column D B. Select column E C. Select column E, F and G D. Select column D, E and F **Answer:** c ## Q47. A circular reference is A. Geometric modeling tool B. A cell that points to a drawing object C. A formula that either directly or indirectly depends on itself D. Always erroneous **Answer:** c ## Q48. When you copy a formula A. Excel erases the original copy of the formula B. Excel edits cell references in the newly copied formula C. Excel adjusts absolute cell references D. Excel doesn’t adjust relative cell references **Answer:** b ## Q49. You can drag and drop to embed excel worksheet data in a word document A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl Key B. By dragging a range of excel data to the word button on the taskbar while pressing Shift Key C. By dragging a range of excel data to the word button on the taskbar while pressing Alt Key D. None of Above **Answer:** a ## Q50. To drag a selected range of data to another worksheet in the same workbook, use the A. Tab Key B. Alt Key C. Shift Key D. Ctrl Key **Answer:** b ## Q51. You can select a single range of cells by A. Clicking the upper-left cell in a group of cells and then pressing the shift key while creating lower right cell in a group of cells B. Pressing the Ctrl key while dragging over the desired cells C. Pressing Shift Key and an Arrow Key D. Dragging over the desired cells **Answer:** d ## Q52. When you group worksheets A. you can enter variable data on multiple worksheets at one time B. you can print more than one worksheet at a time C. you can enter common data, formats, and formulas on multiple worksheets at one time D. b and c **Answer:** d ## Q53. When all the numbers between 0 and 100 in a range should be displayed in Red color , apply A. Use =if() function to format the required numbers red B. Apply Conditional formatting command on format menu C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool D. All of the above **Answer:** b ## Q54. You can check the conditions against ______when applying conditional formatting A. Cell value B. Formula C. Both of above D. None of the above **Answer:** c ## Q55. The number in our worksheet look like this: 1000. You want them to look like this: $1,000. How can you accomplish this? A. Select Format> Money from the menu B. Click the Currency Style button on the formatting toolbar (Home tab). C. You have to retype everything and manually add the dollar signs, commas, and decimals. D. None of above **Answer:** b ## Q56. Which of the following is an absolute cell reference? A. !A!1 B. $A$1 C. #A#1 D. A1 **Answer:** b ## Q57. Which of the following describes how to select all the cells in a single column? A. Right click on column and select Pick from list B. Use data-text to columns menu item C. Left click on the gray column title button D. Pressing Ctrl+A on the keyboard **Answer:** c ## Q58. Hyperlinks cannot be A. Special shapes like stars and banners B. Drawing objects like rectangle ovals C. Pictures D. All can be hyperlinks **Answer:** d ## Q59. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? A. Use Ctrl to select all three cells, then click the paste button on the standard toolbar B. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify C. Click format painter on the formatting toolbar twice then click in each cell you want to copy the formatting to… D. All of the above **Answer:** c ## Q60. Tab scroll buttons are placed on Excel screen A. Towards the bottom right corner B. Towards the bottom left corner C. Towards the top right corner D. Towards the top left corner **Answer:** b ## Q61. Documentation should include A. Destination and users of the output data B. Source of input data C. Information on the purpose of the workbook D. All of the above **Answer:** d ## Q62. The default header for a worksheet is A. Your name B. The date and time C. The sheet tab name D. None **Answer:** d ## Q63. Which function will you use to enter current time in a worksheet cell? A. =today() B. =now() C. =time() D. =currentTime() **Answer:** b ## Q64. You can group noncontiguous worksheets with A. The group button on the standard toolbar B. The shift key and the mouse C. The ctrl key and mouse D. The alt + enter key **Answer:** c ## Q65. Weight refers to A. The print density of characters B. The height of the printer character C. Upright or slanted shade D. The design and appearance of characters **Answer:** a ## Q66. You need the insert function dialog box. A. Right click a cell and then click insert B. Click on functions in Home tab C. Type = in cell D. All of above **Answer:** b ## Q67. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20? A. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows B. Select the range you want, include both cells, point to fill on the Edit menu, and then click down. C. Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special. D. All of above **Answer:** a ## Q68. A function inside another function is called a ….. Function. A. Nested B. Round C. Sum D. Text **Answer:** a ## Q69. Which function calculates your monthly mortage payment? A. PMT(Payment) B. NPER(Number of Periods) C. PV(Present Value) D. All of above **Answer:** a ## Q70. What is an expression that tells how the numbers in determined set of cells are to be calculated? A. Formula B. Field C. Data D. Query **Answer:** a ## Q71. If you are working in English(US), Chinese or Japanese, Excel 2016 can speak data as you enter it, to help you verify accuracy. How do you activate this feature? A. Add speak cells on enter command from quick access toolbar B. Click validation on the data menu C. Point to speech on the tools menu, and then click speech recognition D. All of above **Answer:** a ## Q72. To copy cell contents using drag and drop, press the A. End Key B. Shift Key C. Esc Key D. Ctrl Key **Answer:** d ## Q73. If you press …, the cell accepts your typing as its contents. A. Enter B. Ctrl + Enter C. TAB D. Insert **Answer:** a ## Q74. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? A. F3 B. F5 C. F7 D. F11 **Answer:** d ## Q75. You can use the formula palette to A. Format cells containing numbers B. Create and edit formulas containing functions C. Entered assumptions data D. Copy a range of cells **Answer:** b ## Q76. “Qtr 1, Qtr 2, Qtr 3” is an example of a A. Formula B. Function C. Series D. Syntax **Answer:** c ## Q77. You can edit existing Excel data by pressing the A. F1 Key B. F2 Key C. F3 Key D. F4 Key **Answer:** b ## Q78. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is …. A. G1-G10 B. B1.G10 C. B1;G10 D. B1:G10 **Answer:** d ## Q79. A user wishes to remove a spreadsheet from a workbook.Which is the correct sequence of events that will do this? A. Go to File-Save As – Save As Type – Excel worksheet B. Right click on the spreadsheet tab and select DELETE C. Right click on the spreadsheet and select Insert – Entire Column D. None of above **Answer:** b ## Q80. Which feature describes a background that appears as a grainy, non smooth surface A. Gradient B. Pattern C. Solid D. Texture **Answer:** a --- Source: https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-1 Site: https://www.easy2crack.com · Machine index: https://www.easy2crack.com/llms.txt · MCP: https://www.easy2crack.com/mcp