MS Office

1 Int(-67.1) returns




... Answer is C)


2 The Maximum file size in a word is:




... Answer is B)


3 The limited Number of open windows in a MS-Word is:




... Answer is D)


4 The maximum Number of Column in a table is:




... Answer is B)


5 In which menu option "Header & Footer" is Available?




... Answer is C)


6 The shortcut of Copy Format in word is:




... Answer is C)


7 To indent a Paragraph from left:




... Answer is C)


8 To Remove Paragraph formatting:




... Answer is A)


9 The default value of Tab Stop is:




... Answer is B)


10 To run Auto Format in MS-Word:




... Answer is A)


11 In which view margins and page breaks are not visible?




... Answer is B)


12 In MS-Word Ctrl+K is used:




... Answer is D)


13 Three most important formatting attributes are:




... Answer is B)


14 Which toolbar is always present when you open the MS-Word?




... Answer is C)


15 The maximum zooming percentage in a word document is:




... Answer is B)


16 The total No. of Rows in a Excel Sheet is:




... Answer is C)


17 The Max. No of Sheets in a Excel Workbook is :




... Answer is A)


18 What is number format if number is longer than width of cell?




... Answer is C)


19 To copy same data in a multiple cells:




... Answer is C)


20 The minimum zooming percentage in a word document is:




... Answer is C)


21 We can insert a table in a Word document :




... Answer is C)


22 To see the Print Preview in MS-Word we use:




... Answer is B)


23 Which of the following combinations is used for "Change Case" ?




... Answer is C)


24 Mail Merge is :




... Answer is D)


25 What are Macros ?




... Answer is A)


26 Macros are run by :




... Answer is D)


27 To insert a bookmark in a document we use:




... Answer is A)


28 To insert a new Work Sheet we use :




... Answer is C)


29 In Excel to repeat the last action we use:




... Answer is B)


30 To delete a entire Rows or Columns in excel:




... Answer is A)


31 To Copy a Sheet in a Excel:




... Answer is B)


32 The Cell Height of Excel Sheet is:




... Answer is D)


33 The cell address of 28th Column and 15 Row is:




... Answer is A)


34 To move one Cell up in Excel Sheet




... Answer is D)


35 Which one is Valid to sum from cell A1 to A5?




... Answer is C)


36 What is Formula Bar?




... Answer is D)


37 What does the error "#Value" shows?




... Answer is B)


38 What is the contents of the cell C2 if the formula "=$A$2" in B2 is copied to C2




... Answer is B)


39 What are the different types of Cell References?




... Answer is D)


40 To display the formula instead of value in a Cell, we use:




... Answer is B)


41 In excel, to create Header & Footer, which meenu is used:




... Answer is C)


42 What is ADO?




... Answer is B)


43 What is meaning of "&" in Access ?




... Answer is B)


44 The Extension of Access project is :




... Answer is C)


45 We can create a table by using :




... Answer is D)


46 What are the different types of relationships?




... Answer is D)


47 Before deleting a field that is related to a field in another table, you have to :




... Answer is B)


48 A database is a :




... Answer is A)


49 When you open a database run automatically




... Answer is D)


50 Queries are used to :




... Answer is D)


51 What is an effective way to present your data




... Answer is B)


52 You can provide fill effects by using option




... Answer is C)


53 We can change the design template of a presentation by using :




... Answer is A)


54 The change will be reflected in all slides when we change




... Answer is A)


55 In slide view slide appear as :




... Answer is B)


56 To apply Transition & Animation effects we use:




... Answer is A)


57 Shortcut to deactivate the Pen tool in Power Point




... Answer is D)


58 How do you convert your presentation in to compressed package ?




... Answer is B)


59 Which wizards is used to creat overhead transparecies ?




... Answer is B)


60 Pivot Table allows the user to :




... Answer is C)


61 In MS-Access Queries are implemented by using




... Answer is B)


62 You cannot create a relationship using fields that are not of




... Answer is C)


63 The fastest way to adjust the width of column is




... Answer is A)


64 To sort a table on two or more fields instead of one




... Answer is C)


65 Office binder makes it possible :




... Answer is B)


66 helps you to combine a series of actions to automate the work.




... Answer is C)


67 Which one is the existing layouts used for creating business and financial worksheets




... Answer is B)


68 Scenarios are used:




... Answer is A)


69 Is it possible to inser a MS-Word table in the Current Presentation in MS-Powerpoint




... Answer is A)


70 Ctrl+K is used to create Hyperlink in:




... Answer is A)


71 What are the basic types of Reports in Access ?




... Answer is C)


72 What database objects do reports get the information to display




... Answer is C)


73 What sections make up a report ?




... Answer is C)


74 What is the data type that you use when you want Access 97 to automatically update for you ?




... Answer is A)


75 How would you restrict data in a field to only dates ?




... Answer is D)


