Excel Questions

1. When you insert an Excel file into a Word document, the data are

2.  Which function is used to create a date with year, month, and day?

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

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

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

6. Which of following functions MS-Excel have 1 SUM 2 CONCATENATE?

7. Which function is used to get a date n working days in the future or past?

8. Excel is a program that is used to prepare a

9. What dialog box allows you to change a field name in a PivotTable?

10. Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?

11.  In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the _______ menu

12. A worksheet range is a

13. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?

14.  What is the keyboard shortcut to switch between open Excel windows?

15. In ______ tab you will find AutoSum button.