UpWork (oDesk) & Elance Visual Basic 6 Test Question & Answers

UpWork (oDesk) & Elance Visual Basic 6 Test Question & Answers

July 03, 2015 / No Comments

UpWork (oDesk) & Elance Visual Basic 6 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of Visual Basic 6. Lets Start test.

Ques : Which of the following cannot be included in the Open method of the recordset?
Ans  : Cursor Type

Ques : You are creating a client application that calls ActiveX DLLs. Which of the following properties of the Err object provides the name of a component that sends an error back to the client application?
Ans  : Number

Ques :  Which event should you use to store property values into the PropertyBag?
Ans  : Terminate

Ques : Which event should be used to resize an ActiveX control as the user modifies the size of the control implementation on a form?
Ans  :  Resize

Ques : The ______ function can be used to run any .com, .exe, .bat or .pif file from a Visual Basic program.
Ans  : Shell

Ques : Consider the following program code:

(i) Dim FileName as String
Open FileName For Input As #FreeFile

(ii) Dim FileName as String
FileNum = FreeFile
Open FileName For Input As #FileNum
Ans  : Both (i) and (ii) are correct

Ques : What data type is the HelpContextID?
Ans  : String

Ques : To store pictures in an array, Visual Basic provides the _____ control.
Ans  : PictureClip

Ques : What is the sequence of events when a form is unloaded?
Ans  : QueryUnload, Unload and Terminate

Ques : What is the default value for the scalemode property of the form?
Ans  : Twip

Ques : Visual Basic displays information depending upon the current value of two properties of the form, called:
Ans  : CurrentX and CurrentY

Ques : Which of the following statements is capable of abandoning a series of modifications made to a recordset locked with a BatchOptimistic lock?
Ans  :  CancelUpdate

Ques : What is the purpose of the Image List Control?
Ans  : To display images to the user

Ques : A __________ control defaults to displaying the files in the current directory:
Ans  : File List Box

Ques : Which property procedure is used to retrieve the value of a property?
Ans  : Retrieve

Ques : Which method will you use to remove a form from the Screen but retain it in memory?
Ans  : Show method

Ques : Which events allow you to determine if a Control or Shift key was pressed by the user?
Ans  : Click and KeyPress

Ques : In order to overlap the controls (say a command button) during design time, we use the 'Send To Back' or 'Bring To Front' option from the Edit menu. To change it dynamically (i.e. during program execution) we need to change:
Ans  : Background color property

Ques : The ____ function returns the numeric value from a string expression:
Ans  : Val

Ques : What do CurrentX and CurrentY return?
Ans  : Current X and Y co-ordinates of mousepointer

Ques :  Variables that allow sharing of values across event procedures are called:
Ans  : Form level variable

Ques : Which of the following approaches to data modifications is the least efficient?
Ans  :  Updating through a cursor using a recordse

Ques : The interval property of the Timer control specifies the time in:
Ans  : Milliseconds

Ques : Which parameter of the WriteProperty method can be omitted but should be included to increase the efficiency of the control?
Ans  : Name

Ques : A project group is a Project which:
Ans  : Consists of several Projects

Ques : What is the purpose of the Class Builder add-in in Visual Basic:
Ans  : To add classes to the current project

Ques : An ADO dynamic property is:
Ans  : A property that changes value at runtime

Ques :   In order to provide a transparent background to the Form, you must change the _________ property to _______.
Ans  : BackStyle, Opaque

Ques : What does the controls collection contain?
Ans  : A list of all controls on a form

Ques : Global Procedures and Global Variables are declared in:
Ans  : Form Modules

Ques : Given the following code segment, how many instances of the form are created and displayed ?

      dim frmvar1 as frmperson,frmvar2 as frmperson
      set frmvar1 = new frmperson
      set frmvar2 = frmvar1
      load frmvar1
      frmvar2.show
Ans  : None

Ques :  Only Controls with a ________ property such as Picturebox, Toolbox, Statusbar etc. can be placed on an MDI form:
Ans  : Showtips

Ques : Whenever the current record is about to change, Visual Basic generates the ______ event:
Ans  : Validate

Ques : Which of the following will provide the best aggregate performance for a query that is not executed repeatedly?
Ans  : Direct execution

Ques : The _______ property enables Visual Basic to draw complete images in memory before displaying them on the Screen.
Ans  : AutoRedraw = True

Ques : Which event of an ActiveX control data provider runs every time a bound control extracts data through the provider?
Ans  : GetDataMember

Ques : One can convert a Visual Basic Application into ActiveX Document using:
Ans  : Visual Database Manager

Ques :  Which function or method will you use to get a count of the maximum index limit of an array?
Ans  :  UBound function

Ques : Which property of the ProgressBar determines how much of the bar is filled?
Ans  : Min

Ques : In order to change the mouse pointer shape from glass to watch-glass, the property to be used is:
Ans  : MousePointer

Ques : The caption and the name properties of the command button:
Ans  : Are one and the same

Ques : In order to access a file in Non-textual format, you have to open file in:
Ans  : Ascii Format

Ques : What is the extension of the Visual Basic project file that stores the design of a user control.
Ans  : .ctx

Ques : After a Dynaset type recordset has been created and opened, further searching is possible using the:
Ans  : FindNext method

Ques : Which method of the Recordset object should you use to navigate multiple recordsets returned by a stored procedure?
Ans  : NewRecordset

Ques :  Which event procedure is called only if AutoRedraw property is set to false:
Ans  : Form_GotFocus

Ques : Which events enable you to determine which key was pressed by the user?
Ans  :  Click and KeyPress

