Computer Proficiency Test For Employees

MS Excel

1. Each cell in a Microsoft office excel document is referred to by its cell address, which is the cells’s row and column
2. How are data organized data in spread sheet –Rows and Columns
3. In excel, workbook contains one or more worksheets
4. In excel merging allows users to bring together copies of workbook that other users have worked on independently.
5. What is the interaction of rows and columns of a work sheet is called  cell
6. Which of the following software applications would be the most appropriate for performing numerical and statistical calculations Spreadsheet
7. Excel is program that is used to prepare a spread sheet
8. What is the name of the package which helps to create, manipulate and analyze data arranged in row and columns spreadsheet package
9. The default view in excel is  Normal view
10. In a spreadsheet program the work book contains related worksheets and documents
11. Which of the following cell in active cell in excel  current cell
12. Which of the following identifies a cell in excel  label
13. Which of the following excel charts represents only one value for each variable  pie
14. When chart is placed on this , it is much larger and there is no other data on it  chart sheet
15. The operation of combining two cells into a single cell in excel is referred to as  Merge cells
16. What displays the contents of the active cell in excel Formula bar
17. In the formula =B1/B2+B3 which of the following is correct precedence division is higher precedence than addition
18. This dialog box specifies or modifies the work sheet cell range containing data to be charted chart source data
19. Another name for preprogrammed formula in excel is  function
20. In excel, when the contents and attributes of a cell or range of cells have to e erased using the menu, the user must  Select the cells, choose edit, and select clear, then all
21. Data organized in work sheet as  Rows and columns
22. In an excel; work sheet is to be linked for use in a PowerPoint presentation the following should be clicked  Edit , paste special