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. What is the symbol for multiplying ?

2 / 50

2. A quick way to return to a specific area of a worksheet is to type in the —–

3 / 50

3. How do you tell one cell from another

4 / 50

4. The Cancel and Enter buttons appear in the :

5 / 50

5. When working in the page break preview, you can?

6 / 50

6. you accidentally erased a record in the sheet . what command can be used to restore it immediately ?

7 / 50

7. When you print preview a worksheet?

8 / 50

8. If you want to have a blank line after the title in a worksheet , what is the best thing for you to do ?

9 / 50

9. …………is a quick and easy way to find and work with a subset of data in a excel sheet?

10 / 50

10. 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:

11 / 50

11. Which of the following is not a valid Zoom percentage in Excel?

12 / 50

12. To drag a selected range of data to another worksheet in the same workbook, use the?

13 / 50

13. In order to perform a calculation in a spreadsheet , you need to use a :

14 / 50

14. 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 ?

15 / 50

15. In help menu of Excel , which of the following tabs are found ?

16 / 50

16. 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 ………..

17 / 50

17. Ms EXCEL can be used to automate

18 / 50

18. In Excel , the Fill Color button on the formatting toolbar is used for what ?

19 / 50

19. In Excel , a Data Series is defined as what ?

20 / 50

20. When you use the fill effects in the format data series dialog box, you can not?

21 / 50

21. Which is an example of a formula ?

22 / 50

22. Which keyword shortcut opens the Go to dialog box ?

23 / 50

23. Comments put in cells are called……?

24 / 50

24. Which of the following is not a valid data type in Excel?

25 / 50

25. Which of the following methods cannot be used to enter data in a cell?

26 / 50

26. Comments can be added to cells using……..?

27 / 50

27. The spelling tool is placed on_____toolbar?

28 / 50

28. If you want all of the white cats grouped together in the database , you need to sort by —–

29 / 50

29. The box on the chart that contains the name of each individual record is called the ——–

30 / 50

30. Which menu option can be used to split windows into two?

31 / 50

31. Hyperlinks cannot be?

32 / 50

32. what is represented by the small , black square in the lower right corner of an active cell or range ?

33 / 50

33. NOT, AND, OR, and XOR are

34 / 50

34. Which of the following is not a valid Zoom percentage in Excel?

35 / 50

35. ……………are used in excel to present information contained in worksheet in a graphic format?

36 / 50

36. B7:B9 indicates

37 / 50

37. To insert three columns between columns D & E you would?

38 / 50

38. what are the tabs that appear at the bottom of each workbook called ?

39 / 50

39. 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 ?

40 / 50

40. You can open the sort dialog box by choosing short from the…….menu?

41 / 50

41. Chart in Excel is available in……..Tab?

42 / 50

42. Which is an example of function ?

43 / 50

43. Where a row and a column meet , what do you call that ?

44 / 50

44. What happens when dollar signs($) are entered in a cell address ?

45 / 50

45. You can add an image to a template by clicking the insert picture from file button on the………Toolbar?

46 / 50

46. In a report , you need to show the monthly rainfall in Nepal . The best way to do this is to insert a

47 / 50

47. The first cell in EXCEL worksheet is labeled as

48 / 50

48. What is the symbol for dividing ?

49 / 50

49. You can active a cell by?

50 / 50

50. Give me an example of a cell address .

Your score is

Share this Quiz with your friends! 

LinkedIn Facebook
0%

Exit

You cannot copy content of this page

Interactive Smart Learning Tools & Engines
Swipe & Launch