Microsoft Excel Examination

30 Questions | Total Attempts: 145

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

This is a 30-minute exam (approximately 1 minute per item) which assesses your knowledge in using Microsoft Excel. You may open an Excel Workbook to help you answer some of the questions on this exam. Goodluck!


Questions and Answers
  • 1. 
    Labels are aligned at the ________ edge of the cell.
    • A. 

      Left

    • B. 

      Right

    • C. 

      Top

    • D. 

      Bottom

    • E. 

      None of the above

  • 2. 
    Outlining data in an Excel spreadsheet will organize the sheet and make it easier to view. Provide the path on how to create an outline using Microsoft Excel. Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c
  • 3. 
    You can complete a cell entry by pressing
    • A. 

      Enter

    • B. 

      Tab

    • C. 

      Shift+tab

    • D. 

      An arrow key

    • E. 

      Another cell

    • F. 

      All of the above

    • G. 

      None of the above

  • 4. 
     It is possible to print multiple sheets or tabs in Microsoft Excel, all at the same time.
    • A. 

      True

    • B. 

      False

  • 5. 
    The default font keyed in a new work book is -
    • A. 

      12 pt. Times New Roman

    • B. 

      10 pt. Arial

    • C. 

      12 pt. Bradley Hand ITC

    • D. 

      10 pt. Times New Roman

    • E. 

      None of the above

  • 6. 
    We can create range names by simply defining names in Excel. Provide the path on how to define names using Microsoft Excel: Kindly separate your answers with either > or , (no extra spaces please). Example: a>b>c or a,b,c
  • 7. 
    If you choose a larger font size, the height of the row is automatically made taller.
    • A. 

      True

    • B. 

      False

  • 8. 
    For tips and warnings in “Defining Names”, we can use spaces or special characters in the names.
    • A. 

      True

    • B. 

      False

  • 9. 
    Which button allows you to copy cell formats from one cell to another?
    • A. 

      Enter

    • B. 

      Autofit

    • C. 

      Format Painter

    • D. 

      Esc

  • 10. 
    The Excel IF function checks to see if a certain condition is true or false. If the condition is true, the function will do one thing, if the condition is false, the function will do something else.
    • A. 

      True

    • B. 

      False

  • 11. 
    A_______ is a group of cells that form a retangle on the screen
    • A. 

      Label

    • B. 

      Workbook

    • C. 

      Worksheet

    • D. 

      Column

    • E. 

      Range

    • F. 

      None of the above

  • 12. 
    The following formula show “Fair”, “Good” or “Excellent” depending on the value of A1 but there is an error in the logic. What value produces an incorrect result?                                   =IF(A1<500,”Fair”,IF(AND(A1>500,A1<1500),”Good”,”Excellent”))
    • A. 

      A value of 0 will display “Good”

    • B. 

      A value of 500 will display “Excellent”

    • C. 

      A value of 1500 will display “Fair”

    • D. 

      A value of -500 will display “Excellent”

    • E. 

      None of the above

  • 13. 
    How do you know a range is active?
    • A. 

      It is highlighted on the screen.

    • B. 

      It has a marquee around it.

    • C. 

      The data changes to Bold to let me know it's active

    • D. 

      I'm psychic & I just Know!!

    • E. 

      All of the above except "I'm psychic & I just Know!!"

    • F. 

      None of the above

  • 14. 
    A range has an address called an range address.
    • A. 

      True

    • B. 

      False

  • 15. 
    An example of a  range address.
    • A. 

      A1;B3

    • B. 

      A1-B3

    • C. 

      A1:B3

    • D. 

      A1*B3

    • E. 

      A1&B3

  • 16. 
    When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________
    • A. 

      Cell selector

    • B. 

      Cell cross

    • C. 

      Selection Pointer

    • D. 

      Range Selector

    • E. 

      None of the above

  • 17. 
    A fast way to add up this column of numbers is to click in the cell below the numbers and then:
    • A. 

      Click Subtotals on the Data menu

    • B. 

      View the sum in the formula bar.

    • C. 

      Click the AutoSum button on the Standard toolbar, then press ENTER.

    • D. 

      All of the above

    • E. 

      None of the above

  • 18. 
    Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy...
    • A. 

      Click the Paste button on the Standard toolbar.

    • B. 

      Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

    • C. 

      Click the arrow on the Paste button on the Standard toolbar, then click Values.

    • D. 

      All of the above

    • E. 

      None of the above

  • 19. 
    How do you change column width to fit the contents?
    • A. 

      Single-click the boundary to the left of the column heading.

    • B. 

      Double-click the boundary to the right of the column heading.

    • C. 

      Press ALT and single-click anywhere in the column.

    • D. 

      All of the above

    • E. 

      None of the above

  • 20. 
    There are three worksheets with every new workbook. You can change that automatic number if you want to. 
    • A. 

      True

    • B. 

      False

  • 21. 
    ###### means: 
    • A. 

      You've entered a number wrong.

    • B. 

      You've misspelled something.

    • C. 

      The cell is not wide enough.

    • D. 

      All of the above

    • E. 

      None of the above

  • 22. 
    To add a new row, click a cell in the row immediately above where you want the new row.  
    • A. 

      True

    • B. 

      False

  • 23. 
    Which key do you press to group two or more nonadjacent worksheets? 
    • A. 

      CTRL

    • B. 

      SHIFT

    • C. 

      ALT

    • D. 

      ENTER

    • E. 

      None of the above

  • 24. 
    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs. ...
    • A. 

      True

    • B. 

      False

  • 25. 
    • A. 

      Count

    • B. 

      Average

    • C. 

      Sum

    • D. 

      None of the above

  • 26. 
    Is it possible to insert an image from a file into an Excel spreadsheet ?
    • A. 

      Yes

    • B. 

      No

  • 27. 
    A Formula and a function are the same thing.
    • A. 

      True

    • B. 

      False

  • 28. 
    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the average?
  • 29. 
    The formula = ((A2+B5)*5% is valid
    • A. 

      True

    • B. 

      False

  • 30. 
    #VALUE! means: 
    • A. 

      An empty cell

    • B. 

      Wrong formula

    • C. 

      Has one or more space characters

    • D. 

      None of the above