Question Bank

FILL IN THE BLANKS

1. The commands to open, close and print a worksheet are available under the ----------- menu (File)
2. In excel, four types of documents can be created. These are: worksheets, charts, macro sheet and
------- - (Work book)
3. To delete a worksheet documents, select ----------- from the file menu. (Delete)
4. A worksheet can be protected with a ----------- ( Password)
5. To select a cell, ----- mouse on the desired cell ( Click)
6. To select an entire row, click mouse on the ------------- ( Row heading)
7. Formula bar includes an enter box and a -------------box (Cancel)
8. If Excel cannot completely display the result of a numeric expression, it automatically converts the result to the --------- format.(Scientific)
9. The address of the last cell in a worksheet is ----------------(IV16384)
10. A Worksheet contains --------------columns (256)
11. If the result of a formula cannot be displayed completely in a cell, it displays-------------- (######)
12. To stop a macro that is running, press ---------------key To create a button for a macro, the ------ toolbar is used.(Esc)
13. Besides creating a macro by recording, it is also possible to create it by ------------(Writing)
14. To run a macro that runs automatically when you open a worksheet, its name should start with ----.(Auto_ Open)
15. The ----------- function returns the net present value of an investment based on a series of cash flows and a discount rate NPV()
16. To display the current date, use the -------------- function (NOW( ) or TODAY( ) )
17. The ----------- function returns the periodic payment for an annuity (PMT( ))
18. The ------- function returns the day of the month from a date serial number ( DAY ( ) )
19. If there is a circular reference in a worksheet, it displays -------------- in the status line (Circular)
20. To Create a button for a macro, the ----- toolbar is used ( Customize)
21. Notepad is a ------------ (Text Editor)
22. The CPU must be at least ------------- to run WINDOWS in enhanced mode (
23. ------------- file contain the setting that control WINDOWS at an operating level
24. ----------------- files define the system resources for WINDOWS
25. The ----------- indicates the active document in WINDOWS
26. PIF stands for --------------(Program Information File)
27. -------------- ensures one application uses the services of another (OLE)
28. An application receiving data is called (Client Application)
29. The application that sources the data is called (Server Application)
30. A Clipboard file has----------------- file extension (CLP)
31. -------------menu item in file manager allows the user to determine how files are sorted. (View)
32. To select a single word in a document, -------the mouse on the word (Double Click)
33. Before you can apply a font on a particular text, you need to ------- that text.(Select)
34. Character size is measured in ---------------- (Point)
35. The 12 point text is ----------- than the 10 point text (Larger)
36. Times Roman is the name of a ------------- (Font)
37. When word automatically starts a new page, this page break is called the -----------page break (Soft)
38. When a user manually inserts a page break at a particular position in the document, this page break is called the ----------page break (Hard)
39. To insert a page break in a document, use the ------------option from the insert menu (Break)
40. --------------reduces the rugged appearance of unjustified text (Hyphenation)
41. The character that fills the space up to the next tab stop position is called the -------- character (Leader)
42. Main merge involves merging of the ----------- with a data source (Main Document)
43. A table can have -------------- number of rows (Any)
44. --------------cuts the selected text and graphics and puts it in clipboard.(Ctrl + X)
45. ---------------copies the selected text and graphics into clipboard (Ctrl + C)
46. ----------pastes the clipboard contents into a document (Ctrl + V)
47. To cancel the last editing, we can use the ----------- button (Undo)
48. The ------- mark stores all formatting for the text and graphics in the paragraph (Paragraph)
49. To copy the selected text with mouse, hold down the ------------key, point to the selected text and drag the insertion point to the new location (Ctrl)
50. To select a complete line, click in the -----------------bar to the left of the line.(Selection)
51. To zoom the document, use the zoom option from the ----------- menu (View)
52. All system settings in windows are stored in ----------- (Control Panel)
53. Windows settings are recorded in -------------
54. Windows is ----------------
55. Macro is in -------------- menu (Tools)
56. Sort option is in ---------------- menu (Table)
57. -------------- is the shortcut key for paste (Ctrl + V)
58. page break option is in -------------- menu (Insert)
59. ------------ is the extension of word document (.DOC)
60. Background option is in ----------- menu ( Format)

TRUE OR FALSE

1. If double click mouse on a Word, it select that WORD – True
2. Auto Text can be used to insert graphics in the document – True
3. WORD includes a number of Auto Correct Entries. We can use these entries that cannot modify them- False
4. Bold, Italics and Bold Italics are available for all fonts – True
5. A 24 Point character is about 1 Inch high – False
6. The current date cannot be inserted in the Header – False
7. The current date can be inserted in footer – True
8. Word prints header in the top margin – True
9. If the header is too large to fit in the top margin, WORD adjusts the top margin - True
10. The view menu is used to create header and footer – True
11. The same header is necessarily printed on all even pages of the document – False
12. Even and odd pages can have different footers – True
13. A new section can be forced to begin on the next odd page - True
14. All sections in a document necessarily use the same margin – False
15. Word can enclose a paragraph in a normal as well as shadow box – True
16. Hyphenation can affect page break - True
17. Top and Bottom margins may change after creating header and footer – True
18. Multiple column cannot be viewed in the page layout view – False
19. Page preview shows the page in WYSIWYG mode – True
20. In case of multiple column, a vertical line can be drawn between columns – True
21. To delete the selected sentence, we can press the Delete key – True
22. The document can be zoomed up to 200 % - True
23. Graphics is inserted in Frame – True
24. To cancel the last editing, we can use the delete key – False
25. Ctrl + C copies the selected text and graphics into Clip board – True
26. PIF stands for program Information File – True
27. An Application receiving data is called Client Application – True
28. A Work sheet can be protected with a password – True
29. Save option is in Edit menu – False
30. Notepad is a Text Editor – True
31. Time New Roman is the name of a Font – True
32. Character size is measured in point – True
33. to insert a page break in a document, use the break option from the insert menu – True
34. To zoom the document use the zoom option from the view menu – True
35. To zoom the document, use the zoom option from the format menu – False
36. A table can have any number of rows – True
37. Hyphenation can affect page breaks – True
38. A new section can be forced to begin on the next odd page
39. It is not possible to select two non adjacent ranges at a time – false
40. Macros stores in the global macro sheet can be used with any work sheet – True
41. To run a macro, select macro from run menu – False
42. Once a macro is running, it is not possible to stop it – False
43. Work Books are used in DTP – False
44. Sort option is in File menu – False
45. Macro is in format menu – False
46. Mail Merge option is in View menu – False
47. Auto Text can be used to insert graphics in the Excel Sheet – False
48. An object, such as paint brush and word document can be inserted in a work sheet – True
49. Both, Now ( ) and Today ( ) can be used to display the current time – False
50. To display current time, the Now ( ) function can be used – True
51. To display the current time, the Time ( ) function can be used – False
52. The Round ( ) function can be used to round off a number to hundreds – True
53. The RAND ( ) function returns a random number 0 and 10 – False
54. We can use file manager to run an application – True
55. Without a mouse one cannot work with Windows – False
56. Save option is in File menu – True
57. Header and Footer option is in View menu – True
58. Tab option is in format menu – True
59. Formula option is in Table menu – True
60. Auto fit option is in Table menu – True

SHORT QUESTIONS:

1. What are the difference between Paste Link and Paste Special?
2. Write about the various elements of Chart in Excel.
3. Explain the Features of Access.
4. Explain Data Validation
5. Explain Menu bar
6. Explain Formula bar
7. Explain Status bar
8. Explain the various addressing modes supported in Excel that can be used in the formulas
9. Explain how to create a Chart
10. How will you copy some data from a worksheet to another worksheet
11. What is a database in a Worksheet
12. What is a range in Excel
13. What is the significance of the header in the Worksheet
14. What is a PIF and how can a PIF be edited
15. Difference between a program icon and a group icon
16. What is a BITMAP
17. How do you copy a portion of a text file in to another file using WRITE
18. What is a Screen server and explain its utility
19. Explain the term “Style sheet”. What is its application in a Word document
20. What do you understand Font, Font Style and Font Size
21. List down the various types of tabs supported in WORD
22. Explain the terms “Style Sheet” What is its application in a WORD document
23. Briefly explain the use of formatting toolbar in WORD
24. What is meant by Footer in a Word Document? How do you create a footer for a document
25. What do you understand by sections in a document? What is the need to divide a document into sections
26. Explain the terms. How do you superscript and subscript text in WORD
27. What do you understand by the outline view? How does it help to organize a document?
28. Describe the Auto Correct feature in Brief
29. Describe the Auto Text Feature in brief
30. Explain the features of spell check facility in Word. How do you add new words to dictionaries?
31. What do you understand by Hyphenation? How do you use this facility in a Word document
32. How do you define page size and margins for a document?
33. What are templates and wizards?
34. What is a range? How are cell ranges named?
35. How will you copy some data from a worksheet to another worksheet?
36. Explain ,How to create a chart , using the chart wizard
37. Explain the various addressing modes supported in Excel that can be used in the formulas
38. Write about the various elements of Chart in Excel.
39. Explain the use of Thesaurus.
40. Difference between cut, copy and Paste.
41. Explain the uses of internet.
42. Explain the features of Access
43. Difference between Save and Save As.
44. Explain different formatting options in MS Word.
45. How will you create a table in MS Access?
46. How can you protect Word document with pass word.
47. Write any 2 Linux commands.
48. What is a Kernel?
49. What is embedding?
50. What is a process?
51. What is operating system? Explain
52. Advantages of using Linux over Windows.
53. Hoe to mark Index entries
54. How to set up tab stops
55. Difference between Insert Table and Draw Table
56. How to insert and delete a comment
57. Explain Scenario in Excel
58. Explain Goalseak in Excel
59. What is meant by advanced filtering
60. How to create master document
61. Explain the start button in the Desk top
ESSAY QUESTIONS:

1. What is Mail Merge? Define the steps needed to create a Mail Merge
2. Explain the Features of Word, Excel, PowerPoint
3. Explain the steps involved in inserting a Chart in Excel
4. What are the different types of views in PowerPoint and write down the features of PowerPoint
5. Explain the different types of Macros. How to create Macro
6. How can you animate a slide in PowerPoint
7. Explain the key features of MS Word
8. Explain the different views in MS Word
9. Explain the features of Linux
10. Compare Linux and Windows
11. Explain Pivot Table
12. Explain the steps for setting relationship between tables
13. Explain the concept of Database. Differentiate between DBMS and RDMS
14. Explain the different types of queries in Access
15. Explain the different data types used in Access for table creation
16. Explain the steps for creating a form in Access using from Wizard
17. Explain the steps for creating a report in Access using view
18. Explain the steps of creating a Chart and Describe its use
19. Explain the following commands
(a) Drop cap (b) Strikethrough (c) Cut (d) Copy
(e) Paragraph Spacing (f) Spell Check

21 Explain different types of Printers
22 Explain Sorting and Different Sorting Methods
23 Explain the Writer Window properties
24 What are the difference between Paste Link and Paste Special
25 Explain Table Properties in MS Word
26 Explain Page setup in MS Word
27 Explain Print dialogue box in MS Word
28 Explain Help option in MS Word
29 Explain How to insert cross reference in MS Excel
30 How to Insert Picture and Auto shapes in MS Word
31 How to set Relationship in Access