Odesk Readiness Test Questions And Answers April 2012

 Odesk Readiness Test Questions And Answers April 2012

Some oDesk readiness test questions have been changed. Here are the list of odesk latest readiness test answers with questions and alternatives.

The question for each individual is given randomly, but the answers will be as following written as font color red.

Questions :
Which of the following actions are NOT allowed when applying to job postings?

  a. Misrepresenting your skills, experiences, portfolio, etc.
  b. Submitting boilerplate, placeholder or generic bids or other spam
  c. Disclosing direct contact information 
  d. Applying when you are not truly qualified
  e. All of the above 

Which of the following are NOT permitted on oDesk?

  a. Sharing a single account between multiple people
  b. Opening more than one account on oDesk
  c. Using a logo or clip art as your profile portrait
  d. Using a fake name
  e. All of the above 

 Can I start my own agency on oDesk?

  a. Yes! You can create an agency and earn money by selling the services
  of your agency contractors.
  b. No, oDesk is for independent contractors only

 What happens when a contract ends?

  a. You lose access to the Work Diary 
  b. Both users can leave feedback
  c. The feedback system is double blind, so your employer cannot see the feedback you
  left them until after they have left feedback for you
  d. Hours will be billed (and disputes may be filed) according to the usual weekly payment          schedule
  e. All of the above

Which of the following are TRUE about your oDesk Work Diary?

  a. Allows employers to see when and what their contractors are working on
  b. Enables automatic billing for hourly contracts
  c. The oDesk Team application auto-tracks time which can be reviewed in the Work Diary
  d. Manual time can be added, but isn't guaranteed payment
  e. All of the above

 Which of the following are TRUE about the oDesk dispute process?

  a. The dispute process only applies to Hourly contracts 
  b. If you fail to respond, oDesk will refund the employer and suspend your account
  c. If you reject the dispute, oDesk specialists will review your Work Diary and
  evaluate it against the criteria of the payment guarantee 
  d. Disputed hours ruled in the employers favor are refunded
  e. All of the above

  Which of the following is FALSE about weekly limits on hourly contracts?

  a. Hours in excess of the weekly limit will not be billed to the employer 
  b. You should discuss any need to work beyond your limit with your employer
  c. The weekly limit can be changed by the contractor
  d. The weekly limit can be changed by the employer
  e. Hours in excess of the weekly limit are not guaranteed payment

 The oDesk Team application Time Tracker records which of the following.

  a. Screenshot of the active screen once per billing segment
  b. Number of keystrokes
  c. Number of mouse clicks
  d. Memo entered by the contractor
  e. All of the above

 Which of the following statements about oDesk fees is FALSE?

  a. The oDesk fee is 10% of the employer's payment to oDesk 
  b. oDesk is free to join
  c. oDesk is free for contractors to apply and work on jobs
  d. The oDesk fee is $2/hour for hourly contracts
  e. All of the above

 Which of the following is TRUE about fixed-price contracts?

  a. Employer billed automatically each week 
  b. How much to pay and when to pay is at the employer's discretion
  c. Hours worked will show on your profile
  d. Time-tracking required
  e. Qualify for the oDesk payment guarantee

Hope it will help you.

Odesk HTML 4.01 Test Questions And Answers 2013

Odesk HTML 4.01 Test Questions And Answers 2013

 Here are HTML 4.01 Test questions and answers randomly given by odesk. Gope it will help

Question no. 1

Which of the following statements is correct for a blockquote?

a. It make the text a bit bigger for emphasizing.

 b. It defines the start of a long quote.

 c. It makes the text slightly bolder.

Question no. 2

Which of the following is incorrect about the relation between HTML and XHTML?

a. XHTML is a stricter and cleaner version of HTML.

 b. XHTML is almost identical to HTML 4.01.

 c. XHTML and HTML both are used to generate dynamic content.

 d. XHTML brings together the elements of HTML and the syntax of XML.

Question no. 3

Choose the incorrect statement(s):

