MS Excel |Set-1

MS-Excel

You can practice in this section  operating system MCQ which is important for exam point of view.

/53
4
Created on By GyanBazar

MS Excel Set-1

In this section we can find out the ms-excel related most important mcq collections.

1 / 53

1. In Excel default style for new data keyed in a new workbook is

2 / 53

2. This type of software is similar to an accountant's worksheet

3 / 53

3. What happens when dollar signs ($) are entered In a cell address?

4 / 53

4. To create a formula, you can use:

5 / 53

5. In Excel you can activate a cell by

6 / 53

6. The chart wizard term data series refers to

7 / 53

7. What are the basic rectangular building blocks of a spreadsheet?

8 / 53

8. How can you show or hide the gridlines in Excel Worksheet?

9 / 53

9. In Excel, the Fill Color button on the Formatting toolbar is used for what?

10 / 53

10. Which of the following formulas will Excel Not be able to calculate?

11 / 53

11. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

12 / 53

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

13 / 53

13. You can add a hyperlink to your worksheet by pressing

14 / 53

14. If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you can...

15 / 53

15. You can print

16 / 53

16. Which of the following is not an option in the spelling dialog box?

17 / 53

17. Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?

18 / 53

18. When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as

19 / 53

19. In Excel concatenation of text can be done using

20 / 53

20. The Cancel and Enter buttons appear In the:

21 / 53

21. What are the tabs that appear at the bottom of each workbook called?

22 / 53

22. You can use the horizontal and vertical scroll bars to

23 / 53

23. In Excel the following is not an example of a value

24 / 53

24. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has not  changed than...

25 / 53

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

26 / 53

26. To copy formatting from one area in a worksheet and apply it to another area you would use

27 / 53

27. Excel files have a default extension of

28 / 53

28. .......cells involves creating a single cell by combining two or more selected cells

29 / 53

29. What will be the output If you format the cell containing 5436.8 as '#,##0.00'?

30 / 53

30. The arrows created by Auditing can be removed by

31 / 53

31. Which command will you choose to convert a column of data into row?

32 / 53

32. In Excel typical worksheet has …. Number of columns

33 / 53

33. An excel workbook is a collection of

34 / 53

34. In Excel Hyperlinks can be

35 / 53

35. In Excel Graphics objects on a chart are used to

36 / 53

36. Which of the following is a popular DOS based spreadsheet package?

37 / 53

37. You can open the scenario Manager dialog box by choosing scenarios from the ... menu.

38 / 53

38. In Excel advantage of using a spreadsheet is

39 / 53

39. In Excel to open the Format Cells dialog box, press

40 / 53

40. The intersection of a row and column is called...

41 / 53

41. Which of the following methods can not be used to enter data in a cell

42 / 53

42. The box on the chart that contains the name of each Individual record Is called the__.

43 / 53

43. If you want all of the white cats grouped together In the database, you need to sort by__.

44 / 53

44. Which of the following is invalid regarding the Protection in Excel?

45 / 53

45. Which button do you click to add up a series of numbers?

46 / 53

46. In Excel you cannot link excel worksheet data to a word document

47 / 53

47. Which of the following is the oldest spreadsheet package?

48 / 53

48. Comments put in cells are called.....

49 / 53

49. To activate the previous cell in a pre-selected range press

50 / 53

50. Which of the cell pointer indicate that you can move the content to other cell?

51 / 53

51. What do you mean by a Workspace?

52 / 53

52. What does the VLOOKUP function do?

53 / 53

53. To delete an embedded objects, first

Your score is

The average score is 21%

0%

Leave a Reply

Your email address will not be published. Required fields are marked *