##### Follow Us :

> > > > > > Advanced EXCEL

##### What are the ways to create a dynamic range?
Creating a Table
Using OFFSET and COUNTA Functions
##### What is the order of operations that Excel uses while evaluating formulas?
PEMDAS Rule
Parenthesis
Exponentiation
Multiplication/Division
Subtraction
##### Difference between FUNCTION and FORMULA in excel?
FORMULA – is a statement which written by the user for calculations. Ex: =1+2+3
FUNCTION – is a built-in formula by Excel. Ex: =SUM(1+2+3)
##### What is the use of Slicer and Timeline in Excel?
Slicer – is used to filter the Table, Pivot Table data visually.
Timeline – is used to filter the dates interactively by Year, Month, Quarter, and Day.
##### What is COUNT and COUNTA?
COUNT – Counts the number of cells that contain only numbers except for blank cells.
COUNTA – Counts the number of cells which contains alpha-numeric except blank cells.
Q9)Is it possible to make a single Pivot Table for multiple data sources? Yes, it is possible. Using the Pivot Table Data Modeling technique.

##### Description
• Advanced EXCEL Interview Questions can be used to give quizzes by any candidate who is preparing for Data Scientist Interview.
• This Advanced EXCEL Questions section will help you test your analytical skills in a tricky method, thereby giving you an edge over other students
• All candidates who have to appear for the Bank IT officer Entrance exam can also refer to this short questions section.
• You can also get access to the Advanced EXCEL Interview ebook.
• Advanced EXCEL Questions can be used in the preparation of various Data Scientist  exams.