1st Year Computer Science Chapter 9 Spread Sheet Notes MCQs

computer 11th notes Chapter 9

1. The default number format assigned to a cell is the

 
 
 
 

2. ____symbols is used in absolute referencing

 
 
 
 

3. If the custom format is # ##.000 then the number 16.3 will be displayed as

 
 
 
 

4. —menus contains the ‘Print command

 
 
 
 

5. In a spreadsheet, columns are labeled by

 
 
 
 

6. Each number format consists of –

 
 
 
 

7.        ____represents valid range in Excel

 
 
 
 

8. ____ menus contains the ‘Cells’ command

 
 
 
 

9. Which of the following is not an element of a chart:

 
 
 
 

10. The second part of number format describes:

 
 
 
 

11. ____ function is used to return current system date

 
 
 
 

12. Each cell in a spreadsheet has a unique:

 
 
 
 

13. If the custom format is 00000 then the number 420 will be displayed as

 
 
 
 

14. Calling a cell with the reference of its address is called

 
 
 
 

15. The vertical axis in charts is called:

 
 
 
 

16. For a currency format cell, the number 461.593 will be displayed as

 
 
 
 

17. If the custom format is ##,### then the number 23349 will be displayed as

 
 
 
 

18. ____ menus contains the ‘Function command used to active to function wizard

 
 
 
 

19. Which tab of Format Cells dialog box is used to rotate the text?

 
 
 
 

20. A cell at third column and 15 rows has a cell address

 
 
 
 

21. The Wrap text feature is available under what menu?

 
 
 
 

22. ____ is not a table of Page Setup dialog box of Excel

 
 
 
 

23. Which Excel tool consists of the steps to create a chart?

 
 
 
 

24. ____ represents a label

 
 
 
 

25. Which of the following is a correct cell address?

 
 
 
 

26. Which of the following is a spreadsheet

 
 
 
 

27. In a worksheet, a bold rectangle border indicates (n)

 
 
 
 

28. The currently selected cell where data can be entered or edited is called

 
 
 
 

29. ____is an absolute address

 
 
 
 

30. Which of the following function is used to get the current date?

 
 
 
 

31. Formula can only be applied on

 
 
 
 

32. The 0.0000000001 is displayed in default column width as

 
 
 
 

33. A cell of worksheet, which is not active is called

 
 
 
 

34. Another name for an electronic spreadsheet is:

 
 
 
 

35. B2:E3 is an example of a cell:

 
 
 
 

36. Which of the following is not an element of spreadsheet interface?

 
 
 
 

37. The first part of number format describes:

 
 
 
 

38. What is the basic unit of a worksheet in which data is entered?

 
 
 
 

39. A block of cells is called:

 
 
 
 

40.  ____menus contains the ‘Name’ command

 
 
 
 

41. A mathematical expression that is used to perform calculation on worksheet is called

 
 
 
 

42. The third part of number format describes:

 
 
 
 

43. In a spreadsheet, rows are labeled by

 
 
 
 

44. Which is the faster way to change horizontal alignment in a document on?

 
 
 
 

45. The absolute reference of cell address A15 is written as;

 
 
 
 

46. The horizontal dimension of a spreadsheet is called:

 
 
 
 

47. The command used to merge a number of selected cells into one cell is called:

 
 
 
 

48. The cell that contains a formula or function will show:

 
 
 
 

49. The extension of MS-Excel file is:

 
 
 
 

50.  ____is a spreadsheet

 
 
 
 

51. A spreadsheet cell highlighted with a heavy border is the:

 
 
 
 

52. A workbook is a group of

 
 
 
 

53. Range of cells from C2 to C100 is referenced as

 
 
 
 

54. The intersection of a row and column form a

 
 
 
 

55. Which of the following is an absolute address?

 
 
 
 

56. ____ symbols is used before the formula

 
 
 
 

57. Which of the following is spreadsheet software?

 
 
 
 

58. ____ is not a feature of spreadsheet program

 
 
 
 

59. Each number format in Excel consist of:

 
 
 
 

60. A formula in Excel always begins with:

 
 
 
 

61. Graphic representation’ of data is named:

 
 
 
 

62. Which of the following is modified to add a title to chart and change title’s format?

 
 
 
 

63. The main window in spreadsheet is called:

 
 
 
 

64. A collection of related worksheets is called

 
 
 
 

65. The function that is used to get the minimum value is called:

 
 
 
 

66. How many worksheets are contained in a workbook by default?

 
 
 
 

67. The function that is used to get the maximum value is called:

 
 
 
 

68. The fourth part of number format describes:

 
 
 
 

69. The actual working area in Microsoft Excel is

 
 
 
 

70. The function that is used to count the number of entries in the give range is called:

 
 
 
 

71. SUM, AVERAGE, MIN and MAX are examples of:

 
 
 
 

72. The vertical dimension of a spreadsheet is called:

 
 
 
 

73. ____ cell addresses is correct

 
 
 
 

Short Questions

1. Define Spreadsheet?
2. Describe Features of Spreadsheet.
3. Differentiate between worksheet and workbook.
4. Explain Function SUM with complete detail of parameters.
5. Explain Labels and Values in MS Excel.
6. Explain Merge Cell and Wrap Text.
7. Explain Page Header and Footer.
8. How Chart Wizard works ?
9. How do we enter a formula in MS Excel?
10. How will you format a cell ?
11. List some uses or applications of spreadsheet?
12. List the features of spreadsheet program?
13. List three benefits of spreadsheet?
14. What are Named Ranges ?
15. What is a cell and cell address?
16. What is a column header?
17. What is active cell?
18. What is Microsoft Excel?
19. What is row header?
20. What is the use of formula bar in Excel interface?
21. What is workbook?
22. What is worksheet?
23. Write a Formula to calculate average of 10 cells above in MS Excel.

Long Questions

1. Define spreadsheet and discuss its basic features.
“2. Differentiate the following:
• Workbook and Worksheet
• Active Cell and Passive Cell
• Word Processor and Spreadsheet
• Function and formula
• Labels and Values”
3. Every cell in a worksheet has a reference number, how is it calculated? Discuss with examples the major differences between Relative and Absolute referencing.
4. Create a Pie chart for the marks obtained by your class fellows in SSC examination.
5. What do you understand by the term named ranges? Can it be helpful in simplifying the worksheet?
6. What are the advantages of using a spreadsheet program?

Leave a Reply

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