--- type: Quiz title: MS Excel MCQ Quiz for Government Exams - Part 3 canonical: "https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-3" subject: ms-excel questions: 52 free: true updated: null tags: ["mcq", "practice", "ms-excel"] --- # MS Excel MCQ Quiz for Government Exams - Part 3 52 multiple-choice questions with answers. ## Q1. The Spelling Tool is placed in ________ Tab. A. Insert B. Insert C. View D. Formula **Answer:** b ## Q2. Formatting a cell in Currency, you can specify A. Decimal Places B. Currency Symbol C. Both of above D. None of above **Answer:** c ## Q3. If you need a text to show vertically in a cell. How will you achieve this? A. Choose Vertical on Text alignment in Format Cells dialog box B. Choose 90 Degrees in Orientation of Format Cells dialog box C. Choose Distributed from the vertical drop down list of Format Cells dialog box D. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box **Answer:** b ## Q4. You can automatically adjust the size of text in a cell if they do not fit in width by A. Double clicking on the right border of column header B. From Format choose Columns and then Autofit Selection C. From Format Cells dialog box mark Shrink to fit check box D. All of above **Answer:** c ## Q5. Which of the cell pointer indicate that you can make selection A. Doctor’s Symbol (Big Plus) B. Small thin plus icon C. Mouse Pointer with anchor at the tip D. None of above **Answer:** a ## Q6. Which of the cell pointer indicate that you can fill series A. Doctor’s Symbol (Big Plus) B. Small thin plus icon C. Mouse Pointer with anchor at the tip D. None of above **Answer:** b ## Q7. Which one is the last column header in Excel 2019? A. XFD B. XFX C. XFL D. XFT **Answer:** a ## Q8. How can you remove borders applied in cells? A. Choose None on Border Tab of Format cells B. Open the list of Border tool in Home tab and choose no border C. Both of above D. None of above **Answer:** c ## Q9. You can set page border in excel from A. From Border tab in Format Cells dialog box B. From Border tool in Formatting toolbar C. From Line Style tool in Drawing toolbar D. You can not set page border in Excel **Answer:** d ## Q10. Which of the following you can paste selectively using Paste Special Command? A. Validation B. Formats C. Formulas D. All of above **Answer:** d ## Q11. Paste Special allows some operations while you paste to new cell. Which of the following operation is valid? A. Square B. Percentage C. Goal Seek D. Divide **Answer:** d ## Q12. Comments put in cells are called A. Smart Tip B. Cell Tip C. Web Tip D. Soft Tip **Answer:** b ## Q13. Which of the following is not true regarding Conditional formatting? A. You can add more than one condition to check B. You can set condition to look for bold and apply for italics on them C. You can apply Font, border and pattern formats that meets the specified conditions D. You can delete any condition from conditional formatting dialog box if it is not required **Answer:** b ## Q14. Getting data from a cell located in a different sheet is called A. Accessing B. Referencing C. Updating D. Functioning **Answer:** b ## Q15. What happens when you press Ctrl + X after selecting some cells in Excel? A. The cell content of selected cells disappear from cell and store in clipboard B. The cells selected are marked for cutting C. The selected cells are deleted and the cells are shifted left D. The selected cells are deleted and cells are shifted up **Answer:** b ## Q16. In EXCEL, you can sum a large range of data by simply selecting a tool button called…? A. AutoFill B. Auto correct C. Auto Sum D. Auto format **Answer:** c ## Q17. Which function is not available in the consolidate dialog box? A. PMT B. Average C. Max D. Sum **Answer:** a ## Q18. Which language is used to create macros in Excel? A. Visual Basic B. C C. Visual C++ D. Java **Answer:** a ## Q19. Which tool you will use to join some cells and place the content at the middle of joined cell? A. From Format Cells dialog box click on Merge Cells check box B. From Format Cells dialog box select the Centered alignment C. From Format Cells dialog box choose Merge and Center check box D. Click on Merge and Center tool on Home Tab **Answer:** d ## Q20. How can you set 0.5 inch indentation for a cell in Excel A. Excel does not have indentation feature. B. You can specify indentation only if you turn the rulers on C. Indentation can be set from Format Cells dialog box D. The indentation can be specified only when printing **Answer:** c ## Q21. Merge cells option can be applied from A. Format Cells dialog box alignment tab B. Formatting toolbar C. Both of above D. None of above **Answer:** a ## Q22. You can auto fit the width of column by A. Double clicking on the column name on column header B. Double click on the cell pointer in worksheet C. Double clicking on column right border on column header D. Double clicking on the column left border of column header **Answer:** c ## Q23. Selecting the column G & H then choose Insert by right clicking, What will happen? A. 2 Columns will be inserted after Column F B. 2 Columns will be inserted after Column G C. 2 Columns will be inserted after Column H D. 2 Columns will be inserted after Column I **Answer:** a ## Q24. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell. A. The Setting tab under the menu Data>>Cells B. The Setting tab under the menu Data>>Validation C. The Setting tab under the menu Data >>Filter>>Advanced Filter D. The Settings tab under the menu Home>>Conditional Formatting **Answer:** b ## Q25. If particular workbook have to open each time When Excel started, where that workbook should be placed? A. AUTOEXEC FOLDER B. AUTOSTART FOLDER C. EXCELSTART FOLDER D. XLSTART FOLDER **Answer:** d ## Q26. If the values in A1 is “MCQ” and B1 is “Questions”, Which function will return “MCQ@Questions” in cell C1? A. =A1 + “@” + B1 B. =A1 # “@” # B1 C. =A1 & “@” & B1 D. =A1 $ “@” $ B1 **Answer:** c ## Q27. What does COUNTA() function do? A. Counts cells having alphabets B. Counts empty cells C. Counts cells having number D. Counts non-empty cells **Answer:** d ## Q28. What is the correct way to refer the cell A10 on sheet3 from sheet 1? A. Sheet3!A10 B. Sheet1!A10 C. Sheet3.A10 D. A1 **Answer:** a ## Q29. What is entered by the function =today() A. The date value for the day according to system clock B. The time value according to system clock C. Today’s date as Text format D. All of above **Answer:** a ## Q30. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? A. F8 B. F9 C. F10 D. F11 **Answer:** b ## Q31. The shortcut key CTRL+R is used in Excel to A. Right align the content of cell B. Remove the cell contents of selected cells C. Fill the selection with active cells to the right D. None of above **Answer:** c ## Q32. While finding and replacing some data in Excel, which of the following statement is valid? A. You can Find and Replace within the sheet or workbook B. Excel does not have option to match case for find C. Both are valid D. None are valid **Answer:** a ## Q33. Which of the following is not true about Find and Replace in Excel A. You can search for bold and replace with italics B. You can decide whether to look for the whole word or not C. You can search in formula too D. You can search by rows or columns or sheets **Answer:** a ## Q34. Which is the shortcut key to replace a data with another in sheet? A. CTRL + R B. CTRL + Shift + R C. CTRL + H D. CTRL+ F **Answer:** c ## Q35. Which of the following is correct syntax in Excel? A. =if(LogicalTest, TrueResult, FalseResult) B. =if(LogicalTest, (TrueResult,FalseResult)) C. =if(LogicalTest, TrueResult) (LogicalTest, FalseResult) D. =if(LogicalTest, TrueResult), If(LogicalTest, FalseResult) **Answer:** a ## Q36. If 4/6 entered in a cell without applying any formats, Excel will treat this as? A. Fraction B. Number C. Text D. Date **Answer:** d ## Q37. To record a sequence of keystrokes and mouse actions to play back later we use: A. Media player B. Sound Recorder C. Calculator D. Macro Recorder **Answer:** d ## Q38. What are the tabs that appear at the bottom of each workbook called? A. Reference Tabs B. Position Tabs C. Location Tabs D. Sheet Tabs **Answer:** d ## Q39. A _____________ is grid with labeled columns and rows. A. Dialog box B. Worksheet C. Clipboard D. Toolbar **Answer:** b ## Q40. The active cell: A. is defined by a bold border around the cell B. Receives the data the user enters C. It is the formula bar D. Only A and B **Answer:** d ## Q41. B7:B9 indicates: A. Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cells B8 only. D. None of the above **Answer:** b ## Q42. Cancel and Enter button appear in the: A. Title bar B. Formula bar C. Menu bar D. Sheet tabs **Answer:** b ## Q43. Special category of Number tab in format cells dialog box can be used to apply formats like A. Zip Code B. Phone Number C. Both of above D. None of above **Answer:** c ## Q44. Formatting a cell in Number format you can’t set A. Decimal Places B. Use 1000 separator C. Negative Numbers D. Currency Symbol **Answer:** d ## Q45. Which would you choose to create a bar diagram? A. Home, Bar Chart B. Insert, Bar Chart C. Page Layout, Bar Chart D. Data, Bar Chart **Answer:** b ## Q46. What do you call the chart that shows the proportions of how one or more data elements relate to another data element? A. XY Chart B. Line Chart C. Pie Chart D. Column Chart **Answer:** c ## Q47. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a A. Calendar B. Photograph of rainfall C. Chart showing rainfall amounts D. Database of rainfall **Answer:** c ## Q48. You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use? A. New B. Save As C. Edit D. Save **Answer:** b ## Q49. Which of the following function will use to find the highest number in a series of number? A. New B. MAXIMUM(B1:B3) C. High(B1:B3) D. HIGHEST(B1:B3) **Answer:** a ## Q50. Which of the following shortcuts can be used to insert a new line in the same cell? A. Enter B. Alt + Enter C. Ctrl + Enter D. Shift + Enter **Answer:** b ## Q51. What is the shortcut key to insert new comment in a cell? A. F2 B. ALT + F2 C. CTRL + F2 D. SHIFT + F2 **Answer:** d ## Q52. To show/hide the grid lines in Microsoft Excel A. Page Layout>Gridlines>View B. Insert>Gridlines>View C. Data>Grid Lines>View D. Review>Grid Lines>View **Answer:** a --- Source: https://www.easy2crack.com/mcqs/ms-excel/ms-excel-mcq-quiz-for-government-exams-part-3 Site: https://www.easy2crack.com · Machine index: https://www.easy2crack.com/llms.txt · MCP: https://www.easy2crack.com/mcp