a. An HTML attribute is additional information included inside a tag.

 b. HTML is case sensitive.

 c. All the HTML4.01 tags must be paired.

 d. Your browser may appear to correctly use newly deprecated code for the present, but its support for deprecated code could be

 halted at any time after the browser is updated.

Question no. 4

Which of the following tags can be used in place of a button tag?

a. legend

 b. ol

 c. input

 d. dlc. input

Question no. 5

Which of the following is not a valid input type of the form tag?

a. checkbox

 b. image

 c. hidden

 d. button

 e. All are valid

Question no. 6

It is not necessary to give the coordinates for an image or object defined within an area tag, if the value of its shape attribute is:

a. circle

 b. poly

 c. default

 d. rect

Question no. 7

Which of the following is/are a valid value for the type attribute of the input tag?

a. text

 b. icon

 c. reset

 d. password

Question no. 8

Which of the following is not correct for an action attribute for a form tag?

a.The action attribute can be defined at runtime.

 b. If the value for action is null (action=""), then the form submits user data to itself.

 c. If the URL is not provided to the action attribute, the form will not submit user data anywhere.

 d. None of the above

Question no. 9

Which of the following values is/are valid for the align attribute of a tag?

a.left

 b.right

 c.center

 d. offset

Question no. 10

What do you infer from the following code? <a href = "http://www.expertrating.com"> Expert Rating

a.This href is using absolute path for linking.

 b. This href is an example of relative path linking.

Question no. 11

Which of the following statements is correct for the tag?

a. The text under block quote must be enclosed in a block level element in a strict DTD document.

 b. The attribute named cite must be specified.

 c. Closing the tag is optional.

 d. It places an empty line after the text.

()

Question no. 12

Which of the following is/are not true for a paragraph tag in HTML 4.01?

a. The text must be enclosed in <p> and </p> tags.

 b. It creates an empty line above its starting line.

 c. It cannot be used within a <td> tag.

 d. It creates an empty line after its ending line.

Question no. 13

A piece of text contains many blank spaces within it. Which of the following tags would be suitable to display the text as it was originally formatted?

a. td

 b. p

 c. ls

 d. pre

Question no. 14

You are creating several web pages for a website that contain several rather large data tables, many of which are somewhat similar in the number of columns, rows, and in other common table formatting. In addition, CSS will be employed for formatting the tables. Which one of the following types of CSS has the highest priority over the others and typically requires the greatest total amount of code space for the entire website for formatting the various <td> table cells?

a. External style sheet

 b. Inline style

 c. Internal style sheet

 d. Browser default

Question no. 15

Which of the following attributes is/are related to the <img> tag?

a. height

 b. alt

 c. src

 d. All of the above

Question no. 16

The following link is placed on an HTML webpage.

 <a href="http://msdn.com/" target="_blank"> MSDN </a>

 What do you infer from it?

a. It will open the site msdn.com in the same window.

 b. It will open the site msdn.com in a new window.

 c. It will open the site msdn.com in a frame below.

 d. It will not be clickable as it is not formed correctly.

Question no. 17

Is the following code valid in HTML 4.01 Strict?

 <ul><li><ol><li>A</li><li>B</li><ul><li>Item1</li><li>Item 2</li></ul><li>C</li></ol></li></ul>

a. Perfectly valid.

 b. Invalid because you should not have three levels of nesting in the lists.

 c. Invalid because you should not have an unordered list within an ordered list.

 d. Invalid because a <ul> tag should not conflict with an <ol> tag at the same list level.

Question no. 18

Which of the following values for the scrolling attribute for the frame tag is not valid?

a. yes

 b. default

 c. auto

 d. no

()

Question no. 19

Which of the following is/are not correct for a <meta> tag in HTML 4.01?

a. It is more useful if it is placed in a head element.

 b. It can be used to specify the keywords for the search engines.

 c. It can be used to redirect users to other URLs.

 d. It is mandatory to specify its name or scheme attributes.

Question no. 20

The tag that is used to pass the parameters to an applet is:

a. appletpar

 b. applet

 c. param

 d. val

Question no. 21

Which of the following attributes is/are valid for a select tag contained within a form tag?

