LOK SEWA AYOG is a popular in Nepal and information collected by Niroj Khanal.

Set 5

1. Excel files have default extensions of XLS.

2. Lotus 1-2-3 is a popular DOS based spreadsheet package.

3. VisiCalc is the oldest spreadsheet package.

4. Files crated with Lotus 1-2-3 have extensions 123.

5. 65,535 characters can be typed in a single cell in Excel.

6. A Worksheet can have a maximum of 65,536 numbers of rows.

7. A typical worksheet as 256 numbers of columns.

8. Comments put in cells are called Cell Tip.

9. Comments can be added to cells using Insert > Comment.

10. Which menu option can be used to split windows into two Window > Split.

11. Getting data from a cell located in a different sheet is called Referencing.

12. Number, Date/Time and Label are valid data type in Excel.

13. Objects, Contents and Scenarios are of a worksheet can be protected from accidental modification.

14. A numeric value can be treated as a label value if it proceeds with Apostrophe (‘).

15. Concatenation of text can be done using Ampersand (&).

16. Data can be arranged in a worksheet in an easy to understand manner using Auto Formatting, Applying Styles and Changing Fonts.

17. Formula bar area in an Excel window allows entering values and formulas.

18. Multiple calculations can be made in a single formula using Array Formula.

19. An Excel Workbook is a collection of Worksheets and Charts.

20. You can convert existing excel worksheet data and charts to an HTML document by using the Internet assistant wizard.

21. When integrating word and excel, word is usually the designation and client.

22. Hyperlinks can be Text, Pictures or Drawing objects.

23. To delete an embedded object, first select it and then press the delete key.

24. When you want to insert a blank imbedded excel object in a word document you can Click the object command on the insert menu.

25. You can drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing the CTRL key.

26. When you ink data maintained in an Excel workbook to a word document The word-document contains a reference to the original source application.

27. To edit in an embedded excel worksheet object in a word document Edit the data in a excel source application.

28. When you insert an excel file into a word document. The data are Linked.

29. You cannot link excel worksheet data to a word document With the copy and paste buttons on the standard toolbar.

30. Pressing the ESC key methods cannot be used to enter data in a cell.

31. You can use the horizontal and vertical scroll bars to View different rows and columns edit the contents of a cell.

32. When the formula bar is activated, you can see The edit formula button, The cancel button and The enter button.

33. Status indicators are located on the Formula bar.

34. You can activate a cell by Pressing the TAB, Clicking the cell and Pressing an arrow key.

35. Each excel file is called a workbook because It can contain many sheets including worksheets and chart sheets.

36. Save the workbook, Enter text and data and Modify the worksheet are basic step in creating a worksheet. But not Copy the worksheet.

37. Tab scrolling buttons Allow you to view additional sheet tabs.

38. The name box Appears to the left of the formula bar.

39. Documentation should include destination and users of the output data, source of input data and information on the purpose of the workbook.

40. Efficiency, Auditibility and Description are worksheet design criterion. But not Description.

41. To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be centered.

42. You can use the formula palette to Create and edit formulas containing functions.

43. You can select a single range of cells by Dragging over the desired cells.

44. Rounding errors can occurs When you use multiplication, division or exponentiation in a formula.

45. The auto calculates feature Provides a quick way to view the results of an arithmetic operation on a range of cells.

46. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu.

47. To copy cell, cell contents using drag-and-drop press the Ctrl key.

48. You can use the format painter multiple times before you turn it off by Double-clicking the format painter button.

49. It is acceptable to let long text flow into adjacent cells on a worksheet when No data will be entered in the adjacent cells.

50. You can use drag-and-drop method to Copy cell contents and Move cell contents. But not to Add cell contents.

51. Single, Double, Single accounting and Double Accounting are all underline option in the format cells dialog box. But not a Single Engineering.

52. Weight refers to The print density of characters.

53. Ignore, Ignore all and Change option are in the spelling dialog box. But don’t have the Edit option.

54. You can create only a horizontal page break by first selecting A row below the row where you want the page break to occur and A cell in a column a.

55. When working in page break preview, you can View exactly where each page break occurs, Add or remove page breaks and Change the print area.