Ques : The Kill command in Visual Basic is used for:
Ans  : Stopping the current process

Ques : Which method would you use to get a free or unused File identifier while opening any file:
Ans  : FreeFile

Ques : Which event is fired when a text box loses focus?
Ans  : LostFocus

Ques :  Message Boxes can hold a maximum of _______ characters.
Ans  : 256

Ques : Which of the following is the only valid Resume statement in an error handler?
Ans  : Resume prior

Ques : Which is the only event of the timer control?
Ans  : Timer

Ques : Consider the following subprogram:

        Sub ChangeText(ByVal X as String,Y as String)
          Y = X
        End Sub


If you are calling it using the following code:

            Call ChangeText(Form1.Caption,Y$)
Ans  : The Caption of Form1 will change to the value contained in Y$

Ques : If one needs to use an ampersand(&) in a Label but does not want it to be an Access Key, the _______ property of the label must be set to False.
Ans  : Caption

Ques : Which property of the Err object returns the numeric value associated with the most recent runtime error?
Ans  : Description

Ques : The event Lost_Focus of one object results in _____ of the other object:
Ans  : Got_Focus

Ques : Which of the following ADO recordset types provides the greatest degree of concurrency?
Ans  : Static

Ques : The ______ property is used to show Tool Tips or Help Balloons when the mouse rests on the object:
Ans  : ToolTipText

Ques :  Which of the following can be shown to the user using the Common Dialog control in VB?
Ans  : Common messages passed to Windows

Ques :  Which property of the form changes the form's title?
Ans  : Name

Ques : In order to enable the DBGridControl or the MSFlexGrid Control to display the contents of a table or query, you need to set only the ______ property:
Ans  : DataSource

Ques : In Visual Basic, which method can you use to send key strokes to other Window applications?
Ans  : AppActivate

Ques :  The _______ property changes the tab order at runtime:
Ans  : Tab stop

Ques : You want the code of the close command button to execute upon pressing the ESC key, even though the focus may be on another control in the form. Which property of the command button would you set to true?
Ans  : Cancel

Ques : Which collection of an ActiveX control enumerates all of the properties that can be bound to a data source?
Ans  : DataFields

Ques : You can create menus by the ________ and _________.
Ans  : Menu Editor, Application Wizard

Ques :   What is the sequence in which the following events are triggered when a form is loaded?
Ans  : Initialize, Load, Resize and Paint

Ques : Procedures declared in a _____ are local whereas procedures declared in a ______ are  available to the whole application.
Ans  : Form window, standard or code module

Ques : Which property of the ListView control determines which field a sort is based on?
Ans  : Sorted

Ques :  The method used to search for records from within a table type recordset object is:
Ans  : LookUp

Ques : Which event is triggered when the user moves to another open form?
Ans  : Unload

Ques : Which of the following is an event of the Shape control?
Ans  : GotFocus

Ques :  Which line of code listed here can be used to create a string of fixed length:
Ans  : Dim strFirstName as String

Ques : Which of the following statements is incorrect regarding toolbars?
Ans  : There can be only one toolbar on a form

Ques : The settings for the Color properties in Visual Basic are indicated by:
Ans  : Decimal Coding

Ques : What does the forms collection contain?
Ans  : A list of all forms in a project

Ques : Which of the following will perform a direct execution of a Command object?
Ans  : The Execute method

Ques : The _______ function enables a VB application to make use of the idle time and to respond periodically to events.
Ans  :  GetTime()

Ques : The Load & Activate events are associated with:
Ans  : All controls

Ques : What you must do before making calls to an ActiveX DLL project in the same Project Group?
Ans  : Compile the DLL

Ques : Name the only property supported by a collection?
Ans  : Name

Ques : Which event of a text box would you use for validating the data entered by the user?
Ans  : Validate

Ques : Which event occurs only once in the entire life cycle of an ActiveX control?
Ans  : Initialize

Ques : How can you keep the user from exiting a form by clicking the Close button?
Ans  : Place code in the Terminate event

Ques : Which of the following debug tools would you use to locate your current position in a series of embedded procedure calls?
Ans  :  Locals window

Ques : You are creating an ActiveX component that raises user-defined errors. Which of the following statements correctly raises an error to the client with error number 20000?
Ans  : Err.Raise vbObjectError + 20000

Ques :  A prepared statement is:
Ans  : Query text cached on the server

Ques : The _______ method loads the form named 'Form1' in to memory and also displays it.
Ans  :  Load Form1

Ques : You want to display the code and the description of an error. What would be the correct syntax?
Ans  : Msgbox err.no & err.text

Ques : If the CancelError Property of the CommonDialog Box is set to true then which of the following statement is true:
Ans  : A runtime error can result if the user clicks the cancel button

Ques : How do you create a read only property in a form?
Ans  : Create only a Property Set procedure

Ques : Which three methods does the collection object support?
Ans  : Let, Get, Set

Ques : Labels do not respond to _____ and ______ events.
Ans  : Got_Focus , Lost_Focus

Ques : The _______ method resets the contents of bound controls to their original values when the user clicks on the cancel button.
Ans  : UpdateControls

Ques : Which of the following is the only drag related event?
Ans  : DragEnter

Ques : You are creating an ActiveX component that raises user-defined errors. What is the valid range of error numbers that you can use for user-defined errors?
Ans  : 1-1000

Ques : Which of the following procedure types will execute when you assign a value to a property of an object?
Ans  : Property Get

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers

July 01, 2015 / No Comments

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: Which of the following is incorrect regarding "Hyphenation Zone?"

Ans: The hyphenation zone cannot be changed to make it narrower.

Ques: State whether true or false: The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
Ans: True

Ques: Which among the following is an invalid character to include in a file name?
Ans: All of the above

Ques: Which among the following is NOT true about content controls?
Ans: Customized content controls cannot be distributed.

Ques: Unlike the other types of styles (paragraph, character, linked, and table), predefined list styles are available when you first create a document in Word 2007.
Ans: True

Ques: Which keyboard shortcut is used to make the text size smaller?
Ans: CTRL+SHIFT+<

Ques: Which among the following charts do not have axes?
Ans: Doughnut charts

Ques: What is the significance of "Building Blocks?"
Ans: Building blocks are items within a document that can be saved to be reused in other documents.

Ques: Which among the following options should be used to number the cells in a table?
Ans: Select the table cells that need to be numbered. On the Home tab, in the Paragraph group, click on Numbering.

Ques: Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: All of the above

Ques: Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: All of the above

Ques: Edit tracking changes are typically formatted in the following manner: (1) deletions—red strikethroughs, (2) additions—green and underlined, and (3) formatting changes are made bold in almost any other desired color. Where in Word 2007 could you set your own custom formatting options for tracking changes?
Ans: Select the Review ribbon and then select the triangle by Track Changes. In the drop-down menu, select "Change Tracking Options" and then set your formatting options in the Track Changes Options dialog box.

Ques: Which view(s) could be used to view the Equation placeholders in the Document Views group?
Ans: All of the above

Ques: Which among the following is a keyboard shortcut to cut a table?
Ans: CTRL+X

Ques: State whether true or false: When you save a document as a Web page, the textures and gradients are saved as JPEG files and the patterns are saved as GIF files.
Ans: True

Ques: State whether true or false: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.
Ans: True

Ques: Which keyboard shortcut inserts a hyperlink?
Ans: CTRL+K

Ques: State whether true or false: Microsoft Office programs store some additional information within the digital signature automatically that might not be visible in the current view document.
Ans: True

Ques: What does the icon marked with 'A' on the status bar on the bottom of the page indicate in the given picture?
Ans: It indicates that the document contains a signature.

Ques: Refer to the given image. How could the Quick Access Toolbar be moved?
Ans: Click on "Customize Quick Access Toolbar." In the list, click on "Show Below the Ribbon."

Ques: State whether true or false: Gridlines do not print when a document is printed.
Ans: True

Ques: How would you divide your Word 2007 document into three columns?
Ans: Position your cursor where you would like to insert the columns. Open the Page Layout ribbon. In the Page Setup section, click Columns. Select Three.

Ques: What is meant by Enhanced ScreenTips?
Ans: Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic.

Ques: Which among the following options is not true regarding a macro?
Ans: To work with macros in Word 2007, the Review tab needs to be opened.

Ques: State whether true or false: A building block can be added to as many galleries as you want.
Ans: True

Ques: What steps should be followed to replace a shape with another shape?
Ans: Select the shape to be changed. Select the Format tab; use the "Change Shape" button in the Shape Styles group.

Ques: State whether true or false: In Microsoft Word 2007, a diagram can be converted to individual shapes.
Ans: False

Ques: How does the "Gutter margin" help while using Page Setup, as shown in the picture?
Ans: It ensures that the text is not obscured by binding.

Ques: The Draft view was called the Normal view in versions of Word prior to Word 2007. The Draft view can help with setting the page and section breaks for the document. Which of the following could be used to select the Draft view for a document?
Ans: Select the Office button and then select Word Options. In the Word Options dialog box, select Display and check the Draft check box under Page display options.

Ques: In Picture1, the check box has a gray background. Which among the following Legacy Tools (select the Developer tab and then the Controls group) will be used to remove the gray shading in Picture2?
Ans: C

Ques: Refer to the picture given above. Which of the following options should be selected to scroll both documents together?
Ans: B

Ques: Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Multiple

Ques: With the help of which view will the Watermark not be seen?
Ans: Web Layout view

Ques: State whether true or false: An existing table cannot be copied and pasted into another table.
Ans: True

Ques: State whether true or false: New text animation effects can be applied in Microsoft Word 2007.
Ans: False

Ques: Which option(s) should you select to remove a chart or axis title from a chart?
Ans: All of the above

Ques: What is the purpose of the "Demote" button as shown in the diagram?
Ans: It increases the level of a selected bullet or a shape.

Ques: Which of the following is not true about "Format Painter?"
Ans: Format Painter is used to apply text formatting and some basic graphics formatting, such as borders and fills.

Ques: State whether true or false: Placeholder citations appear in the bibliography.
Ans: True

Ques: Which among the following is not true regarding the use of a pie chart?
Ans: A pie chart could be used when there is only one data series to be plotted.

Ques: In the given picture, the "Washout" option has been selected. What purpose does it serve?
Ans: It lightens the picture so that it does not interfere with the text.

Ques: What is the maximum number of columns that can be created in the Columns dialog box as shown in the picture?
Ans: 13

Ques: Which feature has been used from the Picture Pane on Picture1 to achieve the same result as Picture2?
Ans: Recolor

Ques: Which command-line switch and parameter starts Word 2007 without displaying the Word splash screen?
Ans: /q

Ques: What does the command "Winword.exe /f MyDocument.docx" mean?
Ans: This command instructs Word to start and immediately open a file named MyDocument.docx.

