CF QUIZE ALL

1			Getting data from a cell located in a different sheet is called …
			A.   Accessing   B.  Referencing   C.  Updating   D.  Functioning
2			You can use different page formatting within the same document by separating the differently formatted areas using –
			A.   Page Break   B.  Column Break   C.  Formatting Break   D.  Section Break
4			Which is not related to relationship?
			A.   Avoid duplicate data   B.  Data can be entered into or viewed from one or more tables   C.  create inconsistency of data   D.  None
6			Of the following options, which is/are valid report layout(s)?
			A.   Stepped   B.  Block   C.  portrait   D.  Both A & B
7			Which of the following views does not allow the form to be modified?
			A.   Layout view   B.  Form View   C.  Design view   D.  All
8			In which row of query design grid do we set conditions?
			A.   Field   B.  sort   C.  criteria   D.  show
9			What type of page orientation does a document have when it is laid out so that it is wider than it is tall?
			A.   Landscape   B.  Side   C.  Horizontal   D.  Portrait
10			Access 2007 supports which type of database system?
			A.   DBMS   B.   RDBMS   C.   Flat file system   D.   ORDBMS
11			To create a relationship what should you do?
			A.   Click Insert menu and then click Relationship   B.  Click Database Tools tab and click Relationship button   C.  Click Edit menu and then click Relationship   D.  Press Ctrl + Shift + P
12			You can insert automatic page numbering to the top of each page in MS Word by clicking on the –
			A.   Home tab > Page Number > Top   B.  Insert tab > Page Number > Top of Page > Choose a style   C.  View tab > Paging > Number > Header   D.  Page Layout tab > Indent > Top
13			Which one of the following statements is not correct related to Index?
			A.      An index stores the location of records.   B.      Index may speed up searches, it can also slow the process of updating data within table.   C.       You can set index on a field which is seldom used   D.   You can set index on any fields except OLE objects or attachment fields.
14			Updating all tables that are dependent upon a main or master table is called
			A.   Cascade delete   B.  Cascade update   C.  Referential integrity   D.  None
15			Which one is correct regarding relationships?
			A.   You can not edit or delete relationship.   B.  Many to Many relationship between tables is considered as an ideal relationship.   C.  You can not edit table after establishing relationship   D.  None
16			Filters remain in place until—
			A.   they are removed   B.  the object is closed   C.        Both A & B   D.            Only A
18			If you want to distribute your document to someone using a totally different word‐processing program from a different software manufacturer, such as WordPerfect, which file-format will you choose when saving the document?
			A.   rtf   B.  doc   C.  xls   D.  pdf
19			In Windows Explorer, for displaying the contents of a certain drive or folder we need to
			A.   Click the drive or folder while holding down the Alt key.   B.  Triple-click the drive or folder.   C.  Double-click the drive or folder.   D.  Right-click the drive or folder.
	20	Which one of the following is not the form view?
		A.   Form view   B.  Datasheet view   C.  Layout view   D.  Design view

 

23	What is the term used when a clip art image changes the direction of faces?
	A.   Group   B.  Flip   C.  Rotate   D.  All of the above

 

 

25	To locate a particular record which of the following options of the navigation bar can we use ?
	A.       First   B.      Specific   C.    Next   D.       Last
26	Which of the following is the unique address for a file/website that is accessible on the Internet?
	A.   URL   B.  HTTP   C.  HTML   D.  WWW
27	Which of the following tool enables you to add text to a slide without using the standard placeholders?
	A.   Text box under INSERT menu   B.  Line tool   C.  Drawing tool   D.  Auto shapes tool

 

28	Which option(s) can you access by clicking the Office Button of Microsoft Word?
	A.   Saving a file   B.  Opening a file   C.  Printing the content of a file   D.  All of the above

 

29	In the memo data type you can insert data up to ____ characters.
	A.   350   B.  Unlimited   C.  10000   D.  65536
30	Which one of the following is a function of titlebar?
	A.   Displays the working information.   B.  Displays name of the window and/or software program being used.   C.  Moves a document to any position   D.  Opens a series of drop down menu.

 

32			How can you export a table or query output as an excel spreadsheet?
			A.         Open an access databaseàopen file queriesàClick external data tabàclick Export to XML icon.   B.  Open an access databaseàopen file queriesàClick external data tabàclick Export to Excel Spreadsheet icon   C.          Open an access databaseàopen file queriesàClick external data tabàSaved import icon   D.  None