56. When you work with the large worksheets, you may need to Size the worksheet to fit on a specific number of pages, Add and remove page breaks and Specify only certain print area.

57. Printer selection setup option cannot be set in the page setup dialog box.

58. When you print preview a worksheet, the active portion of the worksheet is displayed.

59. When crating a vertical page break, the active cell must be in row.

60. Gridlines May be turned off for display but turned on for printing, May be turned on or off for printing and may b turned off for display and printing.

61. You can print A range of cells by range name, An entire workbook and A single workbook.

62. The chart wizard Can only b used to create embedded charts.

63. Graphic objects on a chart are used to, Add emphasis to chart data, Add interest to a chart and Help explain the chart data.

64. When you use the fill effects in the format data series dialog box, you can select pattern; background and foreground color. But not have Rotate text on the chart.

65. You can inset labels for All the data markers on a chart, A data series and A selected data marker.

66. Chart tips can Show the formatting of a data label, name of a data series or value of a data point.

67. A data map is helpful To show a geographic distribution of data.

68. You can print only an embedded chart by Moving the chart to a chart sheet before you print and Selecting the chart before you print.

69. Data markers on a chart are linked to data points in a worksheet, therefore you can change position or a data marker and automatically change the data point value in the worksheet.

70. To select an individual data marker or data label, you must double click the marker or label.

71. Using the F11 shortcut key to create a chart sheet creates A 2-dimensional column chart.

72. You can crate hyperlinks from an excel workbook to A web page on a company intranet, A web page on the internet and Other excel workbooks.

73. To drag a selected range of data to another worksheet in the same workbook, use the Alt key.

74. You can group noncontiguous worksheets with the ctrl key and the mouse.

75. When you group worksheets you can print more than one worksheet at a time and You can enter common data, formulas and formats on multiple worksheets at one time.

76. The drag-and-drop method of copying or moving data can be used between worksheets.

77. A 3-D reference in formula Span worksheets.

78. Pressing Spacebar is NOT a way to complete a cell entry.

79. = is used before a number to make it a label.

80. Serial Number 50671 is NOT an example of a value.

81. Fastest way to getting to cell A1 in a spreadsheet is Press Ctrl+Home.

82. The auto sum button do you click to ad up a series of numbers.

83. The Paste Special command lets you copy and paste The resulting values of a formula instead of the actual formula.

84. $A$1 is an absolute cell reference.

85. $A1 is a mixed cell reference.

86. SUM (SHEET1! B4, SHEET2! B5) is a 3d reference.

87. A1, B6 type are relative cell reference.

88. The numbers in you worksheet look like this: 1000. You want them to look like this: $1,000.00. So click the Currency Style button on the Formatting Toolbar.

89. To copy formatting from one area in a worksheet and apply it to another area you would use: The format Painter button on the Standard toolbar.

90. You want to track the progress of the stock market on a daily basis, line chart should you use.

91. Page Orientation, Margins and Headers & Footers are located in the Page Setup dialog box. But not located Page Break Preview in same place.

92. =SUM(A1:A5)/(10-10), =SUM(A1:A5)-10, =SUM(A1:A5)*.5 are able to calculate in MS Excel but not =SUM(sales)-A3.

93. Select Data> Delete Record from the menu can delete a record.

94. Solver, Goal seek and scenario manager are used to perform what if analysis, but not using Auto Outline option.

95. Input cells are NOT information you can specify using the Solver.

96. A worksheet range is a group of cells.

97. When you copy a formula Excel edits cell references in the newly copied formula.

98. To create a formula, you first select the cell you want to place the formula into.

99. Excel worksheet cells work very similarly to Text boxes common element of the Windows GUI.

100. Text formulas Concatenate and manipulate text.

101. Excel probably considers the cell entry January 1, 2000 to be a value.

102. The ChartWizard term data series refers to a collection of chart data markers.

103. To create a formula you can use values and cell references.

104. All worksheet formula returns a formula result.

105. You can enter Labels, values and formulas types of data into worksheet cells.

106. A circular reference is a formula that either directly or indirectly depends on itself.

107. When a label is too long to fit within a worksheet cell, you typically must Increase the column width.