Ques: How will you set the default font so that every time you open Microsoft Word it will use the settings that you had selected?
Ans: Select the Home tab, and then click the Font Dialog Box Launcher. Select the font style and size. Click on Default... and then click Yes.

Ques: In some cases, when lists are combined into one "List," the formatting is not updated. Refer to the picture given above. Which among the following options should be used to update this formatting?
Ans: D

Ques: Refer to the given image. In Picture1, axes appear on the left side. Which setting should you use to make them appear on the right side, as shown in Picture2?
Ans: Select the Axis Options tab in the Format Axis dialog box. Set the Axis labels: field to High.

Ques: In the given picture, the "Keep Text Flat" option has been selected. What is the use of this feature?
Ans: It prevents text inside the shape from rotating when the shape is rotated.

Ques: State whether true or false: Changes that are made on the Worksheet are automatically updated in the chart.
Ans: False

Ques: Refer to the given picture. Which of the following Line Numbers should be used when each page has to begin with the number 1?
Ans: B

Ques: Suppose you want to insert a cross reference at the current cursor position in the document to a heading (located elsewhere in the document). Which of the following methods would do this in Word 2007?
Ans: Select the Insert tab. In the Links section, click Cross-reference. Select Headings under Reference type. Select the appropriate heading from those displayed in the bottom pane. After you have made your selection, click Insert. Close the dialog box.

Ques: For what purpose is the SmartArt graphic control used, as shown in the picture?
Ans: It shows the Text Pane on clicking the control.

Ques: Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author

Ques: The default installation of Word 2007 includes several built-in character styles. Which of the following is NOT one of the default, built-in character styles:
Ans: Special Emphasis

Ques: How will the Message Bar alerts be enabled as shown in the given picture?
Ans: Select Word Options from the Microsoft Office Button. Click on Trust Center, then click Trust Center Settings, and then click Message Bar.

Ques: Which of the following is not a type of "Section Breaks?"
Ans: First Page

Ques: Which chart type does the given picture represent?
Ans: Area charts

Ques: Which of the following charts display "Error bars" for x values, y values, or both?
Ans: XY (Scatter) charts & Bubble charts

Ques: Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: linked

Ques: To enter a symbol or special character into your document (to where the cursor is located), which of the following methods could you employ in Word 2007?
Ans: Open the Insert ribbon. Click Symbol in the Symbols group. A menu will appear with a small selection of symbols. If you don't see the symbol or character you'd like to insert, click More Symbols. Choose the special character (or symbol) that you want and then click Insert and click Close.

Ques: The given picture shows the list items being at different levels rather than at one level. What is this list known as?
Ans: Multilevel

Ques: Which among the following file types of templates allows macros to be enabled in the file?
Ans: .dotm

Ques: Refer to the given picture. Which of the following buttons is used to show paragraph marks and other hidden formatting symbols?
Ans: D

Ques: Which of the following is/are true about phishing?
Ans: All of the above

Ques: Which of the following options repeats a table heading on subsequent pages?
Ans: None of the above

Ques: Which among the following options represents Legend entries in the given picture?
Ans: C

Ques: Which among the following features could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive

Ques: Which among the following is a correct way to make your file "Read-only?"
Ans: Click "Save As" from the Microsoft Office Button. Click on Tools and then click General Options. Select the Read-only recommended check box. Click OK. Click on Save.

Ques: You are editing a figure using the Drawing Tools > Format options. Which among the following Shape Fill options in the Shape Styles group adds a solid color and transparency to a shape?
Ans: More Fill Colors...

Ques: State whether true or false: Any changes that are saved to "Normal.dotm" will be applied to the documents that you create in the future.
Ans: True

Ques: Refer to the given image. Which option should be selected to convert a professionally formatted equation into an equation on one line?
Ans: C

Ques: In the given picture, the "Match case" check box has been selected. Which among the following is true for this selection made for the "Match case" check box?
Ans: It searches for only entire words that match the case of the word or phrase that is typed in the "Find what" box.

Ques: State whether true or false: ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
Ans: True

Ques: Which method determines the position of the "Envelope" while printing, in the Envelope options dialog box?
Ans: Feed method

Ques: Which among the following is an "Orientation" type of Page Layout?
Ans: Portrait

Ques: Which among the following is a keyboard shortcut to underline blank spaces for a form?
Ans: Shift + Hyphen(-)

Ques: Which among the following options is the reason for text getting deleted at the insertion point when you type a document?
Ans: The "overtype mode" is turned on in Word options.

Ques: State whether true or false: Cover pages are always inserted at the beginning of a document, no matter where the cursor appears in the document.
Ans: True

Ques: State whether true or false: Switches and parameters are not case-sensitive.
Ans: True

Ques: Just as in Word 2003 or prior Word versions, the default standard view for Word 2007 is the Draft view (and is still also called the Normal view in Word 2007):
Ans: True

Ques: How will you insert text boxes for a printed form?
Ans: Select the Insert tab, in the Text group, click on Text Box and then select Draw Text Box.

Ques: Which of the following two paragraphs is/are true for Word 2007?
(1)To show or hide formatting marks in your editing markup — on the Home ribbon, in the Paragraph group, click the Show/Hide button.
(2) The Show/Hide button will not hide all the formatting marks in the document if you selected those marks that are to be displayed at all times (such as paragraph marks, tab characters, hidden text, optional hyphens, object anchors, or spaces). To turn off any or all of these selected formatting marks, follow this procedure: Click the Microsoft Office Button and then click Word Options. Then Click Display. Under "Always show these formatting marks on the screen," clear the check boxes for any formatting marks that you do not want to show at all times in your documents.
Ans: Both (1) and (2)