33			Which of the following should you use if you want all the slides in the presentation to have the same “look”?
			A.   The slide layout option   B.  Add a slide option   C.  Outline view   D.  A presentation design template
34			The maximum zoom percentage in Microsoft PowerPoint is
			A.   100%   B.  200%   C.  400%   D.  500%
	36	What is the term used when you press and hold the left mouse key and move the mouse around the slide?
		A.   Highlighting   B.  Dragging   C.  Selecting   D.  Moving

 

39	Which of the following presentation elements can you modify using the slide master?
	A.   Slide comments   B.  Slide transitions   C.  Speaker note font and color   D.  All of above

 

 

40	Objects on the slide that hold text are called
	A.   Placeholders   B.  Object holders   C.  Auto layouts   D.  Text holders

 

42	What is defined by the handout master?
	A.   Slide Formatting   B.  Layout of Audience Handout notes   C.  Handout content formatting for Microsoft Word export   D.  All of above
43	Which dialogue box lets you set and customize various MS-Word options such as setting the user name, default file location etc.?
	A.   “Word Options” dialogue box   B.  “Document Inspector” dialogue box   C.  “Save As” dialogue box   D.  None of the above

 

44	If you press ___________, the cell accepts whatever you have typed as its contents.
	A.   Enter   B.  Ctrl+Enter   C.  Tab   D.  Insert

 

46The slide that is used to introduce a topic and set the tone for the presentation is called the

A.	Table slide
B.	Graph slide
C.	Bullet slide
D.	Title slide
47		What do you mean by Like” A????”
		A.      Entry must be four characters and begin with the letter A   B.             Entry must be five characters and begin with the letter A   C.           Entry must be five characters and begin with any letter.   D.             None

 

51 What do you mean by * symbol ?

A.		It represents the column currently selected.
B.		It represents the row previously selected.
C.		It represents the row currently selected
D.		None of the above
52	Microsoft PowerPoint is a
	A.   Database program   B.  Spreadsheet program   C.  Presentation program   D.  Word processing program

 

 

 

 

56	Which of the following icons on your Desktop most likely represent an application?
	A.   My Documents   B.  My Computer   C.  My Network Place   D.  Internet Explorer

57 Which of the following provides a printed copy of your presentation?

A.	Outline
B.	Speaker notes
C.	Handouts
D.	All of the above

 

59	The PowerPoint view that displays only text (title and bullets) is
	A.   Slide show   B.  Slide sorter view   C.  Notes page view   D.  Outline view

 

60	When a label is too long to fit within a MS Excel Worksheet cell, you typically must
	A.   Shorten the label   B.  Increase the column width   C.  Decrease the column width   D.  Adjust the row height

61 In the table when you are inserting the data, the power suddenly goes off. What will happen?

A.	All data is lost
B.	A few data is lost
C.	All data is save
D.	A few data is save

67 To add a header or footer to your handout, you can use

A.	The Title master
B.	The Slide master
C.	The Handout master
D.	All of above

 

71	The wildcard ‘[ ]’ refers to
	A.     Matches any single alphabetic character within a string.    B.  Matches any single character within the brackets    C.  Matches any character not defined within the brackets    D.  Matches any one of a range of characters defined within the brackets
72	To insert unique and sequential data automatically which data type can we use?
	A.   OLE    B.        Attachment    C.       Text    D.        AutoNumber
73	An index is automatically created on
	A.   Primary key field    B.  Foreign key field    C.  Id Number    D.  All of them
74	Which of the following is the primary data repository in Access database?
	A.   Queries    B.  Form    C.  Table    D.  Report
76	Which of the following is/are database objects?
	A.   Table    B.  Query    C.  Form    D.  All

 

 

79	Which one of the following stores the whole value entered but only displays the number up to two decimal places?
	A.   General Number    B.  Fixed    C.  Standard    D.  Currency

 

 

 

83	To configure the properties of an object in MS-Access 2007, which of the following can we use?
	A.   Datasheet view    B.  Design view    C.  Table view    D.  Print preview

 

Bottom of Form

85	Null value is allowed in
	A.   Unique key field    B.  Primary key field    C.  Foreign key field    D.  Both A& C