Business Analyst Excel Quiz

10 Questions | By Timmy198 | Last updated: Mar 21, 2022 | Total Attempts: 259

Questions

Settings

Create your own 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

Related Topics

More Excel Quizzes

Microsoft Excel Quiz Questions And Answers

Questions: 22 | Attempts: 8155 | Last updated: Mar 22, 2022

Sample Question
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Count

Average

Sum

Could You Pass The Ms Excel Assessment Trivia Quiz?

Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...

Questions: 10 | Attempts: 4596 | Last updated: Mar 22, 2022

Sample Question
How do you spell check an Excel worksheet?

Under the Tools menu, click Spelling.

Press F7.

Click the button with ABC Check Mark icon.

Any of the above will perform a spell check.

Data Analyst Excel Test Questions And Answers

Are you a data analyst? Or are you practicing to become one? In both cases, you must try this 'Data Analyst Excel Test' quiz that is given below. A Data Analyst is skilled enough to translate numbers into comprehensible...

Questions: 10 | Attempts: 3866 | Last updated: May 25, 2022