Ques: How will you change the author name in an existing document?
Ans: Click on the Microsoft Office Button, select Prepare, and then click Properties. Type the author name in the Author box.

Ques: Which among the following is the correct order to convert a table to text?
Ans: Select the table. Under Table Tools, on the Layout tab, in the Data group, click on "Convert to Text."

Ques: Which of the following is true about the term "Mark as Final," as shown in the picture?
Ans: It helps to communicate that a completed version of a document is being shared.

Ques: Which keyboard shortcut could be used to switch to Draft View?
Ans: ALT+CTRL+N

Ques: Which of the following is shown in the picture, denoted by A?
Ans: Rotation Handle

Ques: Refer to the given picture. Which of the following options turns off Enhanced ScreenTips but keeps the ScreenTips still visible?
Ans: B

Ques: With which chart type(s) is/are the "Depth Gridlines" option available?
Ans: True 3-D chart

Ques: Which of the following can be the reason for the appearance of the red X, as shown in the picture?
Ans: All of the above

Ques: State whether true or false: Once a bullet is removed from the "Bullet Library" and it is no longer available in the "Document Bullets" area, the bullet cannot be added back to the Bullet Library.
Ans: False

Ques: Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

Ques: Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

Ques: Which among the following options should be used to start a bulleted list automatically?
Ans: Type * (asterisk) and then press spacebar or the Tab key.

Ques: Which among the following options would you choose to automatically enter the current date?


Ans: Select the Insert tab and then select Date & Time in the Text group. Choose one of the available formats in the Date and Time dialog box.

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers

/ No Comments

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?
Ans: All cloned copies of that slicer are also updated instantly.

Ques: How would you assign a macro to a graphic?
Ans: On a worksheet, right-click on the graphic, then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

Ques: State whether following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
Ans: False

Ques: Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?
Ans: Online Analytical Processing (OLAP) Cube Files

Ques: Which of the following tools is used to format Excel worksheet data, as shown in the figure above?
Ans: SmartArt

Ques: In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected?
Ans: It will select the whole sheet.

Ques: Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
Ans: Excel Web Access (EWA)

Ques: What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
Ans: .xltx

Ques: State whether following statement regarding images in Microsoft Excel 2010 is true or false: Microsoft Excel 2010 supports 3D rotation of images.
Ans: False

Ques: In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data.
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
Ans: The value of cell D9 will be 42

Ques: Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
Ans: PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.

Ques: With reference to the screenshot given, which of the following formulae CANNOT be used to calculate the average of the column 'Marks' in the cell 'E17'?
Ans: =AVERAGE(E6 to E15)

Ques: Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
Ans: It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.

Ques: State whether the following is true or false: Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
Ans: False

Ques: What does the icon marked with a red square in the figure above signify?
Ans: It signifies that the document contains digital signatures.

Ques: Excel keeps the changed history of a workbook for ________ days by default.
Ans: 30 days

Ques: Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?
Ans: Gradient Fill

Ques: Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
Ans: Both a and b

Ques: Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: Cell left

Ques: What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Ans: It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.

Ques: Microsoft Excel Services is a component of:
Ans: Microsoft SharePoint Technology

Ques: Which of the following statements is NOT true regarding import of data into PowerPivot?
Ans: Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.

Ques: Which among the following settings is the default macro security setting?
Ans: Disable all macros with notification.

Ques: Which of the following sorting options is NOT available under the Sort On option while sorting the data of a table in an Microsoft Excel 2010 worksheet?
Ans: Font Style

Ques: State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: An Absolute cell reference consists of the column letter and row number.
Ans: True

Ques: In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
Ans: By using the 'Orientation' button in the alignment group of the 'Home' tab.

Ques: Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

Ques: In the given screenshot, there are red triangles in the upper-right corner of each cell under the column titled 'Registrations'. What do these signify?
Ans: The red triangles represent the comment associated.

Ques: When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.
Ans: Worksheet

Ques: What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Ans: All of the above.

Ques: Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: False

Ques: You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?
Ans: Scenarios

Ques: Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: Cell left

Ques: Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Ans: Values

Ques: Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) The values in the lookup_vector must be placed in ________ order.
Ans: Ascending

Ques: You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?
Ans: 4-Color Scale

Ques: Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5))
Ans: 80

Ques: Analyze the syntax of LOOKUP function when used in vector form? LOOKUP(lookup_value, lookup_vector, result_vector) Which of the following arguments of the LOOKUP function is optional?
Ans: result_vector

Ques: Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
Ans: Version control and tracking is supported by PowerPivot.

Ques: Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members to be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
Ans: Share 'report.xlsx' by saving it to a SharePoint site.

Ques: State whether the following statement regarding cell references in Microsoft Excel 2010 is true or false: A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
Ans: False

Ques: What view must be used when inserting a subdocument?
Ans: Web Layout

Ques: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Ans: MDI

Ques: Which of the following in NOT a type of Section Break?
Ans: Continuous

Ques: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
Ans: Insert Flowchart

Ques: Which among the following chart types do not have axes?
Ans: Doughnut charts

Ques: When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.
Ans: Worksheet

Ques: When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, Smart Art graphics, shapes, and other objects are updated to complement one another.
Ans: False

Ques: This question is based upon the figure shown below --In the given screenshot, the letter X is pointing to an area between the first Row header, and the first Column header. What will happen when this particular area is selected?
Ans: It will select the whole sheet, having the same effect as that of Ctrl+A.

