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

Share this Quiz with your friends! 

LinkedIn Facebook
0%

Exit

You cannot copy content of this page

Scroll to Top