a. name

 b. size

 c. multiple

 d. All of the above

Question no. 22

For the following items of a <select> list:

 <option value="89">Item 1</option>

 <option value="90">Item 2</option>

 Which of the following values would be passed on by clicking the submit button on selecting Item 2 from the list?

a. 89

 b. 90

 c. Item 1

 d. Item 2

Question no. 23

You have to add a list of products in a drop-down list. What will you use to group the identical products under a category name?

a. optgroup

 b. option

 c. menu

 d. var

 e. There is no way to do this

Question no. 24

Which of the following shows the basic tag structure of an HTML document?

a. <html><head><body></body></html>

 b. <html><body></body></html>

 c. <html><head></head><body></body></html>

 d. <html><head></head></html>

Question no. 25

You want to provide a form field to the users for writing lengthy comments on the quality of the services provided by you. Which of the following tags will you use?

a. <textarea rows="8" cols="20"> Your Comments.... </textarea>

 b. <textarea row="8" col="20"> Your Comments.... </textarea>

 c. <textarea rowcount="8" colcount="20"> Your Comments.... </textarea>

 d. <input type="text" maxlength="100"/>

Question no. 26

Which of the following set of coordinate values refers to an image defined by the area tag with the value of poly for its shape attribute?

a. coords="150,217,190,257,150,297,110,257"

 b. coords="150,190,150,110"

 c. coords="150,217,190,257,150"

 d. coords="150,110,190,220,150,150,120"

Question no. 27

What is meant by the cellspacing attribute?

a. It makes the cell span more than one column.

 b. It specifies the space between the cell wall and the contents of the cell.

 c. It specifies the space between two cells.

 d. It makes the cell span more than one row.

Question no. 28

Which of the following attributes comes in handy when borders have to be put between groups of columns instead of every column?

a. col

b. colgroup

 c. rowspan

 d. row

Question no. 29

A few lines in an HTML paragraph are to be formatted differently from the rest of the lines. Which tag will assist in this?

a. div

 b. p

 c. span

 d. format

Question no. 30

How will you specify a comment in an HTML document?

a. <!!- Here is a comment... -!>

 b. <-Here is a comment.. ->

 c. <!-- Here is a comment.. -->

 d. <! Here is a comment... -!>

Question no. 31

Which of the following is correct regarding the frame attribute in the <table> tag?

a. It is used to add a frame to the table.

b. A hsides value for the frame attribute will show the border lines for horizontal sides only.

 c. A hsides value for the frame attribute will not show the border lines for horizontal sides only.

 d. A hsides value for the frame attribute will add a scrollable frame on the horizontal sides.

Question no. 32

What is meant by cellpadding?

a. It makes the cell span more than one column.

b. It specifies the space between the cell wall and the contents of the cell.

 c. It specifies the space between two cells.

 d. It makes the cell span more than one row.

Question no. 33

Within a table cell <td>:

a. <p></p> tags cannot be used.

 b. <ol></ol> tags cannot be used

 c. <table></table> tags cannot be used.

 d. <form></form> tags cannot be used.

e. All the above tags could be used.

Question no. 34

A developer wrote this image tag:

 <img src ="states.gif" width ="330" height ="406" alt="States"

 usemap ="#statemap" />

What code should follow this?

a. <map id ="statemap" name="statemap">

 <area shape ="rect" coords ="0,0,82,126" href="state1.htm"

 alt="State1" />

 </map>

 b. <map id ="statemap" name="statemap"> </map>

 <area shape ="rect" coords ="0,0,82,126" href="state1.htm"

 alt="State1" />

 c. <map id ="statemap" name="statemap">

 <img area shape ="rect" coords ="0,0,82,126" href="state1.htm"

 alt="State1" /> </map>

 d. <map id ="statemap" name="statemap">

 <img area shape ="rect" coords ="0,0,82,126" href="state1.htm"

 alt="State1" /> </map>

()

Question no. 35

You want to display a table listing out customer names and their contact information. The heading of the table is shown in the figure. What is the code for creating the first line of the table heading?