Ques: This question is based upon the figure shown below--When you double-click on a pivot report value of a PivotTable in Microsoft Excel 2010, Excel creates new ________ with data corresponding to the pivot report value.
Ans: Worksheet

Ques: This question is based upon the figure shown below- In the above given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B and D containing some integer data.
Ans: The value of cell D9 will be 42

Ques: This question is based upon the figure shown below --In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
Ans: By using the 'Orientation' button in the alignment group of the 'Home' tab.

Ques: This question is based upon the figure shown below--Analyze the image shown. What would be the output when you use the following formula in an MS Excel 2010 worksheet? =SUM(A2:CHOOSE(2,A3,A4,A5))
Ans: 80

Ques: This question is based upon the figure shown below--Suppose you clone the slicer shown in the image above into another worksheet in Microsoft Excel 2010. Considering that you make changes to the tile selected, in one of the slicers, which of the following statements shall be true?
Ans: All cloned copies of that slicer are also updated instantly.

Ques: This question is based upon the figure shown below--In the screenshot above, some product sales data is given followed by a pivot table derived from that data. Which of the following options is correct regarding the PivotTable?
Ans: The data can only be sorted according to the 'Product' field.

Ques: This question is based upon the figure shown below
Ans: It signifies that the document contains digital signatures.

Ques: Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: False

Ques: Analyze the syntax of LOOKUP function when used in vector form? LOOKUP (lookup _value, lookup _vector, result _vector) The values in the lookup _vector must be placed in ________ order.
Ans: Ascending

Ques: Which of the following arguments of the LOOKUP function is optional?
Ans: result_vector

Ques: Excel keeps the changed history of a workbook for ________ days by default.
Ans: 30 days

Ques: Microsoft Excel Services is a component of:
Ans: Microsoft SharePoint Technology

Ques: If you want to create a citation and fill in the source information later, you should:
Ans: insert a caption

Ques: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Ans: Make the field hidden.

Ques: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Ans: Ctrl

Ques: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
Ans: Tables with maximum number of rows and columns was added to the document.

Ques: A particular chart layout can be applied to a chart only if:
Ans: it is a 2D chart.

Ques: Choose the INCORRECT statement:
Ans: Only high-risk documents from an uncertain location are opened in Read-Only view.

Ques: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Ans: Open Type fonts

Ques: With which chart type(s) is the “Depth Gridlines” option available?
Ans: Line chart

Ques: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Ans: XLS

Ques: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
Ans: By using the Recolor option under Format Picture.

Ques: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
Ans: “Allow row to break across pages” is unchecked.

Ques: The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?
Ans: It adds up the values in the selected cells

Ques: Suppose you have created a report in Excel named 'report.xlsx'. Now you want that your team members should be able to see the report remotely on a web browser, and edit the report, as desired. Also it is required that the previous versions of the report are maintained to protect against any loss of data. Which of the following options is the most suitable one to deploy this report?
Ans: Share 'report.xlsx' by saving it to a SharePoint site.

Ques: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Ans: Change chart type to a line chart and type all the values into an Excel file.

Ques: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
Ans: Orientation

Ques: You are a financial consultant to multiple clients and you made an investment model for them. Now you want to find out how investment rates change under different market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study such conditions?
Ans: Scenarios

Ques: You are creating a new formatting rule which will be used to format a PivotTable report. Which of the following formatting styles is NOT available while formatting all cells of PivotTable report based on their values in an MS Excel 2010 worksheet?
Ans: 4-Color Scale

Ques: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Ans: Square

Ques: You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide(ans)

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers

June 30, 2015 / No Comments

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

 

Ques: For which of the given features does Outlook contain a logging option?
Ans: All of the above

Ques: Which of the following items cannot be archived?
Ans: Tasks

Ques: Refer to the given image.
When does this Warning message appear?
Ans: Both a and b

Ques: Which option will you choose to send an e-mail message with a report as an Excel attachment?
Ans: On the Reports toolbar, click the Send E-mail with report as Excel Attachment button

Ques: State whether True or False.

Certificate files have either a.p7c or.cer file extension.
Ans:  True

Ques: Refer to the given image.
Which option will you select to turn on Inline comments and create identifying text?
Ans: D

Ques: Refer to the given image.
Which option displays a command in the given picture?
Ans: B

Ques: Refer to the picture.
What is not true about an additional time zone?
Ans: All of the above

Ques: Which option is used to refresh a report?
Ans: On the Tools menu, Click Options and then select Refresh Report

Ques: Which of the following types of internet calendars are not updated automatically in the Outlook?
Ans: None of the above

Ques: Refer to the given image.
Which tab contains the ''Always show full menus'' check box?
Ans: C

Ques: Refer to the given image.
Which of the following rules work only for Exchange accounts?
Ans: B

Ques: Which of the following types of address books require you to use an Exchange account?
Ans: Outlook Address Book

Ques: Which type of communication history items cannot be linked to Account, Business contact, Opportunity and Business project?
Ans: Opportunity

Ques: Which option will you select to get information about your online or offline status?
Ans: Connection Status??

Ques: Refer to the given image and state whether True or False.
The Reconnect at login check box automatically connects to this network drive each time you start Microsoft Windows.
Ans: True

Ques: State whether True or False.

Attachments, such as files or e-mail messages cannot be added to project tasks, but they can be added to the linked Business Project.
Ans: False

Ques: Which of the following is the way to receive notifications about updates to a SharePoint site in Outlook 2007?
Ans: RSS

Ques: Which standard form is used for logging information about an item or event?
Ans: Post

Ques: Which type of attachment files does Outlook not block?
Ans: .Xls

