Business Analyst Excel Quiz

10 Questions

Settings
Please wait...
Business Analyst Excel Quiz

A business analyst uses excel software as his main tool of modeling to achieve a certain level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future. Do you know how business is analyzed in excel? . Here is a short quiz.


Questions and Answers
  • 1. 
    Which of these is not a predefined formula for analysis in excel?
    • A. 

      IF

    • B. 

      SUM

    • C. 

      VLOOKUP

    • D. 

      NUL

  • 2. 
    What are the predefined excel formulas such as index etc, referred to?
    • A. 

      Makeups

    • B. 

      Tools

    • C. 

      Functions

    • D. 

      Knobs

  • 3. 
    What is the function wizard called in Excel for Mac 2011?
    • A. 

      Formula

    • B. 

      System

    • C. 

      Mode

    • D. 

      Formula builder

  • 4. 
    Which of these is not a type of function used in Excel by a business analyst?
    • A. 

      Logical Functions

    • B. 

      Financial Functions

    • C. 

      Lookup Functions

    • D. 

      Index Functions

  • 5. 
    Which of these is not an example of financial functions?
    • A. 

      IQT

    • B. 

      NPV

    • C. 

      IRR

    • D. 

      PMT

  • 6. 
    Which does a business analyst find  more convenient to use when working on excel ?
    • A. 

      Mouse

    • B. 

      Trackpad

    • C. 

      Joystick

    • D. 

      Keyboard

  • 7. 
    What does a business analyst use equal sign (=) shortcut for in excel modelling?
    • A. 

      Sum selected cells

    • B. 

      Shkw formulas or values

    • C. 

      Start a formula

    • D. 

      Highlight dependent cells

  • 8. 
    The IF statement in excel takes three fields called?
    • A. 

      Logics

    • B. 

      Function

    • C. 

      Mode

    • D. 

      Arguments

  • 9. 
    What does  a business analyst use COUNTIF for in excel?
    • A. 

      To get a list of data in key field in the left most coloumn

    • B. 

      Averages the values in the specified range that match specified criteria

    • C. 

      Sums the cells that match specified criteria

    • D. 

      Counting the cells that match specified criteria

  • 10. 
    Can an analyst use AVERAGEIF in Excel 2007?  
    • A. 

      Yes

    • B. 

      No

    • C. 

      None

    • D. 

      Unknown