a. <tr>

 <th>Customer Name</th>

 <th colspan=3>Contact</th>

 </tr>

 b. <tr>

 <th>Customer Name</th>

 <th cellpadding=3>Contact</th>

 </tr>

 c. <tr>

 <th>Customer Name</th>

 <th rowspan=3>Contact</th>

 </tr>

 d. <tr>

 <th>Customer Name</th>

 <th cellspacing=3>Contact</th>

 </tr>

<tr> <th>Customer Name</th> <th cellpadding=3>Contact</th> </tr>

Question no. 36

What would you infer from the following code in an HTML 4.01 Web site? <body topmargin=2 leftmargin=2>

a. The top margin and left margin of the webpage is 2 pixels.

 b. The bottom margin and right margin of the web page is 2 pixels.

 c. Both of the above.

 d. None of the above. The topmargin and leftmargin attributes are not valid HTML 4.01 body attributes.

Question no. 37

You specified a base tag and anchors as follows:

 1. <base target="_blank">

 2. <a href="http://www.yahoo.com">Yahoo</a>

 3. <a href="http://www.google.com" target="_top">Google</a>

 Which of the following is true for the above code?

a. Only the Yahoo link will open in a new window.

 b. Only the Google link will open in a new window.

 c. Both links will open in a new window.

 d. Both links will open in the same window.

Question no. 38 On one of your Web pages named Listing.html, you specified a target like this:

 <a name="target4">Old Listing</a>

 How will you make a link to the above target?

a. <a url="#target4">Check Old Listing as well</a>

 b. <a href="#target4">Check Old Listing as well</a>

 c. <link url="target4">Check Old Listing as well</link>

 d. <a href="Listing.target4">Check Old Listing as well</a>

Question no. 39 Which attribute specifies the submit URL in a form tag?

a. method

 b. action

 c. name

 d. id

Question no. 40 The tag which is used to show monospaced text is:

a. <td>

 b. <th>

 c. <tt>

 d. <b>

Odesk U.S. English Basic Skills Test 2013

 Odesk U.S. English Basic Skills Test  2013

Here are questions and answer which will guide when you took  U.S. English Basic Skills Test in odesk. Hope this help.

