Business Analyst Excel Quiz
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.
- 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