Excel Questions

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

2. A features that displays only the data in column (s) according to specified criteria

3. 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.

4. Which function will you use to enter current date and time in a worksheet cell?

5. What is the correct value of the function? =ROUND (1.9867,2)

6. Which function returns the current date?

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

8. _____ are equations that perform calculations on values in your worksheet.

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

10. You can select the current row in MS-Excel Worksheet by pressing?

11. Which function is used to get days, months, or years between two dates?

12. How can you remove borders applied in cells?

13. Which option is used to quickly convert a range of cells to a table with its own style converted in MS Excel?

14.  Under which tab and in which function group will you find the option to insert a Pivot Table?

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