Excel 2007 Function/Formula Recap Quiz

15 Questions | Total Attempts: 349

SettingsSettingsSettings
Excel Quizzes & Trivia

This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.


Questions and Answers
  • 1. 
    Please describe the difference between changing the format of 1.3756901 to currency and using the ROUND formula to 2 decimal place.      a. What would the answer be if you added $2.57 to the formatted number?     b. What would the answer be if you added $2.57 to the rounded number?
  • 2. 
    Angela Swift Paul Velasco Shawna RaeWhat of the below functions or Formulas could be used to combine the above data into one cell for each row?
    • A. 

      Join

    • B. 

      Concatenate

    • C. 

      Text to Columns

    • D. 

      Find/Replace

  • 3. 
    Angela Swift Paul Velasco Shawna RaeYou need to break up the names above into two separate columns, what function and sub-function would you use?
    • A. 

      Right with Conditional Formatting

    • B. 

      Left with Delimiters

    • C. 

      Text to Columns with Fixed Width

    • D. 

      Text to Columns with Delimiters

  • 4. 
    In Excel what is the difference between =6+2/2 and =(6+2)/2?
    • A. 

      Nothing, they are the same and both give and answer of 7

    • B. 

      Nothing, they are the same and both give and answer of 4

    • C. 

      They are processed in different orders; the first would give an answer of 7 and the second would give 4

    • D. 

      They are processed in different orders; the first would give an answer of 4 and the second would give 7

  • 5. 
    ABCD1234 EFGH5678 IJKL9012Would I use Right or Left to keep the letters in each of the above?
    • A. 

      Right

    • B. 

      Left

  • 6. 
    What does pressing CTRL + SHIFT + RIGHT ARROW do?
    • A. 

      Selects all of the data to the right until a blank cell is encountered

    • B. 

      Selects the entire row

    • C. 

      Activates the task bar

    • D. 

      Opens Excel Options

  • 7. 
    Where is the status bar located on the screen in Excel?
    • A. 

      Above the document and below the ribbon

    • B. 

      In the Review Ribbon

    • C. 

      With Excel Options

    • D. 

      Above the Taskbar and below the document

  • 8. 
    True or false, the formula Exact is used to compare two cells and will provide back the result of "Yes" if the cells match?
    • A. 

      True

    • B. 

      False

  • 9. 
    What does the use of a "$" in a formula do?
    • A. 

      Gives your results back in currency format

    • B. 

      Gives your results back in accounting format

    • C. 

      Creates a fixed array for your formula

    • D. 

      Creates an array for when using multiple formulas for a single solution

  • 10. 
    Dana Tami Dana Dana Tami Tami Dana TamiI need to create a formula that would show me the number of times each of the names appears above, what function should I use?
    • A. 

      Countif

    • B. 

      Sum

    • C. 

      Total

    • D. 

      Count

  • 11. 
    Conditional Formatting formats cells when certain conditions are met, what is the problem that you could run into when using Conditional Formatting?
    • A. 

      It can show up differently to a customer based on their theme

    • B. 

      It can overwrite formulas

    • C. 

      It is so complicated to setup that it is easy to miss a step

    • D. 

      It overlays other formatting in the same cells

  • 12. 
    Which of the below is the correct process to create an IF formula?
    • A. 

      Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_false, enter a Value_if_true

    • B. 

      Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Logical_test, enter a Value_if_false

    • C. 

      Click the fx button, search for/open up the IF function, enter a Logical_test, enter a Value_if_true, enter a Value_if_false

    • D. 

      Click the fx button, search for/open up the IF function, enter a Value_if_true, enter a Value_if_false, enter a Logical_test

  • 13. 
    Where can you insert a comment?
    • A. 

      Only in the top row

    • B. 

      In any cell

    • C. 

      Only in headers

    • D. 

      In any cell that has a value in it

  • 14. 
    You can use vLookup to find data in different worksheets but not different workbooks.
    • A. 

      True

    • B. 

      False

  • 15. 
    Macros
    • A. 

      Automate repetitive tasks.

    • B. 

      Will auto-sum all the Number/Currency formatted cells in your workbook.

    • C. 

      Create a table of all the data you have selected.

    • D. 

      Can be used on any set of data no matter of the formatting.

Back to Top Back to top