Business Analyst Excel Quiz

10 Questions | By Timmy198 | Last updated: Mar 12, 2018

Settings

- +

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

Back to top

More Excel Quizzes

Featured Quizzes