76 What does the >= operator mean ?




... Answer is C)


77 How do I get the total of all the values in a field (Quantity Sold, for example) ?




... Answer is D)


78 How do you add the current date or page number to a form ?




... Answer is A)


79 Format("Uppercase""<") returns




... Answer is C)


80 Right("Right or Left", 4) returns




... Answer is B)


81 Access provide a graphical tool known as for designing complex expressions for queries




... Answer is D)


82 Query prompts the users for the criteria on which data will be retrieved.




... Answer is C)


83 is used to display summarised values of both the rows and columns in the query.




... Answer is A)


84 To create a select query from the selected fields the following option is used




... Answer is C)


85 To select all the fields in table ,which one of the following button is used




... Answer is D)


86 The operator connects the field names with their respective table names



... Answer is A)


87 To delete all the fields from the query which one of the option is selected from Edit Menu.




... Answer is D)


88 The selection criteria can be joined by using




... Answer is C)


89 A Crosstab query requires at least Fields.




... Answer is C)


90 In a Crosstab query ,you cannot set the orders according to your requirements.




... Answer is B)


91 The forms which is resembled as a datasheet is




... Answer is B)


92 Which one of the form is used to depict 1:M Relationship.




... Answer is B)


93 The form which is resemble a manual data entry form.




... Answer is C)


94 Which one of the way is used to create a form




... Answer is D)


95 The memo field allows upto bytes of text for each field.




... Answer is A)


96 To create a form which one of the follwing control object is not used.




... Answer is C)


97




... Answer is A)


98 table.




... Answer is )


99 Which one of the control is based on expression




... Answer is C)


100 Calculated controls are also known as




... Answer is B)


101 Reports are used for




... Answer is D)


102 Which one of the report display data vertically.




... Answer is B)


103 Auto report generates




... Answer is A)


104 Which one is not used as a report element




... Answer is C)


105 Report footer is present




... Answer is A)


106 Access can incorporate graphs within a




... Answer is C)


107 The graphs can be created by using




... Answer is C)


108 Maximum actions in a macro is




... Answer is D)


109 Macros are used to perform tasks such as




... Answer is D)


110 Macro design window consist of




... Answer is C)


111 Which pane is known as Argument pane




... Answer is A)


112 Which one of this macro changes the cursor to the windows busy pointer




... Answer is C)


113 Which one operator is used with Null operator




... Answer is B)


114 The ouput of the 2*3^2-5




... Answer is B)


115 Len("Hundred") returns




... Answer is B)


116 sqr(625) will return




... Answer is C)


117 Lcase("LowerCasE") will return




... Answer is C)


118 Val("Haunted Street 10") will return




... Answer is C)


119 Format("0116195866","(@@@)@@@- @@@@")




... Answer is D)


120 Now() returns




... Answer is C)


121 format(#12/25/96#,"d-mmmm-yyyy") returns




... Answer is B)


122 # wilcard represent




... Answer is C)


123 Which keystroke is used to replace existing value with default




... Answer is A)


124 Which keystroke is used to insert line break in Text and memo fields




... Answer is B)


125 Which keystroke is used to replace with value of previous field.




... Answer is D)


126 In match drop-down list which option is default




... Answer is B)


127 to reduce the numeric field which property is required to be reduced




... Answer is C)


128 Which one of the field can not be resized




... Answer is C)


129 Which one of the following field name is invalid




... Answer is B)


130 Allow zero length property is valid only for following data type




... Answer is C)


131 the input mask can contain upto parts seprated by semiclon




... Answer is D)


132 The double field data type contain how many decimal places




... Answer is B)


133 Which one user defined format symbol is not used in text &memo data type




... Answer is D)


134 Short date format is represented as




... Answer is A)


135 The Storage Size of Auto number data type is




... Answer is B)


136 To display data from another table which one of the following data type is used




... Answer is C)


137 The storage size of OLE object is




... Answer is D)


138 Max. No. o0f table & objects in a database is allowed by Access




... Answer is C)


139 In Excel the intersection of a row and column is called




... Answer is C)


140 The total size of Excel worksheet is




... Answer is D)


141 A worksheet can be opened by clicking on the




... Answer is B)


142 The combination of the column letter and row number for a cell in an excel worksheet is called a




... Answer is C)


143 A collection of worksheets is called




... Answer is B)


144 In order to tell Excel that you are entering a formula in a cell, you must begin the entry with an operator such as




... Answer is A)


145 The TODAY() function enters the current




... Answer is C)


146 One of the following statements about Excel ranges is incorrect




... Answer is C)


147 References that change automatically when you copy them to a new cell are called




... Answer is B)


148 When Excel copies a formula from one cell to another, it identifies the number it needs by




... Answer is A)


149 To change the cell reference C4:C9 to an absolute row and column reference , you would enter it as




... Answer is C)


