Excel Exam 2018

25 Questions

Settings
Please wait...
Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    When pound signs (######) appear in a cell, it means you have an incorrect formula. 
    • A. 

      True

    • B. 

      False

  • 2. 
    An employee ID # would be entered as a label by preceding it with an apostrophe. 
    • A. 

      True

    • B. 

      False

  • 3. 
    The mathematical operator used in formulas to multiply values is a forward slash. 
    • A. 

      True

    • B. 

      False

  • 4. 
    Cell addresses are used to develop formulas--not the values themselves. 
    • A. 

      True

    • B. 

      False

  • 5. 
    To undo a currency format in a cell, you simply click the $ sign button on the ribbon. 
    • A. 

      True

    • B. 

      False

  • 6. 
    A defined area of the worksheet, such as (A1:A20), is called a series. 
    • A. 

      True

    • B. 

      False

  • 7. 
    An Invoice is an itemized bill. 
    • A. 

      True

    • B. 

      False

  • 8. 
    Each cell has a unique address made up of a row number and a column letter. 
    • A. 

      True

    • B. 

      False

  • 9. 
    Gross pay is the amount one receives after deductions have been taken away. 
    • A. 

      True

    • B. 

      False

  • 10. 
    A cell can contain the following: 
    • A. 

      Number

    • B. 

      Formula

    • C. 

      Text

    • D. 

      All of the above

  • 11. 
    A spreadsheet is a software program that allows one to: 
    • A. 

      Organize data

    • B. 

      Calculate answers

    • C. 

      Chart data

    • D. 

      All of the above

  • 12. 
    The formula =E6-(F6+G6) directs the spreadsheet to: 
    • A. 

      Add two numbers first, then subtract them from the first number

    • B. 

      Multiply two numbers first, then subtract the first number

    • C. 

      Subtract the first number and add the following two numbers

    • D. 

      Divide the first number by the sum of the second two numbers

  • 13. 
    All money amounts should be formatted to how many decimal places? 
    • A. 

      One

    • B. 

      Two

    • C. 

      Zero

    • D. 

      It depends

  • 14. 
    The __________________________________ preceding a formula is important because it alerts Excel that you are entering a formula and  not text. 
    • A. 

      Exclamation point

    • B. 

      Asterisk

    • C. 

      Equal sign

    • D. 

      Apostrophe

  • 15. 
    To compute "Net Pay" in the following example, the formula would be:
    • A. 

      =E6-F6-G6-H6

    • B. 

      =E6+F6+G6

    • C. 

      =E6-(F6+G6)

    • D. 

      None of the Above

  • 16. 
    The formula=MIN(A12:E12) will return the highest value in a range. 
    • A. 

      True

    • B. 

      False

  • 17. 
    Numbers are left-aligned in a cell. 
    • A. 

      True

    • B. 

      False

  • 18. 
    Which of the following would characterize or indicate the active cell on a worksheet? 
    • A. 

      Heavy border around it

    • B. 

      Appears in the name box

    • C. 

      It will appear in the name box and also have a heavy border around it.

  • 19. 
    An Amortization Table will tell you:
    • A. 

      Payment Amounts

    • B. 

      Term of the Loan

    • C. 

      Interest Rate

    • D. 

      All of the above

  • 20. 
    The y axis on a chart typically represents...
    • A. 

      The horizontal scale

    • B. 

      The axes titles

    • C. 

      The diagonal scale

    • D. 

      The vertical scale 

  • 21. 
    Under which part of the ribbon would you find the ability to print gridlines? 
    • A. 

      Insert

    • B. 

      Data

    • C. 

      Page Layout

    • D. 

      Home

  • 22. 
    The chart/graph that shows the relationship of each value to the whole would be:
    • A. 

      Bar Chart

    • B. 

      Column Chart

    • C. 

      Pie Chart

    • D. 

      Area Chart

  • 23. 
    The picture below is an example of:
    • A. 

      Filter

    • B. 

      Sort 

  • 24. 
    Microsoft Excel is the only application for which one can download templates.
    • A. 

      True

    • B. 

      False