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