Q: Choose the series of pronouns that best completes the following sentence.
 _______ is the name of the opera, and ______ role did you say Maria would pay?
 Ans: c (what, which)

 Q: Read the following question and choose the response that uses the correct corresponding verb tense.
 Ans: a (No, because by the time I got there all the tickets had already been sold.)

 Q: Choose the phrase that best completes the sentence below without creating a run-on sentence.
 It’s never too late to learn how to swim ______ you may fall off a boat!
 Ans: b (you never know when)

 Q: Choose the series of verbs and phrases that best completes the following passage.
 This dish ______ too spicy. Why _______ so much pepper?
 Ans: e (a and c)

 Q: Rearrange the following words to create the most logical and grammatically correct sentence.
 With can’t phone, on whenever always to the time spend I speak I my friend, him
 Ans: e (Whenever I can’t spend time with my friend. I always speak to him on the phone.

 Q: Read the following question and choose the response that uses the correct corresponding verb tense.
 Did you hear the weather report for tomorrow?
 Ans: b (No, I wasn’t listening to the radio.)

 Q: Choose the series of pronouns that best completes the following sentence.
 Victor, who stole ______ ideas and used them to make ______ a millionaire, never once offered ______ a word of thanks.
 Ans: d (our, himself, us)

 Q: Which of the following sentences illustrates correct verb and verb tense usage?
 Ans: e (All of the above)

 Q: Choose the series of adjectives and adverbs that best completes the following sentences.
 While ______ of our relatives live on the _______ hill in the country, ______of our friends live in the ________ area of the valley.
 Ans: c (many, windiest, most, protected)

 Q: Choose the series of adjectives and adverbs that best completes the following sentence.
 Knowing that February was the ______ month of the year, Cheryl planned her vacation ________.
 Ans: b (shortest, accordingly)

 Q: Choose the phrase that best completes the sentence below without creating a run-on sentence.
 Mr. Peach has sent his four children to lvy league colleges _______ he has sacrificed his health working day and night dusty factory.
 Ans: b (; however)

 Q: Choose the series of adjectives and adverbs that best completes the following sentences.
 I think Pamela deserves to be punished for her _______ stupid and ______ behavior.
 Ans: c (total, irresponsible)

 Q: Choose the series of verbs that best completes the following sentences.
 If Harry  ________ to the party too early, don’t let him in; he ________ outside like everyone else.
 Ans: a (gets, will have to wait)

 Q: Which of the following sentences illustrates the proper use of parallel construction?
 Ans: b (Although Tommy was failing his biology class at college, he was passing his chemistry class)

 Q: Which of the following sentences illustrates the proper use of apostrophes?
 Ans: a (Helga borrowed her friend’s skates for the day; however, she failed to return them.)

 Q: Change the following sentences from a question to indirect speech.
 “I will be moving soon.” said Alma
 Ans: d (Alma says she would move soon.)

 Q: Choose the series of verbs that best completes the following sentences.
 Alison regrets _______ you with her remarks; she never meant ______ so.
 Ans: b (to hurt, to do)

 Q: Choose the series of pronouns that best completes the following sentences.
 Don’t ______ think Larry should call ________ wife if _______ is going to be late for dinner?
 Ans: a (you, his, he)

 Q: Which of the following sentences illustrates correct pronoun usage?
 Ans: e (None of the above)

 Q: Complete the following sentences by choosing the phrase with the best word order from the option given.
 Only after they had completed an exhaustive study  ________ how to adapt the technology to the needs of our company.
 Ans: c (they did begin to understand)

 Q: Rearrange the following words to create the most logical and grammatically correct sentence.
 days . for last has good weather few The been the not
 Ans: d (The weather has not been good for the last few days)

 Q: Choose the series of prepositions that best completes the following sentence.
 I placed my notes ______ my desk and referred to them ______ the meeting.
 Ans: b (beside, during)

 Q: Which of the following sentences illustrates correct pronoun usage?
 Ans: e (all of the above)

 Q: Which of the following sentences illustrates proper sentence structure?
 Ans: d (The queen had hardly finished her speech when the people began to disperse.

 Q: Which of the following sentences is punctuated correctly?
 Ans: d (“Come here,” she said, “and let me get a good look at you.”)

 Q: Complete the following sentence by choosing the phrase with the best word order from the option given.
 Those who are not wise  _________.
 Ans: d (does not need to be necessarily stupid)

 Q: Read the following question and choose the response that uses the correct corresponding verb tense.
 Does Jack wear that furry hat often?
 Ans: d (No, he only wears it when his ears are cold.)

 Q: Choose the series of prepositions that best completes the following sentence.
 Charlotte knew ________ the secret investigation ________ her past, but she closed her eyes to it and pretended it happening.
 Ans: a (of, about)

 Q: Choose the series of adjectives and adverbs that best completes the following sentence.
 The archaeologists were ______ to discover such a ________ and _______ _________ artifact at that mostly uncovered site.
 Ans: b (amazed, rare, incredibly, beautiful)

 Q: Choose the series of verbs that best completes the following sentence.
 Everyone ________ too busy cooking and _______ the family of bears _______ from woods.
 Ans: d (was, setting up, to notice, watching)

 Q: Choose the series of articles and conjunctions that best completes the following sentence.
 Julia, who is studying to be ________ foreign correspondent, is currently doing ______ internship in ______ Middle East _____ will return before the end of _______ year.
 Ans: a {(no article required), an, the, but, the}

 Q: Which of the following sentences is punctuated correctly?
 Ans: b (We are expecting a hurricane this afternoon; therefore we have closed the school early.)

 Q: Which of the following sentences illustrates the proper use of commas?
 Ans: e (a and b)

 Q: Change the following sentence from a quotation to indirect speech.
 Rhonda says, “I get to work early every day.”
 Ans: c (Rhonda has said that she got to work early every day.)

 Q: Which of the following sentences does not illustrates correct pronoun usage?
 Ans: e (all are correct)

 Q: Which of the following sentences illustrates correct verb and verb tense usage?
 Ans: b, d {(We think the judge will have noticed something strange in her behavior.), (Somehow, all of the newspapers gotten hold the story.)}

 Q: Rearrange the following words to create the most logical and grammatically correct sentences.
 Last what ! It’s did you night, over After
 Ans: b (After what you did last night, it’s over!)

 Q: Change the following sentence from a quotation to indirect speech.
 “It may snow tomorrow,” He said.
 Ans: d (He said it might snow tomorrow.)

 Q:Choose the series of adjectives and adverbs that best completes the following sentence.
 The helium _______ balloon rose ________ into the air; the villagers knew then their _______ leader was off on another mission.
 Ans: c (powered, powerfully, powerful)

 Q: Rearrange the following words to create the most logical and grammatically correct sentences.
 Would I have it anything if had, I you known said would not bother
 Ans: b (I would not have said anything if I had known it would bother you)

Odesk Microsoft Excel 2010 Test Answers 2013

Odesk Microsoft Excel 2010 Test Answers 2013

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

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

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

Question: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?
c. Change chart type to a line chart and type all the values into an Excel file.

Question: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?
b. Square

Question: 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?
b. Tables with maximum number of rows and columns was added to the document.

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

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

Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a.       Open Type fonts

Question:With which chart type(s) is the "Depth Gridlines" option available?
b.      Line chart

Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c.       MDI

Question: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?
d.      XLS

Question:What view must be used when inserting a subdocument?
b. Web Layout

Question: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?
c. By using the Recolor option under Format Picture.

Question: Which of the following in NOT a type of Section Break?
d. Continuous

 Question:  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.
c. Orientation

Question: 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?
b.      Insert Flowchart             

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

Question:  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?
a. "Allow row to break across pages" is unchecked.

oDesk Readiness Test for Independent Contractors and Staffing Managers 2013

oDesk Readiness Test for Independent Contractors and Staffing Managers 2013

Q: Which of the following is TRUE about fixed-price contracts?
Answer: b (How much to pay and when to pay is at the employer's discretion)

Q: Which of the following statements about oDesk fees is FALSE?
Answer: (d) The oDesk fee is $2/hour for hourly contracts

Q: The oDesk Team application Time Tracker records which of the following
Answer: (e) All of the above     

Q: Which of the following is FALSE about weekly limits on hourly contracts?
Answer (c) The weekly limit can be changed by the contractor

Q: Which of the following are TRUE about the oDesk dispute process?
Answer (e) All of the above

Q: Which of the following are TRUE about your oDesk Work Diary?
Answer (e) All of the above 

   
Q: What happens when a contract ends?
Answer (e) All of the above 

    
Q: Can I start my own agency on oDesk?
Answer (a) Yes! You can create an agency and earn money by selling the services of your agency contractors.

Q: Which of the following are required to qualify for guaranteed payment?
Answer (e) All of the above

            
Q: Which of the following actions are NOT allowed when applying to job postings? 
Answer (e) All of the above

                 
Q: Which of the following are NOT permitted on oDesk?
Answer (e) All of the above

oDesk MS Word 2007 Test Answers 2013

oDesk MS Word 2007 Test Answers 2013

1.  Which among the following methods would you select when you want to add protection to parts of a template?
Ans:  Go to the Developer tab, click on Properties in the Controls group and then click any of the Locking options in the Content Control Properties dialog box.

2. Which of the following is/are true about phishing?
Ans: All if the above

3. This question is based upon the figure shown below

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

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

5. Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: Linked



6. This question is based upon the figure shown below

 Ans: It ensures that the text is not obscured by binding.

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

8. This question is based upon the figure shown below

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.
9. Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author

10.  This question is based upon the figure shown below

 Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: This option allows you to remove the Page Number from the first page.

11. 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

12.  This question is based upon the figure shown below

Which of the following types of charts are not supported by either Lines or Bars, as shown in the picture?
Ans: Area charts

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

14. 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.

15. 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.

16. 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.

17. 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...

18. 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

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

20. 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.

21. This question is based upon the figure shown below

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: Restart Each Page

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

23. 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

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

25. 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

26. 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

27. 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.

28. Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Doubled

29. How will you change the author name in an existing document?
Ans: All of the above

30. 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

31. Which among the following options could be used to turn off the Office Clipboard?
Ans: All of the above

32. 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.

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

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

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

36. Which among the following wildcards should be used to select any single character?
Ans: ?

37.  This question is based upon the figure shown below

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

Ans: C

38. Which of the following is not a Content Control?
Ans: Chart

39. This question is based upon the figure shown below

Ans: Numbering

40. 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.

41.  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.

 42.

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

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

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

45. 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.


46. Which of the following options repeats a table heading on subsequent pages?
Ans: Repeat Header Rows

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

48. Which among the following is not true regarding the use of a pie chart?
Ans: A pie chart should be used when there are more than seven categories.

49. This question is based upon the figure shown below

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

50. 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: False

51. This question is based upon the figure shown below

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

52.  This question is based upon the figure shown below

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.

53.  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)

54. This question is based upon the figure shown below

 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.

55. 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

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

57. 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: False

58. This question is based upon the figure shown below

 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.

59. Which feature(s) should be selected in order to find and remove hidden data and personal information in Office documents?
Ans: Document Inspector

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

61.  Which among the following options will you use to add a command to the Quick Access Toolbar?
Ans: All of the above

62. Which option(s) should you select to remove a chart or axis title from a chart?
Ans: To remove an axis title, select the Layout tab. In the Labels group, click on Axis Titles, click the type of axis title, and then click None.

63.  Which among the following macro settings is meant for developers only?
Ans: Trust access to the VBA project object model.

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

65. Which of the following is/are true about phishing?
Ans: It is an online fraud technique used by criminals to lure users into disclosing their personal i

oDesk MS Excel 2007 Test Answers 2013

oDesk  MS Excel 2007 Test Answers 2013

Question:1
Refer to the given image. Which line style option should be used to specify the style used for the end of the line?

a. A
b. B
c. C
d. D


Question:2
Which keyboard shortcut should be used to enter the current time?

a. CTRL+SHIFT+"
b. CTRL+SHIFT+:
c. CTRL+;
d. None of the above


Question:3
What does the screen tip displaying "Showing All" mean?

a. It means that a Filter has been applied
b. It means that Filtering has been enabled but not applied
c. It means Excel does not support such a Filter
d. None of the above

Question:4
State whether true or false:

When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

a. True
b. False


Question:5
Which of the following charts have no axes?

a. Doughnut charts
b. Pie charts
c. Both a and b
d. None of the above

Question:6
How would you locate the last cell on a worksheet?

a. Click anywhere in the worksheet, and then press CTRL+HOME
b. Click anywhere in the worksheet, and then press CTRL+INSERT
c. Click anywhere in the worksheet, and then press CTRL+END
d. None of the above


Question:7
What is the purpose of using the Keep text flat option, as shown in the picture?



a. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
b. It prevents the text from blurring
c. It moves the WordArt or text backward
d. Both b and c


Question:8
How will you reverse the direction of a SmartArt graphic?

a. Right-click on the SmartArt graphic, select Reverse
b. Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
c. Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
d. All of the above


Question:9
Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?

a. A
b. B
c. C
d. D


Question:10
Which part of the formula displays references in the given picture?

a. A
b. B
c. C
d. D


Question:11
Which of the following wildcard characters can be used as comparison criteria for Text Filters?

a. ?
b. *
c. ~
d. All of the above


Question:12
How can a chart be modified?

a. By modifying a legend
b. By modifying the display of chart axes
c. By modifying titles and data labels
d. All of the above


Question:13
Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?


a. CTRL+ALT+F10
b. CTRL+SHIFT+ALT+F9
c. SHIFT+F9
d. None of the above


Question:14
State whether true or false:

A Macro project can be digitally signed.

a. True
b. False


Question:15
How would you select an entire PivotTable report?

a. On the Home tab, in the Editing group, select the 'Entire PivotTable' option
b. On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
c. On the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option
d. None of the above


Question:16
When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?

a. It displays the prompt box and asks the user to type 'a' or 'p'
b. It displays an error message
c. It enters the time as PM
d. It enters the time as AM
e. None of the above


Question:17
How would you assign a Macro to a graphic?

a. On the Developer tab, in the Controls group, select Macro name
b. On the View tab, click on Macros and then click 'Assign Macro' on the shortcut menu. In the Macro name box, click on the macro that you want to assign
c. On a worksheet, right-click on the graphic, then click 'Assign Macro'" on the shortcut menu. In the Macro name box, click on the macro that you want to assign
d. All of the above



Question:18
Which of the following is not a valid file extension in which an Excel file can be saved?

a. XLSB
b. XLSM
c. PXL
d. All of the above are valid


Question:19
Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?



a. A
b. B
c. C
d. D


Question:20
Which of the following options is not available on the Status bar?

a. Cell mode
b. Selection mode
c. End mode
d. Start mode



Question:21
Which of the following is not true regarding naming a cell?

a. Names are case sensitive
b. A name can contain up to 255 characters
c. Names can contain uppercase and lowercase letters
d. Some keyboard characters can cause unexpected results if used in cell names


Question:22
What is the option on the Document Inspector that finds the content type information?

a. Comments and Annotations
b. Headers and Footers
c. Document Properties and Personal Information
d. Hidden Rows and Columns


Question:23
Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

a. By selection
b. By corresponding field
c. By value field
d. By number field


Question:24
State whether true or false:

No data is deleted when an outline is hidden or removed.

a. True
b. False

Question:25
Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

a. HLOOKUP
b. VLOOKUP
c. TRANSPOSE
d. None of the above


Question:26
Which of the following methods would you follow to remove subtotals?

a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
b. On the Data tab, in the Data Tools, select Remove Subtotals
c. Both a and b
d. None of the above


Question:27
Refer to the given image. What is the purpose of the cell denoted as 'A' in the worksheet?


a. It selects all the cells in the worksheet
b. It selects a large range of cells in the worksheet
c. It selects non-adjacent cells in the worksheet
d. It selects an entire row in the worksheet


Question:28
Which of the following is not true about an offline cube file?


a. It stores data in the form of an OLAP cube
b. The file format for an offline cube file is .CUE
c. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable


Question:29
Which of the following options would you choose to clear a PivotChart report?


a. On the Analyze tab, in the Data group, click on Clear, and then click 'Clear All'
b. On the Options tab, in the Actions group, click on Clear, and then click’ Clear All'
c. Both a and b
d. None of the above


Question:30
State whether true or false:
Case-sensitive sorting of text in Excel2007 can be performed.

a. True
b. False


Question:31
State whether true or false:

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

a. True
b. False


Question:32

Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

a. Scoping by selection
b. Scoping by corresponding field
c. Scoping by value field
d. All of the above


Question:33
State whether true or false:

If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

a. True
b. False


Question:34
State whether true or false:

When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.

a. True
b. False


Question:35
Which of the following is not true regarding column width?

a. If the column width is set to 0, the column is hidden
b. A column width between 0 to 255 can be specified
c. The default column width is 8.43 characters
d. All of the above are true


Question:36
Where can the 'Show All Comments' command be found?

a. On the Page Layout tab
b. On the View tab
c. On the Review tab
d. All of the above


Question:37
When does the triangle appear in the top-left corner of the cell, as shown in the picture?



a. When the cell contains hidden information
b. When the cell contains the Time function
c. When there is an error in the formula
d. None of the above


Question:38
How should blank cells be inserted on a Worksheet?

a. Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'
b. Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
c. Both a and b
d. None of the above


Question:39
Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.

a. A
b. B
c. C
d. D


Question:40
When would the data validation command be unavailable on the data tab?

a. When an Excel table is linked to a SharePoint site
b. When data in a cell is entered
c. When the workbook is shared or protected
d. All of the above