150 If you wish to copy the formating used in one section in your worksheet to another




... Answer is A)


151 Using Borders, you




... Answer is C)


152 Selecting Landscape changes your page from




... Answer is A)


153 Using ChartWizard, you can quickly and easily turn your




... Answer is A)


154 Pie chart can be plotted on




... Answer is C)


155 Excel uses another name for database. It is called




... Answer is A)


156 Excel can display upto fields of a data form.




... Answer is B)


157 The comparison operators to compute criteria's are




... Answer is A)


158 A function in Excel,




... Answer is D)


159 In the function =ROUND(G5/30,0)




... Answer is D)


160 A macro is made up of a series of instructions written in a language called




... Answer is A)


161 Excel worksheet data can be shared with Word document by




... Answer is D)


162 Macros are Automatically set to use




... Answer is B)


163 You can convert existing Excel worksheet data and charts to an HTML documents by using the




... Answer is B)


164 A area of memory or disk that is assigned to store any e-mail messages sent by other users




... Answer is D)


165 The process a user goes through to begin a computer system




... Answer is B)


166 To enlarge a window to its maximum size so that it fails the entire desktop




... Answer is A)


167 A program made by microsoft and included in Windows-98 that is used to Web Documents




... Answer is C)


168 An icon




... Answer is A)


169 A connection from the current document to another document to another document or to a document on the World Wide Web




... Answer is A)


170 A goup of letters, number and symbols with a common typeface




... Answer is B)


171 A Folder is




... Answer is C)


172 A Drop- Down List Box




... Answer is D)


173 A letter, memo, proposal or other file that is created using Microsoft Word is




... Answer is C)


174 The screen background and main area of windows where you can open and manage files and programes is called as




... Answer is B)


175 A setting or action predetermined by the program unless changed by the user is called as




... Answer is C)


176 The meaning of Cut is




... Answer is A)


177 A cursor is




... Answer is B)


178 A Command Button is a




... Answer is A)


179 Close Button




... Answer is D)


180 A Check Box




... Answer is D)


181 A button is




... Answer is D)


182 A Browser is a




... Answer is B)


183 A Bitmap is




... Answer is D)


184 The Term Active Window means




... Answer is C)


185 An Application is




... Answer is C)


186 Word offers certain ways by which you can move around in a document




... Answer is C)


187 Paragraph marks signify




... Answer is C)


188 The Save As dialog box can be used




... Answer is D)


189 The step involved to open the document are




... Answer is A)


190 While typing a paragraph you will




... Answer is B)


191 When Microsoft Word gets loaded, the Opening screen displays document named :




... Answer is A)


192 As you type in the text, some of the words may appear with a red wavy underline. It signifies




... Answer is A)


193 Purpose of Arrange all option in Window menu is




... Answer is B)


194 New Window command from the Window menu will




... Answer is C)


195 On a split box




... Answer is A)


196 When you split the window, one will have the title bar darker than the other ones. The ones with the darker title bar is




... Answer is B)


197 The Magnifier button is available on the




... Answer is A)


198 Soft page breaks




... Answer is B)


199 Selection of text can be of




... Answer is D)


200 The Formatting Toolbar is applied




... Answer is C)


201 In order to change the font and its size, you will




... Answer is A)


202 If you click on the Undo button




... Answer is A)


203 The contents of the Clipboard remain the same until




... Answer is D)


204 Using Microsoft Word's Find and Replace feature you can -




... Answer is A)


205 In order to help us entre frequently used text in an efficient and accurate manner; Microsoft Word offers us two special features. They are;




... Answer is A)


206 You will probably use Borders where




... Answer is D)


207 While using the Mail Merge Helper you click on the active window button. This selection creates




... Answer is A)


208 A data source is made up of




... Answer is C)


209 To make a field name in a data source one of the following is not permitted




... Answer is D)


210 When you create a wizard




... Answer is D)


211 After you create a document, you may need to




... Answer is D)


212 You can print a document




... Answer is D)


213 To preserve any changes gto the document currentlhy displayed on your screen, you should




... Answer is D)


214 The horizontal ruler provides features you can use to




... Answer is D)


215 Which of the following special characters can be used in a filename?




... Answer is B)


216 If you change a documentand then try to close the Word application, the Word will




... Answer is C)


217 Word inserts a formula as




... Answer is B)


218 To align numbers with the same number of decimal points in a table column




... Answer is D)


219 Which of the following formatting options is notavailable on the Tables and Borders toolbar?




... Answer is D)


220 In print preview you can




... Answer is D)


221 The Magnifier button




... Answer is A)


222 The Select Object Browse button is located




... Answer is B)

No comments

Eligibility Criteria and Topic for IT Professionals (HARTRON) on Job Work Basis

Eligibility Criteria and Topic for IT Professionals (HARTRON) on Job Work Basis Sr. No. Category Qualific...

Powered by Blogger.