1. Getting data from a cell located in a different worksheet is called?

2. Which function is used to get the location of text in a string in MS Excel?

3. This is not a function category in Excel.

4. Advanced Functions are used in higher-level operations such as in conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections.

5. A worksheet range is a

6.  Which is not a Text function in MS Excel?

7. Which function returns the current date?

8. How can we provide a dynamic range in ‘data Source’ of pivot tables?

9. What command allows you to highlight the cell(s) in a data table that matches your set-up information?

10.  Which option displays the total number of cells, formulas, charts, tables, sheets, etc. in a Workbook?

11.  The ____ function is used to convert to text in a number format in MS Excel.

12. The currently selected cell address is displayed in ____.

13. The total number of rows in a worksheet?

14. Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array

15. An array is a systematic arrangement of similar objects, usually in rows and columns.