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.
IF
SUM
VLOOKUP
NUL
Makeups
Tools
Functions
Knobs
Formula
System
Mode
Formula builder
Logical Functions
Financial Functions
Lookup Functions
Index Functions
IQT
NPV
IRR
PMT
Mouse
Trackpad
Joystick
Keyboard
Sum selected cells
Shkw formulas or values
Start a formula
Highlight dependent cells
Logics
Function
Mode
Arguments
To get a list of data in key field in the left most coloumn
Averages the values in the specified range that match specified criteria
Sums the cells that match specified criteria
Counting the cells that match specified criteria
Yes
No
None
Unknown