Computer Operator
Electronic Spreadsheet – Set 4
Dear ! This is Electronic Spreadsheet – Set 4 Quiz and it contains 50 questions.
1 / 50
1. If you want to have a blank line after the title in a worksheet , what is the best thing for you to do ?
2 / 50
2. What happens when dollar signs($) are entered in a cell address ?
3 / 50
3. Which is an example of function ?
4 / 50
4. You can active a cell by?
5 / 50
5. Which of the following is not a valid data type in Excel?
6 / 50
6. You can add an image to a template by clicking the insert picture from file button on the………Toolbar?
7 / 50
7. Give me an example of a cell address .
8 / 50
8. Hyperlinks cannot be?
9 / 50
9. To drag a selected range of data to another worksheet in the same workbook, use the?
10 / 50
10. what are the tabs that appear at the bottom of each workbook called ?
11 / 50
11. In help menu of Excel , which of the following tabs are found ?
12 / 50
12. The first cell in EXCEL worksheet is labeled as
13 / 50
13. To insert three columns between columns D & E you would?
14 / 50
14. You can open the sort dialog box by choosing short from the…….menu?
15 / 50
15. In Excel , the Fill Color button on the formatting toolbar is used for what ?
16 / 50
16. The spelling tool is placed on_____toolbar?
17 / 50
17. When you print preview a worksheet?
18 / 50
18. If you require more than two conditions or if you want to analyze a list using Excel 2003’s database functions , you must define which filter ?
19 / 50
19. you want to report experiment information and create a chart that shows the rate of crystal growth over a period of time . the best application to use would be:
20 / 50
20. In order to arrange the countries from those with the highest population to those with the lowest , you need to sort on the population field in ………..
21 / 50
21. ……………are used in excel to present information contained in worksheet in a graphic format?
22 / 50
22. Which keyword shortcut opens the Go to dialog box ?
23 / 50
23. If you want all of the white cats grouped together in the database , you need to sort by —–
24 / 50
24. Comments can be added to cells using……..?
25 / 50
25. The box on the chart that contains the name of each individual record is called the ——–
26 / 50
26. A quick way to return to a specific area of a worksheet is to type in the —–
27 / 50
27. Which of the following is not a valid Zoom percentage in Excel?
28 / 50
28. NOT, AND, OR, and XOR are
29 / 50
29. Which is an example of a formula ?
30 / 50
30. Where a row and a column meet , what do you call that ?
31 / 50
31. what is represented by the small , black square in the lower right corner of an active cell or range ?
32 / 50
32. you are editing a worksheet that you had previously saved . if you want to save the edited sheet without losing the original one , which command should you use ?
33 / 50
33. The Cancel and Enter buttons appear in the :
34 / 50
34. What is the symbol for multiplying ?
35 / 50
35. Comments put in cells are called……?
36 / 50
36. Chart in Excel is available in……..Tab?
37 / 50
37. In Excel , a Data Series is defined as what ?
38 / 50
38. In order to perform a calculation in a spreadsheet , you need to use a :
39 / 50
39. Ms EXCEL can be used to automate
40 / 50
40. Which menu option can be used to split windows into two?
41 / 50
41. When you use the fill effects in the format data series dialog box, you can not?
42 / 50
42. When working in the page break preview, you can?
43 / 50
43. Which of the following is not a valid Zoom percentage in Excel?
44 / 50
44. you accidentally erased a record in the sheet . what command can be used to restore it immediately ?
45 / 50
45. B7:B9 indicates
46 / 50
46. What is the symbol for dividing ?
47 / 50
47. How do you tell one cell from another
48 / 50
48. …………is a quick and easy way to find and work with a subset of data in a excel sheet?
49 / 50
49. Which of the following methods cannot be used to enter data in a cell?
50 / 50
50. In a report , you need to show the monthly rainfall in Nepal . The best way to do this is to insert a
Your score is
Restart quiz Exit
You cannot copy content of this page