108. The ChartWizard term data categories refer to a horizontal axis.

109. Excel uniquely identifies cells within a worksheet with Column letters and row numbers.

LOK SEWA AYOG is a popular in Nepal and information collected by Niroj Khanal.

Set 4

1. Microsoft companies developed MS office 2000.

2. File manager is not a part of standard Office Suite.

3. Word is the Word Processor in MS Office.

4. MS word Allows creation of DOC type of documents by default.

5. Paint Art is not a special program in MS Office.

6. Outlook Express is an E-mail client, Scheduler and Address book.

7. Office assistant is an animated character that gives help in MSOffice.

8. MS Office provides help in many ways, which of these are closer to the answer.

9. Joy stick input device cannot be used to work in MS Office.

10. Format menu in MSWord can be used to change font size & typeface.

11. Advanced is not a standard MSOffice Edition.

12. MS office 2000 included full-fledged Web designing software called FrontPage 2000.

13. Enter key should be pressed to start a new paragraph in MSWord.

14. Formatting toolbars allows changing of Fonts and their sizes.

15. Menu bar usually located below that Title Bar that provides categorized options.

16. 10, 500 are valid Min. & Max. Zoom size if MS Office.

17. MP3 type of file cannot be navigated using ClipArt browser. But AVI, BMP and WAV format can.

18. Word 2010 is the latest version of Microsoft Word.

19. Office 98 is not valid version of MS Office. Valid are Office 4.3, Office 97, Office 2000/3/5/7/10 and Office XP.

20. Close option File pull-down menu is used to close a file in MSWord, but not Quit or Exit.

21. To update a formula in a table, press the F9 keys.

22. You can create a table with the insert table button on the standard toolbar.

23. You can move the insertion point in a table. With the up/down arrow keys, with the Shift+Tab keys and with the Tab keys.

24. A table is a grid organized in columns and rows.

25. The five types of types of mail merge main documents are Letters, E-mail Messages, Envelops, Levels and Directory.

26. Format a main document is not of the merge process.

27. In the merge process, you can Preview a merge, Merge directly to the printer and Merge to a new document.

28. Data fields may be left empty.

29. Data records are not a data source component.

30. Date field is not part of the merge process.

31. If u change a document and then try to close the word application, the word will Display a message prompting you to save changes.

32. These types of special character | \ / ? < > “ * : can not be used in a file name. Remain Keyboard character can use.

33. After you create a document, you may need to Close it, Save it or Print it.

34. The select object browse button is located Below the vertical scroll bar.

35. Te preserve any changes to the document currently displayed on your screen, you should Save the document frequently.

36. The insertion point Indicated the location where text line when necessary.

37. The word wrap feature Automatically moves text to the next line when necessary.

38. To conserve computer resources, when you have completely finished with a document you should CLOSE It.

39. The following toolbar display in the word application window by default Formatting Bar.

40. Modifying a version, Deleting a version and Opening a version can be done with document version.

41. When you want to view different parts of a document without moving the insertion point use the vertical and horizontal scroll bar.

42. To view smaller text on the screen you can Decrease the view percentage.

43. The special characters word inserts into your document is called Non printing characters.

44. The selection bar is To the far left of the your documents.

45. You can add a date to documents by.

46. Inserting a date field that will update automatically.

47. The insert mode means New text is placed in the document at the insertion point.

48. To display hyperlink field in a document, you cannot press these CTRL+SHIFT+F9, SHIFT+F9 or CTRL+ALT keys.

49. Hyperlinks can be created between a word document and these (Another word document, A web page on the WWW and A web page on a company internet).

50. To cut or copy text you must first selected.

51. You can display the find and replace dialog box by using the Select browse object button (CTRL+G, F5 or CTRL+H).

52. When you left drag selected text, you cannot Delete text. But you can Link text, Copy text and Move text.

53. The drag and drop feature that allows you to Move and copy text using the mouse.

54. The clipboard is Used to temporarily store items that have been cut or copied.

55. You can search a word document for Formatting, Special Characters or Phrases.

56. The use smart cut and paste option adds or deletes space as needed when pasting text.

