10 Questions | Total Attempts: 114  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.

Related Topics
• 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.

• 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