Ques: With which types of e-mail accounts can the Junk E-mail filter be used
Ans: All of the above

Ques: Which type of communication history item is not saved in the Business Contact Manager for Outlook?
Ans: Business project

Ques: Which option will you select to change the size of an individual note?
Ans: All of the above

Ques: Which of the following parts does the To-Do Bar consist of?
Ans: All of the above

Ques: Which option will you choose to Mark a task complete?
Ans: Open an e-mail message marked with the task flag

Ques: Which option will you choose to add a RSS Feed in Outlook?
Ans: On the Tools menu, click account settings. Select RSS feeds tab

Ques: In which folder is the distribution list saved?
Ans: Contacts

Ques: Which option will you choose to see the completion status of all the project tasks linked to this Business Project record?
Ans: Project tasks

Ques: Refer to the given image.
Which of the following options will you select when you want to include a signature in all your multimedia messages?
Ans: None of the above

Ques: Which option will you select to insert a hyperlink in Microsoft Outlook?
Ans:  All of the above

Ques: Refer to the given image.
Which search option is not selected by default?
Ans: D

Ques: State whether True or False.

Meeting requests do not work in a SharePoint calendar.
Ans: True

Ques: Which option will you select to reduce the size of a Personal folders file?
Ans: Both a and b

Ques: Refer to the given image
Which option will you select to create a connection to a Shared Network folder?
Ans: A

Ques: State whether True or False.

The Outlook.ost files are used only when you have an Exchange Server account and choose to work offline or use the Cached Exchange Mode
Ans: False

Ques: Which option will you choose to turn on the Reading pane?
Ans: Both a and b

Ques: Which option will you select to digitally sign a macro project?
Ans: All of the above

Ques: Which option will you choose to turn off the Duplicate Detection Feature?
Ans: Both a and b

Ques: Which option allows you to preview the first three lines in unread messages?
Ans: Multiline layout

Ques: State whether True or False.

In the Reading Pane, you can read the content of an item, open attachments, follow a hyperlink and use voting buttons.
Ans: True

Ques: Refer to the given image.
Which tab will you choose to make Outlook the default program for E-mail, Contacts, and Calendar?
Ans:  D

Ques: In which type of files does the Inbox Repair tool(Scanpst.exe) scan or repair errors?
Ans: Both a and b

Ques: Refer to the given image.
When does an attachment appear in the body of the message?
Ans:  When the message format is rich text

Ques: Which of the following options do not add received flagged e-mail messages automatically?
Ans: To-Do Bar

Ques: State whether True or False.

The color of overdue items in Calendar in the Daily Task List cannot be changed as shown in the given picture.
Ans: False

Ques: Which option will you select to turn off the Favorite folders?
Ans: Both a and b

Ques: Refer to the given image.
When do we use 'then by 'option in the list?
Ans: When we need to sort the record on time basis

Ques: Refer to the given image.
Which of the following options display events and appointments in the month?
Ans: B

Ques: Refer to the given image.
Which icon displays that the message is of high importance?
Ans: B

Ques: Refer to the given image.
Which among the following calendar symbols display data conflict in Outlook?
Ans:  B

Ques: State whether True or False.

Standard Outlook forms' customizations can be programmed by using Microsoft Visual Basic Scripting Edition.
Ans: True

Ques: Which of the following options display the RSS Feeds icon in the given image?
Ans: B

Ques: With which extension is a file saved when you export 'Rules'?
Ans: .VCS

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!

News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance MS-Access Test Question & Answers

UpWork (oDesk) & Elance MS-Access Test Question & Answers

June 28, 2015 / No Comments

UpWork (oDesk) & Elance MS-Access Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: To ensure a value no greater than 30 is entered into a field you would use:

Ans: A validation rule

Ques: The action of typing a record into a database is:
Ans: Data entry

Ques: Why use a database instead of a spreadsheet?
Ans:  Multiple data from various tables are needed.

Ques:  What is a form?
Ans: An Access object where you can enter, edit or display data from a table or query

Ques: Which query can you delete records?
Ans:  Delete Query

Ques: Can a primary key be used as a non-primary key in another table?
Ans:  Yes

Ques: Microsoft Access does not offer parameterized queries.
Ans: False

Ques: Before you split a database, you should:
Ans: Back up the database file

Ques: True or False: You can import an Excel spreadsheet to an Access table.
Ans:  True

Ques: What would Format("210.6", "#,##0.00") return?
Ans:  210.60

Ques: How to you ensure that a field is filled out properly?
Ans: Use a validation rule.

Ques: What is a data type?
Ans: It determines the kind of values users can store in a field

Ques: What happens when you freeze a column?
Ans: It prevents the column from moving positions

Ques: What is a purpose of a report?
Ans: To represent data in a more aesthetic, professional manner

Ques: What would Format("1267.5", "Currency") return?
Ans: $1,267.50

Ques: True or False: You use an AutoNumber data type when you want unique numeric values to be created automatically by Access when you create a record.
Ans: True

Ques:  Which one of these is not a valid database relationship?
Ans: many-to-pair

Ques: What is a drop down list?
Ans:  A way to have a user select from list of values in a table or form.

Ques:  An Access file can import:
Ans: All of these

Ques: Of these, which can comparison operator symbols be applied to?
Ans:  All of these

Ques:   Of these, what could be the purpose for splitting a database?
Ans:  All of these

Ques: How do you sort data in order?
Ans:  All of these

Ques: What kind of relationships can you do in a database?
Ans:  All of these

Ques: How do you save a file?
Ans:  All of these

