Take This Interesting Microsoft Excel Quiz

20 Questions | Total Attempts: 91

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Excel Test


Questions and Answers
  • 1. 
    Microsoft Excel is what type of program?
    • A. 

      A.Database

    • B. 

      B.Email

    • C. 

      C.Spreadsheet

    • D. 

      D.Word processor

  • 2. 
    A cell:
    • A. 

      A.is an intersection of a colunand a row

    • B. 

      B.has a unique cell address

    • C. 

      C.Neither A or B

    • D. 

      D.Both A and B

  • 3. 
    A document was saved to your disk and you want to open it for editing, Which menu do you select?
    • A. 

      A.Edit

    • B. 

      B.File

    • C. 

      C.Open

    • D. 

      D.View

  • 4. 
    All formulas in Excel begin with the following symbol:
    • A. 

      A.=

    • B. 

      B.+

    • C. 

      C.%

    • D. 

      D.#

  • 5. 
    • A. 

      A.=B2+C3

    • B. 

      B.=C3+B2

    • C. 

      C.=SUM(B2+C3)

    • D. 

      D.All of the above

  • 6. 
    The Auto Sum function is used to create a formula that includes a range of cells.
    • A. 

      True

    • B. 

      False

  • 7. 
    A dialog box will appear before you delete a workdheet even if the worksheet does not contain data.
    • A. 

      True

    • B. 

      False

  • 8. 
    A workbook defaults to three worksheets. Additional worksheets can be created
    • A. 

      True

    • B. 

      False

  • 9. 
    Grouping worksheets allows you to:
    • A. 

      A.apply identical formulas across all the worksheets in a group

    • B. 

      B.apply identical formulas across all the worksheets in a group

    • C. 

      C.make changes to all the worksheets in a group bychanging only one of the worksheets

    • D. 

      D.All of the above

  • 10. 
    You want to inset a column between column A and column B. Which of the following needs to be done?
    • A. 

      A.All the information in the worksheet needs to be retype

    • B. 

      B.Insert a column by selecting the Columns selection on the Edit menu

    • C. 

      C.Insert a cplumn by selecting the Columns selection on the Insert menu

    • D. 

      D.It cannot be done. A new worksheet needs to be created

  • 11. 
    The eadiest way to select an entire row is to ______.
    • A. 

      A.Choose the Select option in the Edit menu

    • B. 

      B.Click both the first entry and last entry in the row

    • C. 

      C.Click the row heading

    • D. 

      D.Double-click any cell in the row

  • 12. 
    If a cell shows #####, it means you mush insert a column
    • A. 

      True

    • B. 

      False

  • 13. 
    The merge and center button:
    • A. 

      A.is only available when worksheets are grouped

    • B. 

      B.is used to center vertically only

    • C. 

      C.allows you select one or more cells and merge them into a larger cell

    • D. 

      D.is a button on the Drawing Toolbar

  • 14. 
    Which of the following operations cannot be performed in the Alignment tab of the Format Cells dialog box?
    • A. 

      A.Change text orientation

    • B. 

      B,Color a cell background

    • C. 

      C.Merge cells

    • D. 

      D.Wrap text

  • 15. 
    The Source Data is:
    • A. 

      A.the range of cells that make up a chart

    • B. 

      B.the same thing as an axis

    • C. 

      C.Both A and B

    • D. 

      D. Neither A and B

  • 16. 
    The quickest way to create and edit your charts is to use:
    • A. 

      A.the Tools Menu

    • B. 

      B.the Chart Toolbar

    • C. 

      C,the View function

    • D. 

      D.the Format Dialog box

  • 17. 
    Which of the following is not a chart type in Excel?
    • A. 

      A.Bar Chart

    • B. 

      B.Pie Chart

    • C. 

      C.Pin Chart

    • D. 

      D.Line Chart

  • 18. 
    A chart created on the same worksheet as the soure data is called a chart sheet.
    • A. 

      True

    • B. 

      False

  • 19. 
    • A. 

      A.use the arrow keys on your keyboard

    • B. 

      B.use the mouse to drah the sizing handles until the chart is the desired size

    • C. 

      C.use the nouse to drah the blinking cursor through the choices smal(50%), medium (75%), and large (100%)

    • D. 

      D.delete the original chart and insert a new chart with the correct measurements

  • 20. 
    Which dialog box allows you to add headers and footers to a documents.
    • A. 

      A.Save As

    • B. 

      B.Page Setup

    • C. 

      C.View Options

    • D. 

      D.Filter Data