0%

Computer Operator

Electronic Spreadsheet – Set 4

Dear ! This is Electronic Spreadsheet – Set 4  Quiz and it contains 50 questions.



Happy Learning!

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

Share this Quiz with your friends! 

LinkedIn Facebook
0%

Exit

You cannot copy content of this page

Scroll to Top