MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type)

Saturday, February 27, 2021

MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type)

in published on February 27, 2021 leave a reply

 MCQs (Microsoft Excel)

Multiple Choice Questions

MS Excel Questions Answers Excel MCQs Questions with Answers in PDF. This MCQs set of Computer Science on Microsoft Excel covers objective type questions important information about excel spreadsheet its history, shortcut keys and all its versions which  will be helpful  in preparation of public and civil service exams

Shortcut Keys of MS-Excel and their Descriptions
Shortcut Keys Description
F2 Edit the selected cell.
F5 Go to a specific e.g., C6
F7 Spell check selected text and/or document.
F11 Create a chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert a new worksheet.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up a search box.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialogue box to begin printing.
Ctrl + Z Undo the last action.
Ctrl + F9 Minimise current workbook.
Ctrl + F10 Maximise currently selected workbook.
Ctrl + F6 Switch between open workbooks/windows.
Ctrl + Page up Move between Excel worksheets in the same Excel document.
Ctrl + Page down Move between Excel worksheets in the same Excel document.
Ctrl + Tab Move between two or more open Excel files.
Alt + = Create a formula to sum all of the above cells.
Ctrl + ' Insert the value of the above cell into the cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in a percentage format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to the next section of the text.
Ctrl + Space Select the entire column.
Shift + Space Select the entire row.

  1. Which of the following is the intersection of a row and column?

    1. range
    2. tab
    3. bar chart
    4. cell

  2. Excel recognizes a construct like 3+4= as a legitimate formula.

    1. True
    2. False

  3. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.

    1. True
    2. False

  4. Use the fill handle to create a natural series, such as the months of the year.

    1. True
    2. False

  5. Which of the following statements accurately describes the default selection for AutoSum?

    1. You must make the selection before clicking AutoSum.
    2. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and non-numeric content.
    3. By default, AutoSum calculates the total from the adjacent cell through the first non-numeric cell.
    4. AutoSum does not have a default selection.

  6. Which of the following refers to an unnamed range in the current worksheet?

    1. =SUM(C2:E12)
    2. =Q3Expenses!A19
    3. =[Media.xlsx]MasterList!$D$10
    4. =SUM(budget.summary)

  7. You do not have the ability to modify the number of default worksheets in a workbook.

    1. True
    2. False

  8. Per the order of operations, which of the following is calculated first?

    1. Addition (+) and subtraction (−) (left to right)
    2. Exponentiation (ˆ)
    3. Per cent (%)
    4. Negative number (−)

  9. Which of the following is a group of adjacent cells that you select to perform operations on all of the selected cells?

    1. Paste
    2. Document properties
    3. Copy
    4. Range

  10. Which Excel feature helps you quickly enter existing data into adjacent cells?

    1. AutoComplete
    2. AutoData
    3. QuickComplete
    4. QuickData

  11. If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.

    1. True
    2. False

  12. Ctrl + O opens a new blank workbook.

    1. True
    2. False

  13. How many worksheets does a new Excel 2016 workbook open with?

    1. one
    2. two
    3. three
    4. four

  14. What will happen when you click the button highlighted above?

    1. the selected text will be bold, Calibri, 12 pt
    2. the selected text will be bold, Calibri, 10 pt
    3. the selected text will be non-bold, Calibri, 12 pt
    4. the selected text will be bold, Comic Sans, 10 pt

  15. The COUNT and MIN functions are examples of which category of functions?

    1. text
    2. statistical
    3. financial
    4. logical

  16. Which command is used to insert a cut or copied selection to a cell or range of cells?

    1. Paste
    2. Document properties
    3. Copy
    4. Range

  17. You cannot have more than one worksheet in an Excel workbook.

    1. True
    2. False



  18. You just selected cells B2:C2 and clicked "Merge and Center". What will happen?

    1. 1
    2. 2
    3. 3
    4. 4

  19. The columns in a worksheet are identified by numbers.

    1. True
    2. False

  20. You can access the Backstage view by pressing Ctrl+B.

    1. True
    2. False

  21. You right-click a column header and then click Delete. Suddenly a column of valuable financial information disappears without warning. What should you do?

    1. Search your hard drive for the last time you saved you. XLSX worksheet
    2. type Ctrl+Z to undo your deletion
    3. Press the Find button to search for the lost data
    4. calmly retype your financial information

  22. Which dialogue box in Backstage view should you access to view and alter your workbook’s properties?

    1. Info
    2. Options
    3. Print
    4. Open

  23. Dates can be displayed in only one way in Excel.

    1. True
    2. False


  24. In the example above, Excel's FillSeries feature extends the series when you drag the fill handle in the lower-right corner of the selection. But what is the quickest way to copy the original values?

    1. copy the original values and paste them into each of the new cells
    2. copy the original values and press the Sort button
    3. drag the fill handle while pressing Ctrl
    4. use the Format Painter

  25. Which of the following is a selected cell?

    1. current command
    2. default option
    3. active cell
    4. default cell

  26. The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.

    1. True
    2. False

  27. Pressing the F1 key displays a Backstage view.

    1. True
    2. False

  28. Which of the following shows a formula for a reference to another workbook?

    1. =SUM(C2:E12)
    2. =Q3Expenses!A19
    3. =[Media.xlsx]MasterList!$D$10
    4. =SUM(budget.summary)

  29. Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently?

    1. A worksheet
    2. The Help window
    3. The Quick Access Toolbar
    4. The ribbon

  30. You can create a completely new ribbon tab as well as groups on that ribbon.

    1. True
    2. False

  31. If you want to use a workbook in another kind of document, you have the option to save using which of the following?

    1. File format
    2. Worksheet
    3. File sheet
    4. File range

  32. All dates in Excel are actually stored in the serial date number system.

    1. True
    2. False

  33. The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).

    1. True
    2. False

  34. The Recommend Charts button does an excellent job of guessing the best chart for any set of data. But it does not replace a human understanding of your own numbers and intent. Imagine that you want to create a chart that illustrates the proportions of carbohydrates, protein, fats, and other components in each type of food you eat (one chart for each food). Which of the following chart types would make the most sense to visualize those propositions?

    1. scatter chart
    2. pie chart
    3. box and whisker chart
    4. line chart

  35. Which of the following consists of details that describe or identify a file, including the author?

    1. Paste
    2. Document properties
    3. Copy
    4. Range

  36. Range names cannot be the same as a cell reference, such as C10 or $D$8$.

    1. True
    2. False


  37. Your business does its most important work in April and you want to highlight the worksheet tab for that month. How can you make your worksheet tab look like the image above?

    1. double-click the April tab and select red from the ribbon
    2. right-click the April tab, click Tab Color, and then select red
    3. open the Microsoft Excel Worksheet Tab Color Wizard
    4. this is impossible and the image above has been manipulated


  38. If you format a number with the following Custom formatting: hh:mm: ss d-mmm-yyyy. How might the resulting date look?

    1. 01:11:31 9-Sep-20
    2. 01:11:31 9-September-2020
    3. 01:11:31 9-Sep-2020
    4. 01:11 9-Sep-2020

  39. Which feature enables you to create custom tabs and groups?

    1. ribbon
    2. Quick Access Toolbar
    3. view
    4. Tab

  40. To change printer, layout, or margin settings, you click the File tab and use which of the following options?

    1. Info
    2. Options
    3. Print
    4. Open

  41. To access an Excel template, you can click the File tab and then click New.

    1. True
    2. False

  42. You cannot use a named range in a formula that references another worksheet.

    1. True
    2. False

  43. Which of the following do you click in the navigation pane to change Excel’s default settings by accessing the Backstage view?

    1. Info
    2. Options
    3. Print
    4. Open


  44. How do you move a group of cells like this?

    1. point to the selection's border and drag the selected cells
    2. point to the selection's border, press Ctrl, and drag the selected cells
    3. point to the selection's border, press Alt, and drag the selected cells
    4. point to the selection's border, press Ctrl+Alt+Shift+F12+PgUp, and drag the selected cells

  45. Which predesigned file already has a significant amount of formatting, text, and other features?

    1. Blank workbook
    2. Preset file
    3. Text file
    4. Template

  46. Use Ctrl +: to enter the current date in a worksheet cell.

    1. True
    2. False

  47. Which feature enables you to preview headers and footers, page breaks, and other features that will print?

    1. Page Layout
    2. Print Layout
    3. Synchronous Scrolling
    4. ScreenTips

  48. Which of the following do you use to open Backstage view?

    1. Backstage menu
    2. FILE tab
    3. INSERT tab
    4. WORKBOOK tab

  49. You have a cell where your text is Dark Red 11.5 point Helvetica font. You also have a column of 22,000 email addresses that you want formatted in the same way. What is the fastest way to do this?

    1. Select the entire email column by clicking on the column header and applying the font attributes
    2. Click Format Painter, click the example cell, and then click the email column header
    3. Select the example cell, click Format Painter, and then click the email column header
    4. All of the given

  50. Which of the following is an acceptable name for a named range?

    1. C7
    2. subtotal_west
    3. subtotal west
    4. subtotal/west

  51. Which of the following is not an arithmetic operator?

    1. +
    2. -
    3. *
    4. ]

  52. You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

    1. SUM
    2. COUNTA
    3. MIN
    4. MAX

  53. The active cell in a worksheet is outlined by a bold rectangle.

    1. True
    2. False

  54. Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?

    1. Cell pointer
    2. Column marker
    3. Fill handle
    4. Formula bar

  55. Which command in the Backstage view navigation pane enables you to view and open your most recently used workbooks or workbooks stored on SkyDrive or your computer?

    1. Info
    2. Options
    3. Print
    4. Open

  56. Which of the following can be customized for quick access to your most commonly used commands?

    1. Print Preview
    2. Quick Access Toolbar
    3. Printer setup
    4. Workbook

  57. The Open dialogue box enables you to access the Microsoft website for custom templates.

    1. True
    2. False

  58. Which Excel feature automatically fills cells with data from another cell or range or completes a data series?

    1. Range Fill
    2. Auto Fill
    3. Data Fill
    4. Complete Fill

  59. Which of the following is a bar near the top of the Excel window where you can enter or edit cell entries or formulas?

    1. Cell pointer
    2. Column marker
    3. Fill handle
    4. Formula bar

  60. Ctrl + F displays Backstage view.

    1. True
    2. False

  61. Which of the following is an example of an absolute cell reference?

    1. A9
    2. A$9
    3. $A$9
    4. A9:E9

  62. When data is too wide for a cell, the part of the data that will not fit is automatically deleted.

    1. True
    2. False

  63. What is the name of the feature that saves copies of your files at specified intervals?

    1. Protect Sheet
    2. Track Changes
    3. AutoRecover
    4. Document Recovery


  64. You want to sort the table above by Revenue instead of Customer. So you select the values as shown and click the "Sort Smallest to Largest" button. What will happen?

    1. nothing will happen
    2. the table will sort as you wanted
    3. if you ignore Excel's warning, the Revenue values will sort but no longer align to the rest of the table
    4. if you ignore Excel's warning, the Customer and Season columns will be deleted

  65. By default, Excel starts a new workbook with four worksheets.

    1. True
    2. False

  66. Once you name a range, you can change the size of the range using the Name Manager.

    1. True
    2. False

  67. You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

    1. MIN
    2. AVERAGE
    3. COUNT
    4. MAX

  68. In Excel, you can add your most commonly used commands to the Quick Access Toolbar.

    1. True
    2. False

  69. To remove only the formats from a cell, you can use the Delete key.

    1. True
    2. False

  70. You have kept your personal budget in an Excel workbook for the last 15 years. You need to find that one purchase that you made from Contoso 6 years ago. Or was it 11 years ago? What is the quickest way to find that purchase?

    1. sort your worksheet by date and review the purchases from 6 to 11 years ago
    2. type the Name Manager button and look for "Contoso"
    3. type Ctrl+F to open Find and Replace, type "Contoso", and search
    4. type Ctrl+F to open Find and Replace, replace the word "Contoso" with bold red font to make it easy to find

  71. The formula bar is found at the bottom of the Excel window.

    1. True
    2. False

  72. Which of the following is an example of a mixed cell reference?

    1. A9
    2. A$9
    3. $A$9
    4. A9:E9

  73. Using the Delete key removes both text and formats from a cell.

    1. True
    2. False

  74. You have just created a detailed monthly budget worksheet called "January". It has labelled fields for all of your regular bills and formulas for each of your spending categories. You want to create 11 more worksheets for the rest of the year. What is the fastest way to do this?

    1. Click Insert, Worksheet and recreate the 11 monthly worksheets
    2. Click the "+" symbol 11 times, copy and paste the January content into the new worksheets, and rename the worksheets
    3. hold Ctrl and drag the January tab into 11 new worksheet copies, and rename the worksheets
    4. none of the given

  75. You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.

    1. True
    2. False

  76. Which of the following places a duplicate of a selection in the Office Clipboard?

    1. Paste
    2. Document properties
    3. Copy
    4. Range

  77. Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

    1. Backstage
    2. Print
    3. Edit
    4. Windows


  78. Your eyes are tired from reading through thousands of lines of sales percentages. The numbers are beginning to look like a blur. Is that 4% or 40%? As you grab yet another cup of strong coffee, you notice the sample above. That would be SO much easier to read. How can you make your numbers look like those numbers?

    1. select the cells you want to format and use the Format Painter
    2. select the cells you want to format and use Conditional Formatting, data bars
    3. select the cells you want to format and use Conditional Formatting, colour scales
    4. select the cells you want to format and use Conditional Formatting, icon sets

  79. Which of the following calculates the total from the adjacent cell through the first non-numeric cell by default, using the SUM function in its formula?

    1. AVERAGE
    2. AutoSum
    3. COUNT
    4. MAX

  80. When you split a window, the window is divided into how many panes?

    1. two
    2. three
    3. four
    4. two or four

  81. Pressing the Alt key activates Keytips that allow you to use the keyboard to choose ribbon tabs instead of clicking them with the mouse.

    1. True
    2. False

  82. To get to the last cell on the worksheet, which of the following should you press.

    1. Ctrl + Home
    2. Ctrl + End
    3. Ctrl + Right
    4. Ctrl + Left

  83. You can assign keywords so that others can search for your documents online.

    1. True
    2. False

  84. An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

    1. A dialogue box or task pane
    2. An additional workbook
    3. A list of worksheets
    4. An additional part of the current range

  85. Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

    1. True
    2. False

  86. Which of the following statement are true in Excel?

    1. A workbook is the same as a worksheet
    2. A workbook is a single file that contains multiple worksheets

  87. Use Ctrl + N to create a new workbook.

    1. True
    2. False

  88. Range names may begin with the (^) character.

    1. True
    2. False

  89. When you click the Help button, what opens?

    1. ScreenTips
    2. Keytips
    3. Help window
    4. dialogue box

  90. You are about to print a worksheet that contains over a thousand rows. The worksheet reports sales of about 30 different toys that you produce. You do not want more that one toy to appear on anyone sheet of paper. What is the best way to accomplish this?

    1. view the document in Print Preview and then add blank rows to move each toy to the next page
    2. copy the rows from each toy into a separate worksheet and print them separately
    3. Click Insert, and then click the Slicer button
    4. go to the first row of each toy and click Page Layout, Breaks, Insert Page Break


  91. You just hit the Print button. How many sheets will you find on the printer?

    1. 4
    2. 8
    3. 16
    4. 32

  92. The order of operations determines which parts of the formula are calculated before other parts of the formula.

    1. True
    2. False

  93. Which of the following can you not do using the Name Manager?

    1. Enter values into a range
    2. Change a range name
    3. Delete a named range
    4. Verify the scope of a range

  94. Which of the following statement are true in Excel?

    1. A worksheet is the same as a spreadsheet
    2. A workbook is the same as a worksheet

  95. You want to create some labels that span across three columns of cells. How can you do that?

    1. Select the three side-by-side cells and then Merge Cells
    2. Delete the two rightmost cells
    3. Insert a 1x3 table
    4. Remove the gridlines in those cells


  96. If you select cell B4 above, click Delete, and then type "Region" in the same cell, what will happen?

    1. the word "Region" will be in default black, unbolded text
    2. the word "Region" will be in red, unbolded text
    3. the word "Region" will be in default black, bolded text
    4. the word "Region" will be in red, bolded text

  97. In Excel, what is the result of = 1 + 3 * 2 / 2 - 1 ?

    1. 2
    2. 3
    3. 4
    4. 6

  98. Page Layout view is useful when preparing your data for printing.

    1. True
    2. False

  99. Which of the following can you drag or double-click to change the width of a column?

    1. Cell pointer
    2. Column marker
    3. Fill handle
    4. Formula bar

  100. Which of the following shows a formula for a reference to another worksheet in the same workbook?

    1. =SUM(C2:E12)
    2. =Q3Expenses!A19
    3. =[Media.xlsx]MasterList!$D$10
    4. =SUM(budget.summary)

  101. To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

    1. True
    2. False

  102. Press Ctrl + Home to go to cell A1.

    1. True
    2. False

  103. When you modify the ribbon, which of the following is created?

    1. command
    2. tab
    3. button
    4. worksheet

  104. Click the File tab to get to the Backstage view.

    1. True
    2. False


  105. What will happen when you click the button highlighted above?

    1. the selected text will be bold, Calibri, 11 pt, yellow font
    2. the selected text will be bold, Calibri, 12 pt, yellow font
    3. the selected text will be bold, Calibri, 11 pt, highlighted in yellow
    4. the selected text will be bold, Calibri, 12 pt, highlighted in yellow

  106. You would like your company logo to appear at the top of every worksheet that you print. What is the best way to do this?

    1. Click Insert, click Pictures, and add the logo in each worksheet
    2. Click Insert, click Online Pictures, and add the logo in each worksheet
    3. Click Insert, Header and Footer, and add the logo
    4. Click File, Print, and add the logo

  107. After a file has been opened, the filename appears in which of the following?

    1. title bar
    2. footer
    3. header
    4. Description pane
Previous Post
Next Post
Amar kumar

post written by:

0 Comments: