MS Office
1 Int(-67.1) returns
2 The Maximum file size in a word is:
3 The limited Number of open windows in a MS-Word is:
4 The maximum Number of Column in a table is:
5 In which menu option "Header & Footer" is Available?
6 The shortcut of Copy Format in word is:
7 To indent a Paragraph from left:
8 To Remove Paragraph formatting:
9 The default value of Tab Stop is:
10 To run Auto Format in MS-Word:
11 In which view margins and page breaks are not visible?
12 In MS-Word Ctrl+K is used:
13 Three most important formatting attributes are:
14 Which toolbar is always present when you open the MS-Word?
15 The maximum zooming percentage in a word document is:
16 The total No. of Rows in a Excel Sheet is:
17 The Max. No of Sheets in a Excel Workbook is :
18 What is number format if number is longer than width of cell?
19 To copy same data in a multiple cells:
20 The minimum zooming percentage in a word document is:
21 We can insert a table in a Word document :
22 To see the Print Preview in MS-Word we use:
23 Which of the following combinations is used for "Change Case" ?
24 Mail Merge is :
25 What are Macros ?
26 Macros are run by :
27 To insert a bookmark in a document we use:
28 To insert a new Work Sheet we use :
29 In Excel to repeat the last action we use:
30 To delete a entire Rows or Columns in excel:
31 To Copy a Sheet in a Excel:
32 The Cell Height of Excel Sheet is:
33 The cell address of 28th Column and 15 Row is:
34 To move one Cell up in Excel Sheet
35 Which one is Valid to sum from cell A1 to A5?
36 What is Formula Bar?
37 What does the error "#Value" shows?
38 What is the contents of the cell C2 if the formula "=$A$2" in B2 is copied to C2
39 What are the different types of Cell References?
40 To display the formula instead of value in a Cell, we use:
41 In excel, to create Header & Footer, which meenu is used:
42 What is ADO?
43 What is meaning of "&" in Access ?
44 The Extension of Access project is :
45 We can create a table by using :
46 What are the different types of relationships?
47 Before deleting a field that is related to a field in another table, you have to :
48 A database is a :
49 When you open a database run automatically
50 Queries are used to :
51 What is an effective way to present your data
52 You can provide fill effects by using
option
53 We can change the design template of a presentation by using :
54 The change will be reflected in all slides when we change
55 In slide view slide appear as :
56 To apply Transition & Animation effects we use:
57 Shortcut to deactivate the Pen tool in Power Point
58 How do you convert your presentation in to compressed package ?
59 Which wizards is used to creat overhead transparecies ?
60 Pivot Table allows the user to :
61 In MS-Access Queries are implemented by using
62 You cannot create a relationship using fields that are not of
63 The fastest way to adjust the width of column is
64 To sort a table on two or more fields instead of one
65 Office binder makes it possible :
66 helps you to combine a series of actions to automate the work.
67 Which one is the existing layouts used for creating business and financial worksheets
68 Scenarios are used:
69 Is it possible to inser a MS-Word table in the Current Presentation in MS-Powerpoint
70 Ctrl+K is used to create Hyperlink in:
71 What are the basic types of Reports in Access ?
72 What database objects do reports get the information to display
73 What sections make up a report ?
74 What is the data type that you use when you want Access 97 to automatically update for you ?
75 How would you restrict data in a field to only dates ?
76 What does the >= operator mean ?
77 How do I get the total of all the values in a field (Quantity Sold, for example) ?
78 How do you add the current date or page number to a form ?
79 Format("Uppercase""<") returns
80 Right("Right or Left", 4) returns
81 Access provide a graphical tool known as
for designing complex expressions for queries
82 Query prompts the users for the criteria on which data will be retrieved.
83 is used to display summarised values of both the rows and columns in the query.
84 To create a select query from the selected fields the following option is used
85 To select all the fields in table ,which one of the following button is used
86 The operator connects the field names with their respective table names
87 To delete all the fields from the query which one of the option is selected from Edit Menu.
88 The selection criteria can be joined by using
89 A Crosstab query requires at least Fields.
90 In a Crosstab query ,you cannot set the
orders according to your requirements.
91 The forms which is resembled as a datasheet is
92 Which one of the form is used to depict 1:M Relationship.
93 The form which is resemble a manual data entry form.
94 Which one of the way is used to create a form
95 The memo field allows upto bytes of text for each field.
96 To create a form which one of the follwing control object is not used.
97
98 table.
99 Which one of the control is based on expression
100 Calculated controls are also known as
101 Reports are used for
102 Which one of the report display data vertically.
103 Auto report generates
104 Which one is not used as a report element
105 Report footer is present
106 Access can incorporate graphs within a
107 The graphs can be created by using
108 Maximum actions in a macro is
109 Macros are used to perform tasks such as
110 Macro design window consist of
111 Which pane is known as Argument pane
112 Which one of this macro changes the cursor to the windows busy pointer
113 Which one operator is used with Null operator
114 The ouput of the 2*3^2-5
115 Len("Hundred") returns
116 sqr(625) will return
117 Lcase("LowerCasE") will return
118 Val("Haunted Street 10") will return
119 Format("0116195866","(@@@)@@@-
@@@@")
120 Now() returns
121 format(#12/25/96#,"d-mmmm-yyyy") returns
122 # wilcard represent
123 Which keystroke is used to replace existing value with default
124 Which keystroke is used to insert line break in Text and memo fields
125 Which keystroke is used to replace with value of previous field.
126 In match drop-down list which option is default
127 to reduce the numeric field which property is required to be reduced
128 Which one of the field can not be resized
129 Which one of the following field name is invalid
130 Allow zero length property is valid only for following data type
131 the input mask can contain upto parts seprated by semiclon
132 The double field data type contain how many decimal places
133 Which one user defined format symbol is not used in text &memo data type
134 Short date format is represented as
135 The Storage Size of Auto number data type is
136 To display data from another table which one of the following data type is used
137 The storage size of OLE object is
138 Max. No. o0f table & objects in a database is allowed by Access
139 In Excel the intersection of a row and column is called
140 The total size of Excel worksheet is
141 A worksheet can be opened by clicking on the
142 The combination of the column letter and row number for a cell in an excel worksheet is called a
143 A collection of worksheets is called
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
145 The TODAY() function enters the current
146 One of the following statements about Excel ranges is incorrect
147 References that change automatically when you copy them to a new cell are called
148 When Excel copies a formula from one cell to another, it identifies the number it needs by
149 To change the cell reference C4:C9 to an absolute row and column reference , you would enter it as
150 If you wish to copy the formating used in one section in your worksheet to another
151 Using Borders, you
152 Selecting Landscape changes your page from
153 Using ChartWizard, you can quickly and easily turn your
154 Pie chart can be plotted on
155 Excel uses another name for database. It is called
156 Excel can display upto fields of a data form.
157 The comparison operators to compute criteria's are
158 A function in Excel,
159 In the function =ROUND(G5/30,0)
160 A macro is made up of a series of instructions written in a language called
161 Excel worksheet data can be shared with Word document by
162 Macros are Automatically set to use
163 You can convert existing Excel worksheet data and charts to an HTML documents by using the
164 A area of memory or disk that is assigned to store any e-mail messages sent by other users
165 The process a user goes through to begin a computer system
166 To enlarge a window to its maximum size so that it fails the entire desktop
167 A program made by microsoft and included in Windows-98 that is used to Web Documents
168 An icon
169 A connection from the current document to another document to another document or to a document on the World Wide Web
170 A goup of letters, number and symbols with a common typeface
171 A Folder is
172 A Drop- Down List Box
173 A letter, memo, proposal or other file that is created using Microsoft Word is
174 The screen background and main area of windows where you can open and manage files and programes is called as
175 A setting or action predetermined by the program unless changed by the user is called as
176 The meaning of Cut is
177 A cursor is
178 A Command Button is a
179 Close Button
180 A Check Box
181 A button is
182 A Browser is a
183 A Bitmap is
184 The Term Active Window means
185 An Application is
186 Word offers certain ways by which you can move around in a document
187 Paragraph marks signify
188 The Save As dialog box can be used
189 The step involved to open the document are
190 While typing a paragraph you will
191 When Microsoft Word gets loaded, the Opening screen displays document named :
192 As you type in the text, some of the words may appear with a red wavy underline. It signifies
193 Purpose of Arrange all option in Window menu is
194 New Window command from the Window menu will
195 On a split box
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
197 The Magnifier button is available on the
198 Soft page breaks
199 Selection of text can be of
200 The Formatting Toolbar is applied
201 In order to change the font and its size, you will
202 If you click on the Undo button
203 The contents of the Clipboard remain the same until
204 Using Microsoft Word's Find and Replace feature you can -
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;
206 You will probably use Borders where
207 While using the Mail Merge Helper you click on the active window button. This selection creates
208 A data source is made up of
209 To make a field name in a data source one of the following is not permitted
210 When you create a wizard
211 After you create a document, you may need to
212 You can print a document
213 To preserve any changes gto the document currentlhy displayed on your screen, you should
214 The horizontal ruler provides features you can use to
215 Which of the following special characters can be used in a filename?
216 If you change a documentand then try to close the Word application, the Word will
217 Word inserts a formula as
218 To align numbers with the same number of decimal points in a table column
219 Which of the following formatting options is notavailable on the Tables and Borders toolbar?
220 In print preview you can
221 The Magnifier button
222 The Select Object Browse button is located
No comments