 |
| Computer Science 1st Year Chapter 9 Spread Sheet Questions Bank |
Computer Science 1st Year Chapter 9 Spread Sheet Questions Bank
MCQs
Please select the right answer.
1. ____ cell addresses is correct
2. ____ is not a feature of spreadsheet program
3. ____ is not a table of Page Setup dialog box of Excel
4. ____ menus contains the ‘Cells’ command
5. ____ menus contains the ‘Function command used to active to function wizard
7. ____ symbols is used before the formula
9. ____is a spreadsheet
10. ____menus contains the ‘Name’ command
11. ____ function is used to return current system date
12. ____is an absolute address
13. ____symbols is used in absolute referencing
14. A block of cells is called:
15. A cell at third column and 15 rows has a cell address
16. A cell of worksheet, which is not active is called
17. A collection of related worksheets is called
18. A formula in Excel always begins with:
19. A mathematical expression that is used to perform calculation on worksheet is called
20. A spreadsheet cell highlighted with a heavy border is the:
21. A workbook is a group of
22. Another name for an electronic spreadsheet is:
23. B2:E3 is an example of a cell:
24. Calling a cell with the reference of its address is called
25. Each cell in a spreadsheet has a unique:
26. Each number format consists of –
27. Each number format in Excel consist of:
28. For a currency format cell, the number 461.593 will be displayed as
29. Formula can only be applied on
30. Graphic representation' of data is named:
31. How many worksheets are contained in a workbook by default?
32. If the custom format is # ##.000 then the number 16.3 will be displayed as
33. If the custom format is ##,### then the number 23349 will be displayed as
34. If the custom format is 00000 then the number 420 will be displayed as
35. In a spreadsheet, columns are labeled by
36. In a spreadsheet, rows are labeled by
37. In a worksheet, a bold rectangle border indicates (n)
38. —menus contains the ‘Print command
39. Range of cells from C2 to C100 is referenced as
40. SUM, AVERAGE, MIN and MAX are examples of:
41. The 0.0000000001 is displayed in default column width as
42. The absolute reference of cell address A15 is written as;
43. The actual working area in Microsoft Excel is
44. The cell that contains a formula or function will show:
45. The command used to merge a number of selected cells into one cell is called:
46. The currently selected cell where data can be entered or edited is called
47. The default number format assigned to a cell is the
48. The extension of MS-Excel file is:
49. The first part of number format describes:
50. The fourth part of number format describes:
51. The function that is used to count the number of entries in the give range is called:
52. The function that is used to get the maximum value is called:
53. The function that is used to get the minimum value is called:
54. The horizontal dimension of a spreadsheet is called:
55. The intersection of a row and column form a
56. The main window in spreadsheet is called:
57. The second part of number format describes:
58. The third part of number format describes:
59. The vertical axis in charts is called:
60. The vertical dimension of a spreadsheet is called:
61. The Wrap text feature is available under what menu?
62. What is the basic unit of a worksheet in which data is entered?
63. Which Excel tool consists of the steps to create a chart?
64. Which is the faster way to change horizontal alignment in a document on?
65. Which of the following function is used to get the current date?
66. Which of the following is a correct cell address?
67. Which of the following is a spreadsheet
68. Which of the following is an absolute address?
69. Which of the following is modified to add a title to chart and change title's format?
70. Which of the following is not an element of a chart:
71. Which of the following is not an element of spreadsheet interface?
72. Which of the following is spreadsheet software?
73. Which tab of Format Cells dialog box is used to rotate the text?
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?