57. You can move and copy text Within a word document, Between office application and Between word document.

58. Auto text entries can be deleted can be edited or are saved with the normal template.

59. The spike allows you to combine text from several documents and then inserts all the text into one document at one time.

60. You can insert an auto text entry with the auto complete feature, F3 keys and auto text subcommand on the insert menu.

61. When you create an auto text entry you can save it with the current template, you should keep the name short you must assign it a unique name.

62. The auto complete feature Checks the spelling in the document.

63. The spelling and grammar tool Indicates grammatical errors, Corrects spelling errors as you type and Identifies words with capitalization problems.

64. The auto correct tool Checks for misspelled words as you type and underlines them.

65. Italic allows you to emphasize text by Slanting the text to the right.

66. Character spacing options are found in the Paragraph dialog box in format menu.

67. The Bold, Italic and Underline buttons on the formatting toolbar are turned on by default and toggle switches that apply or remove formats.

68. You can apply a double underline to the text with The underline list box in the font dialog box.

69. When you use the repeat command on the edit menu to repeat formats applied from the Formatting toolbar Only the last format is applied.

70. You can copy character formats by Using the format painter tool.

71. Typeface refers to The design and the appearance of the characters.

72. Left, right, center, Bar and decimal are tab stop position, but not Justify.

73. All are tab stop alignments Text that appears only in the print preview.

74. Alignment, Line spacing and Indenting are paragraph formatting, but not Tab stop.

75. You can indent selected text b Typing the indent position in the paragraph dialog box, Clicking the decrease indent button and Dragging an indent marker of the horizontal ruler.

76. You can display margins in the text to the horizontal or vertical ruler with the mouse and alt keys.

77. Format view is not an editing view.

78. Set the paper orientation is not an option in the print dialog box, except print selected page, text and collate copies.

79. You can decrease your document by one page by using the shrink to fit button.

80. You can display the next page in print preview by Reduce by one page button.

81. Documents can be printed to A file on the disk or A printer.

82. You can print Selected text in the document and The page that contains the insertion point. But not specified pages of the documents.

83. The default paper size and orientation is 8.5” x 11” portrait.

84. You can print a document from print preview, page lay out view or normal view.

85. The magnifier button Allows you to zoom you document.

86. In print preview, you can Format text, Print your document or Zoom each page.

87. To align numbers with the same number of decimal points in a table column Set a decimal tab stop and Right-align the numbers.

88. Word inserts a formula as A field code.

89. Click the Show/Hide button on the standard toolbar; you can display these hidden characters.

90. Green colors are grammar errors.

91. You are working on a novel and want to get to page 144. Select Edit > Got To from the menu is the best way of doing this.

92. Select Tools > Word count from the menu can you count how many words are in a document.

93. 12 Items can you copy to the new Office 2000 clipboard.

94. Select File > Print then type 3 in the Number of copies text box, can you print three copies of a document.

95. To view a list of suggestions for a misspelled word: Right click the misspelled word.

96. Save as: To save a file under a new name and/or location, To change how frequently Word saves auto recovery information about a file, To specify if word should always create a backup copy of a file.

97. Using format painter can you apply format of one text into other text.

98. You can use different page formatting within the same document by separating the differently page formatted areas with a Section break.

99. Landscape does a document have when it is laid out so that it is wider than it is tall.

100. Even page, Odd page, Next page and Continuous are type of section break, but not Next Column.

101. Click the sort ascending button on the Standard Toolbar can you sort items in a table in alphabetical order.

102. Click the Shading button on the Tables and Borders toolbar, can add shading to a table.

103. CTRL key do you hold down while dragging a drawing object in order to copy the object.

104. Block Arrows, Stars and Banners and Callouts are all examples of Auto shape categories.

105. Select Inset> Picture> File from the menu can you insert your picture into the document.

106. Normal.DOT is the name of the default template that Word uses to create blank documents.

107. In Microsoft Word, a style I a set of character and /or paragraph formatting settings that are stored under name and can be quickly applied in a single step.

108. A special type of document that can contain boilerplate text, macros and styles and is used to create new documents.

109. Select File> New from the menu do to create a FAX cover page.

