Excel Basic 102

10 Questions | Total Attempts: 55

SettingsSettingsSettings
Please wait...
Excel Basic 102

This quiz is to enforce Excel fundamentals


Questions and Answers
  • 1. 
    What formula allows you to combine 2 or more strings together? 
    • A. 

      Merge

    • B. 

      Concatenate

    • C. 

      Exact

    • D. 

      Bind

  • 2. 
    A comma is used to separate parameters in a function?
    • A. 

      True

    • B. 

      False

  • 3. 
    What does the Fx symbol mean?
    • A. 

      Check Answer

    • B. 

      Format Wizard

    • C. 

      Cell format

    • D. 

      Function Wizard

  • 4. 
    Which formula creates the below sentence using A2 for the name and B2 for the dollar amount?
    • A. 

      =CONCATENATE("Dear ",A2,", you currently owe $",B2,".")

    • B. 

      =("Dear ",A2,", you currently owe $",B2,".")

    • C. 

      =CONCATENATE("Dear A2 you currently owe $B2.)

    • D. 

      =EXACT("Dear ",A2,", you currently owe $",B2,".")

  • 5. 
    What are all of the parts needed to average a range between A1 and A4?  Choose all that apply
    • A. 

      =

    • B. 

      ( )

    • C. 

      ,

    • D. 

      :

    • E. 

      Sum

    • F. 

      A1

    • G. 

      A2

    • H. 

      A3

    • I. 

      A4

    • J. 

      Average

  • 6. 
    When figuring out a formula, what are some good rules of thumb to go by?  Check all that apply
    • A. 

      Work from the middle

    • B. 

      Break into smaller pieces

    • C. 

      Write it or talk it out and find the primary reference point

    • D. 

      Keep it simple

  • 7. 
    It is True that if you are using 2 functions inside a formula, it is required to have 2 =.
    • A. 

      True

    • B. 

      False

  • 8. 
    When building a spreadsheet, which statements are true:  Choose all that apply
    • A. 

      If you want sales tax, you should hard code it into the formula

    • B. 

      If you want sales tax, you should have it based upon a cell outside of the formula

    • C. 

      It is OK to create multiple columns to break out the data

    • D. 

      A single formula should be able to handle everything you need to do

  • 9. 
    If you have a single cell for GP% and you want to paste a formula down a page without excel auto incrementing the formula, what special symbol do you need to use?  
    • A. 

      @

    • B. 

      #

    • C. 

      &

    • D. 

      $