1. | The number of rows in an Excel 2007 worksheet is: |
A. |
B. |
C. |
D. |
2. | Reference to the above image of Command Group "Alignment" which of the following tabs consist it: |
A. |
B. |
C. |
3. | You can have results of any database table into Excel Worksheet, and by one click you can refresh the results? |
A. |
B. |
4. | When using a databar, changing the value of one cell in the range will not affect the barsize of all the other cells. |
A. |
B. |
5. | The Insert Function dialog box tells you how to use functions. |
A. |
B. |
6. | When a worksheet is printed, the grid lines that surround the cells are printable by default. |
A. |
B. |
7. | When you clear a filter, all filters in the worksheet are cleared, if worksheet contains more than one filters |
A. |
B. |
8. | The function arguments dialog box tells you how to use functions. |
A. |
B. |
9. | The simplest and most convenient way to add a record to a table is to enter the data in the first blank row. |
A. |
B. |
10. | If you insert a new row at the top of the table, the new row becomes the header row and is formatted with the table style. |
A. |
B. |
11. | In Excel, charts do not remain linked or connected to the data sources if they appear in different worksheets. |
A. |
B. |
12. | After you merge a range into a single cell, you can't realign its content. |
A. |
B. |
13. | Once you hide a row, it remains hidden as long as the workbook is active. |
A. |
B. |
14. | All functions have arguments. There are no functions which work without providing them arguments. |
A. |
B. |
15. | Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see when slice is larger. |
A. |
B. |
16. | Excel has a builtin format to display 4 digit year values, so you do not need to create one. |
A. |
B. |
17. | Formatting data only change the appearance of data, it does not affect the data itself. |
A. |
B. |
18. | If a formula contains several functions, Excel starts with the outermost function and then moves inward. |
A. |
B. |
19. | An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons. |
A. |
B. |
20. | You can create maximum one Excel table in a worksheet |
A. |
B. |
21. | As you begin to type a function name within a formula into a cell, a list of functions that begin with the letters you typed appears. |
A. |
B. |
22. | You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis. |
A. |
B. |
23. | Pressing ENTER moves the selection one cell to the right by default. |
A. |
B. |
24. | Ctrl+B key makes the shortcut for making font in selected cell bold. |
A. |
B. |
25. | What key should be used to edit the content of a cell? |
A. |
B. |
C. |
26. | What function offers you the possibility to view different results depending on the entered condition? |
A. |
B. |
C. |
27. | A user wishes to remove a worksheet from a workbook. Which is the correct sequence of events that will do this? |
A. |
B. |
C. |
28. | Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell? |
A. |
B. |
C. |
29. | What is the keyboard shortcut for creating a chart from the selected cells? |
A. |
B. |
C. |
D. |
30. | Using the autosum button will place in the selected cell _____. |
A. |
B. |
C. |
D. |