110. Name the two different types of Styles; Paragraph style and Character style type.

111. Web page is not a type of document that you can create using mail merge.

112. Select Tools> mail Merge from the menu and click Edit Data Source do you add several more addresses to a data source.

113. Word saves the records for a data source file in a table.

114. When you perform a mail merge, you can directly send the results to a printer.

115. You can open the Mail Merge Helper dialog box by Selecting Tools> Mail Merge from the menu.

116. The data source file contains the information, or records, to be inserted in a mail merge.

117. To perform a mail merge you need to either create or open these two files; a main document and data source.

118. You can easily browse the comments in a document by selecting Insert> Comment.

119. Select Insert> Cross-reference from the menu is the procedure for inserting a cross-reference.

120. Select Insert> Footnote from the menu can you add a footnote to your document.

121. In Outline view a + plus symbol by heading indicates that how can you add a table of contents to the book.

122. Select View> Outline from the menu do you switch to Outline View.

123. Select Insert> Picture> Word art from the menu insert a word art object in a document.

124. Select Insert> Chart from the menu insert a chart in a document.

125. Select File> Save as from the menu and select the file format from the Save as type list do you save a document in a different file format.

126. It’s usually best if you create a Template to create and fill in blank forms.

127. Multiple choices are NOT a type of field you can add to a Word form.

128. Click the Insert Hyperlink button on the Standard Toolbar can you insert a hyperlink in a document.

129. To insert a clip art image you click Inset> Clip Art> Picture.

130. To insert an oval into a document you use the drawing toolbar’s ova button.

131. To cut a piece of selected text for pasting elsewhere in a Office Document, you click the toolbar’s cut button.

132. The Toolbar’s print button commands would you use to print an open document.

133. You wish to cut several items and paste them separately into several different Office document. To do this, you Click View | Toolbars | Clipboard and begin cutting and pasting using the Clipboard toolbar.

134. The answer wizard is a tool in Office’s Help program, which you use to find answers to specific questions.

135. When you use the copy function to copy an item in a document, it places that item on the clipboard for later pasting.

136. To create a template from a document, you open the document, click file | Save as, choose document template (*.dot)from the Save As Type drop down list and click save.

137. Web Layout view, print preview and outline view are way to view a word document, but not online preview.

138. To add a table to a Word document, you Click the toolbar’s insert table button and select the number of rows and columns from the grid.

139. To cause text to wrap around a text box, you select the text box, click Format | Text Box, click the layout tab, click the advanced button, click the Text Wrapping tab and click wrap around.

140. To write “To whom it may concern.” At the top of a word document automatically, you Click Insert | Auto Text | Salutation | To Whom It May Concern.

141. You have just formatted a paragraph and would like to create a style from it. To do this, you Click the paragraph, choose Format | Style | New and select options from the New Style Dialog Box.

142. You want word to arrange your text in Newspaper style columns. To do this, you Click the Toolbar’s columns button or click Format | Columns.

143. You want to make a caption stand out by putting it in a text box, To do this, you Click Insert | Text Box.

144. The best way to lay out a long, complicated document so that the pages look elegant is to Creates Styles you can use to apply to different types of text.

145. You wish to change appearance of the bullets in your bulleted list to look miniature hearts. To do this, select the bulleted list and right-click. Click Bullet and Numbering | Customize | Bullet. Choose the heart icon from the Symbol dialog box and click OK.

146. To include an Em dash in a document you Place the curser where the dash is to appear. Choose Insert | Symbol. Click the special Characters tab, click Em dash and click the Insert button.

147. The document map feature allows you to Navigate through a document and move to heading quickly.

148. To cause a page break occur in the middle of a page, you Pressing CTRL+ENTER.

149. 15 is the maximum number of characters in password.

150. The format painter command (button) available in the Picture.

151. The cropping button is available in the Picture.

152. The shrink to fit allows you to Adjust the text in page.

153. The command Drop Cap is available in Format.

154. The command caption is available in Insert.

155. Protect document is located in Tools Menu.

156. Standard Toolbar contain the Zoom, Format painter and Drawing Toolbar etc.

157. The command Index and Table is available in Insert menu.