In the name of ALLAH, the most beneficient, the most merciful

MCQs 1 (MicroSoft Excel)

Multiple Choice Questions

  1. 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
  2. To remove only the formats from a cell, you can use the Delete key.

    1. True
    2. False
  3. The formula bar is found at the bottom of the Excel window.

    1. True
    2. False
  4. The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.

    1. True
    2. False
  5. 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
  6. Use the fill handle to create a natural series, such as the months of the year.

    1. True
    2. False
  7. Which Excel feature helps you quickly enter existing data into adjacent cells?

    1. AutoComplete
    2. AutoData
    3. QuickComplete
    4. QuickData
  8. 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)
  9. 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
  10. You do not have the ability to modify the number of default worksheets in a workbook.

    1. True
    2. False
  11. Which of the following is an acceptable name for a named range?

    1. C7
    2. subtotal_west
    3. subtotal west
    4. subtotal/west
  12. Which of the following is a selected cell?

    1. current command
    2. default option
    3. active cell
    4. default cell
  13. 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
  14. 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
  15. You can access Backstage view by pressing Ctrl+B.

    1. True
    2. False
  16. 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)
  17. Ctrl + F displays Backstage view.

    1. True
    2. False
  18. 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
  19. You cannot have more than one worksheet in an Excel workbook.

    1. True
    2. False
  20. You can create a completely new ribbon tab as well as groups on that ribbon.

    1. True
    2. False
  21. Per the order of operations, which of the following is calculated first?

    1. Addition (+) and subtraction (−) (left to right)
    2. Exponentiation (ˆ)
    3. Percent (%)
    4. Negative number (−)
  22. When data is too wide for a cell, the part of the data that will not fit is automatically deleted.

    1. True
    2. False
  23. Which of the following is an example of a mixed cell reference?

    1. A9
    2. A$9
    3. $A$9
    4. A9:E9
  24. Which of the following is not an arithmetic operator?

    1. +
    2. -
    3. *
    4. ]
  25. The Open dialog box enables you to access the Microsoft website for custom templates.

    1. True
    2. False
  26. The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3).

    1. True
    2. False
  27. The order of operations determines which parts of a formula are calculated before other parts of the formula.

    1. True
    2. False
  28. Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

    1. AVERAGE
    2. AutoSum
    3. COUNT
    4. MAX
  29. Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.

    1. True
    2. False
  30. Which of the following do you use to open Backstage view?

    1. Backstage menu
    2. FILE tab
    3. INSERT tab
    4. WORKBOOK tab
  31. 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
  32. Click the FILE tab to get to Backstage view.

    1. True
    2. False
  33. Using the Delete key removes both text and formats from a cell.

    1. True
    2. False
  34. The columns in a worksheet are identified by numbers.

    1. True
    2. False
  35. Once you name a range, you can change the size of the range using the Name Manager.

    1. True
    2. False
  36. The COUNT and MIN functions are examples of which category of functions?

    1. text
    2. statistical
    3. financial
    4. logical
  37. All dates in Excel are actually stored in the serial date number system.

    1. True
    2. False
  38. 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
  39. 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
  40. Range names may begin with the (^) character.

    1. True
    2. False
  41. Which of the following is an example of an absolute cell reference?

    1. A9
    2. A$9
    3. $A$9
    4. A9:E9
  42. Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

    1. True
    2. False
  43. Which feature enables you to create custom tabs and groups?

    1. ribbon
    2. Quick Access Toolbar
    3. view
    4. Tab
  44. 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
  45. 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
  46. Use Ctrl + N to create a new workbook.

    1. True
    2. False
  47. By default, Excel starts a new workbook with four worksheets.

    1. True
    2. False
  48. When you click the Help button, what opens?

    1. ScreenTips
    2. Keytips
    3. Help window
    4. dialog box
  49. 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
  50. 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 nonnumeric content.
    3. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
    4. AutoSum does not have a default selection.
  51. Dates can be displayed in only one way in Excel.

    1. True
    2. False
  52. After a file has been opened, the filename appears in which of the following?

    1. title bar
    2. footer
    3. header
    4. Description pane
  53. When you split a window, the window is divided into how many panes?

    1. two
    2. three
    3. four
    4. two or four
  54. To access an Excel template, you can click the File tab and then click New.

    1. True
    2. False
  55. An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

    1. A dialog box or task pane
    2. An additional workbook
    3. A list of worksheets
    4. An additional part of the current range
  56. 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
  57. 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
  58. Use Ctrl + : to enter the current date in a worksheet cell.

    1. True
    2. False
  59. 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
  60. 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
  61. 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
  62. Which of the following is the intersection of a row and column?

    1. range
    2. tab
    3. bar chart
    4. cell
  63. In Excel, what is the result of =1 + 3 * 2 / 2 - 1?

    1. 2
    2. 3
    3. 4
    4. 6
  64. Which of the following can be customized for quicker access to your most commonly used commands?

    1. Print Preview
    2. Quick Access Toolbar
    3. Printer setup
    4. Workbook
  65. You can assign keywords so that others can search for your documents online.

    1. True
    2. False
  66. 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
  67. Ctrl + O opens a new blank workbook.

    1. True
    2. False
  68. How many worksheets does a new Excel 2016 workbook open with?

    1. one
    2. two
    3. three
    4. four
  69. Excel recognizes a construct like 3+4= as a legitimate formula.

    1. True
    2. False
  70. You cannot use a named range in a formula that references another worksheet.

    1. True
    2. False
  71. When you modify the ribbon, which of the following is created?

    1. command
    2. tab
    3. button
    4. worksheet
  72. 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
  73. 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)
  74. In Excel, you can add your most commonly used commands to the Quick Access Toolbar.

    1. True
    2. False
  75. The active cell in a worksheet is outlined by a bold rectangle.

    1. True
    2. False
  76. Page Layout view is useful when preparing your data for printing.

    1. True
    2. False
  77. 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
  78. To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

    1. True
    2. False
  79. 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
  80. Which of the following places a duplicate of a selection in the Office Clipboard?

    1. Paste
    2. Document properties
    3. Copy
    4. Range
  81. Range names cannot be the same as a cell reference, such as C10 or $D$8$.

    1. True
    2. False
  82. Which of the following do you click in the navigation pane to change Excel’s default settings by accessing Backstage view?

    1. Info
    2. Options
    3. Print
    4. Open
  83. Pressing the F1 key displays Backstage view.

    1. True
    2. False
  84. Which dialog box in Backstage view should you access to view and alter your workbook’s properties?

    1. Info
    2. Options
    3. Print
    4. Open
  85. Press Ctrl + Home to go to cell A1.

    1. True
    2. False