Ques: When you press the Tab key, which way does the insertion point go?
Ans:   The adjacent field

Ques:  What is a primary key?
Ans: It uniquely identifies each record in a table.

Ques: True or False: You cannot assign a Macro to a Command Button.
Ans:  False

Ques: What is a caption?
Ans: The label for a field when used on a form.

Ques: On the ribbon with the Window tools, how can you view opened queries, tables, and reports?
Ans: All of these

Ques: Can relationships be between primary keys and non-primary keys?
Ans: Yes

Ques:  Where in an Access window can you search for a specific record?

Ans: 2 of these are correct

Ques: Which of these would be a proper way to type a parameter?
Ans: [Where was this shipped to?]

Ques: Why should you enter sample data in tables after creating them?
Ans: To check for potential data maintenance problems

Ques: Name the object that is linked to a table that is used to enter data?
Ans: Form

Ques: What language is used to extend and automate MS Access?
Ans: Visual Basic for Applications

Ques: Which two objects can a report object be based on?
Ans: Table and Query

Ques:When you use the Max function, you are searching for...
Ans: The largest value in a field

Ques: The Input Mask Wizard is used to....
Ans:  Format data being entered into a table

Ques: What type of query is used to show data but that does not alter data on the table?
Ans: Select

Ques: Where can you find the # of results in a Query?
Ans:  Lower left of the screen

Ques: What are relationships for?
Ans: To ensure referential integrity

Ques: What are the 3 buttons for sorting data?
Ans: Ascending, descending, clear all sorts

Ques: How does changing the appearance of a datasheet affect the underlying table structure?
Ans:  It does not change the structure

Ques: Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?
Ans:  Use the Object Dependencies Task Pane

Ques: Choose the correct criteria to enter when prompting a user for the Customer Name in a
Ans: [Enter the Customer Name]
Ques: An Input Mask is:
Ans:

A data pattern which dictates how users can enter data into a field
Ques: Which of these is not a valid aggregate function for a query search?
Ans: Quo

Ques: When you run a query to find records in related tables, Access, by default, uses... an Inner Join
Ans: an Inner Join

Ques:  Can you modify information while viewing a report?
Ans :  No, you can only view information with a report

Ques: The Following statements are all true except:
Ans: You can only have one criterion per line in the design grid

Ques: What does DAO stand for?
Ans: Data Access Object

Ques: What does DAO stand for?
Ans: Data Access Objects

Ques: How do you move to the last record in a table?
Ans: All are correct

Ques: What is an example of a comparison operator symbol?
Ans:  All of these

Ques: You wish to filter data on a report before printing without changing the design of the report. How do you do this?
Ans: In Layout view, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on

Ques: What does a group header or group footer do?
Ans:  Displays the field label of grouped data on the top or bottom of a report

Ques: Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Ans: Datasheet Views cannot have code modules associated with them.

Ques: To adjust the length of fields in a report while displaying data you would use:
Ans:  Layout View

Ques: Which of these can you apply conditional formating to?
Ans: Form

Ques:  To query two tables that are unrelated you:
Ans: Create a junction table which contains fields common to both tables

Ques: You are creating a Macro and you require the SetValue Action, but it does not exist.  What do you do?
Ans: Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon

Ques: What is typically displayed on a Relationship Report?
Ans: The current date and database name

Ques: What would StrConv("Tech on the Net", 3) return?
Ans: Tech On The Net

Ques: You need to create a lookup field where more than one option can be chosen.  Where would you do this?
Ans: In the Lookup Wizard check "Allow Multiple Values"

Ques:  In the design view of a make table query the destination table name is displayed:
Ans: In the propery sheet with selection type query properties.

Ques: When you open an Access Form, what is the second event that fires?
Ans: On Load

Ques: Field selectors are located..
Ans: at the top of a table

Ques: Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
Ans:  255

Ques: The report header displays on:
Ans:  The first page only

Ques:  Which of the following is not included in the Access Built-In Functions for SQL Aggregate
Ans: Median(«expression»)

Ques: What is the "iif" function named?
Ans: Immediate If

Ques: What does ADO stand for?
Ans: ActiveX Data Objects

Ques: Which of the following Access 2010 macro actions does not require you to select "Show All Actions" in order to use it in Macro Design?
Ans:  RunCode

Ques:  A calculated control is one form that uses an expression to generate the data value for the master key of a table
Ans:  False

Ques: "Yes/No" answers in Access are commonly stored as:
Ans:  0 or -1

Ques: When you move between records on an Access Form, which one of the following events fires?
Ans: On Current

Ques: Which of the following is NOT a type of query in Access?
Ans: CrossSelect

Ques:  What is the maximum size of Microsoft Access 2010 database file?
Ans:  2 GB, minus the space needed for system objects

Ques: When do you use the Lookup Wizard?
Ans:  You want to lookup the value of a field from another table or create a list of values to choose from

Ques: Which of the following helps to study the information in a table and then make changes to streamline the data?
Ans: Table Analyzer Wizard

Ques: In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
Ans:  The code continues executing but Access appears to hang.

Ques:  You require a form control that provides a text box to which a drop-down list is attached.  Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?
Ans: Combo Box contro

Ques: What would Mid("Alphabet", 3, 10) return?
Ans:  phabet

Ques: Each sales person has many customers.  Each customer can have many orders.  In building a query for how much in sales a salesperson is generating, what kind of relationship will exist between customer and orders?
Ans: One-to-many

Ques:  What would Replace("alphabet", "bet", "hydro") return?
Ans:  alphahydro

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab