oDesk Microsoft Excel 2010 Test Answers

Q: figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?

Ans:It copies the formatting properties from one cell to another

Q:The figure shows the AutoFit Selection menu option. What function does it perform?

Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Q:How does the AutoComplete feature in Excel help you save time?

Ans:It automatically completes abbreviated words

Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Ans:It is used to add a hyperlink

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans:Apply the Text Format to empty cells, and then type the numbers

Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans:A_B

Q:How can you select all the blank cells in your worksheet?

Ans:This must be done manually as it is not automated through any built-in feature

Q:What is the quickest way to select all the columns on a worksheet?

Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Q:Which of the following functions would return a value of 8?

Ans:b and c

Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans:3 new rows will be inserted after row 9

Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?

Ans:It inserts a Diagram or Organization Chart in the worksheet

Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Ans:TRUE

Q: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

Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans:DATEVALUE

Q: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

Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?

Ansna

Q:Which of the following function you will use to find the highest number in a series of numbers?

Ans:MAX(B1:B3)

Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans:Date

Q:You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans:b

Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans: na

Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans:true

Q:What does the NOW() function returns?

Ans:Returns the serial number of the current date and time



Q:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans:Hold down the CTRL key during startup

Q:Which toolbar is shown in the figure?


Ans:Forms toolbar

Q:When you clear the contents from a cell, the formatting of the cell is also lost.

Ans:FALSE

oDesk English Vocabulary Test 2012 (U.S Version) Answers

Question: Choose the word or phrase that is most nearly an antonym of the word below.
MITIGATE

c. Intensify

 Question: Choose the word that best corresponds with the definition given below.
v. To impose with authority; urge strongly
 a. Enjoin

 Question: Choose the word that best corresponds with the definition given below.
v. To issue a vehement verbal attack; to denounce explosively

c. Fulminate

 Question: Complete the following sentence by choosing the correct set of words from the options below.
It's a good thing you're so________ at paperwork, because you'll need to fill out hundreds of forms to________ a child.

c. adapt/adopt

Question: Choose the word that best corresponds with the definition given below.
n. Flair; style; a flamboyant manner
c. Resonance

 Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The mysterious message Claude received could be a HARBINGER of what's in store for him and his family.

b. Omen; forerunner

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
Roger might be more AMENABLE to your ideas if you presented them without sneering.
 b. Willing to accept

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
The coach was absolutely disgusted by his team's INDOLENCE and nasty attitude. wizened
 c. Laziness

Question: Choose the word or phrase that is most nearly an antonym of the word below.
REFUTE
b. Support

Question: Choose the word or phrase that is most nearly an antonym of the word below. deleterious
INORDINATE
a. Reasonable

11. Question: Complete the following sentence by choosing the correct homophone from the options below.
Oscar, who did not possess a discerning_________ , preferred hot dogs to steak.
b. pallet

 Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The journalist denied that he had any PRURIENT interest in the politician's private life, but his titillating articles seemed to indicate otherwise.

 b. Overly curious about the sexual behavior of others

 Question: Choose the word that best corresponds with the definition given below.
adj. Tending to create ill will or give offense
 b. Invidious

Question: Complete the following sentence by choosing the correct set of words from the options below.
I can_________ all the terms of the apartment lease_________ the one about not allowing pets.
 d. accept/except

 Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The recent shenanigans in the town square went against all PRECEPTS of decency.
 a. Rules for action or behavior

Question: Choose the word or phrase that is most nearly an antonym of the word below. adverse
ITINERANT

 a. Permanent

 Question: Complete the following sentence by choosing the correct homophone from the options below.
The company is__________ committed to developing educational television programs for children.
 c. wholly

Question: Complete the following sentence by choosing the correct set of homophones from the options below.
The_________ poet, knowing his death was__________ , struggled to finish his final ode.

d. eminent/imminent

Question: Complete the following sentence by choosing the correct set of homophones from the options below.
Rachel knew that she'd soon be living in______________ circumstances unless she got her financial problems________________ out
immediately.
 b. straitened/straightened

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The plots of all her novels just seem to MEANDER along, to the point where I can't follow the storyline or figure out who's who.
 a. Purposely confuse

21. Question: Complete the following sentence by choosing the correct word from the options below.
The only________________ difference between the twins is the shape of their noses.
 b. distinguished

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
Now that the festivities have ended, perhaps we can return to some SEMBLANCE of normality.
 c. Outward appearance

Question: Choose the word that best corresponds with the definition given below.
adj. Narrow-minded; limited in scop

 d. Sectarian

Question: Complete the following sentence by choosing the correct homophone from the options below.
That grueling competition really tested the____________ of the gymnastics team.
 b. metal

Question: Choose the word that best corresponds with the definition given below.
Capacity for producing a desired result; effectiveness
 d. Efficacy

Question: Complete the following sentence by choosing the correct set of words from the options below.
Although_________ wanted to keep the boat all to_________ , I knew it would be used extensively by both Susan and________________ .
 d. I/myself/me

 Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
Poverty is RIFE in the rural areas of our county, where one in three families receives some state assistance. RIFE
a. Prevalent

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The exchange student was disheartened by the rather BRUSQUE welcome she received from her host family.

c. Blunt or rude in manner of speech

Question: Complete the following sentence by choosing the correct set of words from the options below.
The workers were allowed to___________ down once they'd________ the brick, but the foreman himself has not yet_________
down.
 d. lay/laid/laid

 Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
Alec has always been CONTEMPTUOUS of his fellow writers.
 a. Disdainful

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
Maude managed to sweep up the broken dishes without a word of REPROOF to her children.
 a. Expression of disapproval or blame

Expression of apology or regret

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
The despot's MINIONS were only too eager to tout his edicts and report any unrest among his subjects.
 a- Sycophants; servile followers

 Question: Choose the word or phrase that is most nearly an antonym of the word below.
AVARICE
d. Generosity

Question: Complete the following sentence by choosing the correct word from the options below.
The crafty spy gave a___________ name to the hotel clerk.
 c. fictitious

 Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
The soldier's EXEMPLARY conduct did not go unnoticed by his sergeant.
Admirable

 Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
She always got a VICARIOUS thrill from watching her father skydive.
 d. Sickening

Question: Complete the following sentence by choosing the correct word from the options below.
The proposed after-school tutoring program promises_____________ benefits to the students and the community.

 a. innumerable

Question: Complete the following sentence by choosing the correct word from the options below.
I screamed as the monstrous presence snaked toward me on the dark and_________ path.
 b. tortuous

Question: Complete the following sentence by choosing the correct homophone from the options below.
We all remarked on how well the spray of begonias____________ her hair color.
 a. complimented

 Question: Complete the following sentence by choosing the correct set of words from the options below.
She hastened to_________ me that she intends to pay the bill, and that she will_________ that the check is mailed today.
 a. assure/ensure

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
The soldier's EXEMPLARY conduct did not go unnoticed by his sergeant.
 c. Admirable

 Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
His son's group of friends had a DELETERIOUS effect on his schoolwork.

d. Harmful

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
It would BEHOOVE you to show a little more respect to the judge and jury who are deciding your case.

c. Be worthwhile or proper for; be incumbent upon

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
Running around barefoot in the snow will only EXACERBATE your flu symptoms.
 b. Aggravate; worsen

 Question: Choose the word that best corresponds with the definition given below.
n. A mass or crowd; multitude
 c. Horde

Question: Choose the definition that best reflects the meaning of the word in CAPITAL LETTERS as it is used in the sentence below.
Dan was a nice guy, but he was far too GARRULOUS and tended to monopolize people at parties.

 c. Excessively talkative about trivial topics

Question: Choose the word that best corresponds with the definition given below.
adj. Similar to something else in certain respects, as in form, function, or meaning

c. Analogous

 Question: Choose the word that best corresponds with the definition given below.
adj. Hardhearted; unmoved by pity
 b. Parsimonious

 Question: Choose the word or phrase that is most nearly an antonym of the word below.
ADVERSE
 d. Twisted

 Question: Complete the following sentence by choosing the correct homophone from the options below.
Who has the power to_________ out justice to the citizens of this country?
 a. meet

Question: Choose the word that best corresponds with the definition given below.
adj. Easily provoked to anger; irritable

a. Sapid

Question: Choose the word that best corresponds with the definition given below.
n. Flair; style; a flamboyant manner
 c. Resonance

 Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
Agatha RUMINATED for weeks about the consequences of telling Arthur about the affair.
a. Pondered

Question: Complete the following sentence by choosing the correct homophone from the options below.
This experiment was designed to __________ certain behaviors from the test subjects.
  a. illicit

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
It seems we've reached an IMPASSE in our negotiations.
d. Stalemate

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
The WIZENED old woman gave Jack a handful of beans and some good advice.
 b. Shriveled

Question: Choose the word that best corresponds with the definition given below.
n. A position that entails little work but provides a salary
d. Sinecure

Question: Complete the following sentence by choosing the correct set of words from the options below.
Mr. Winkle was dismayed to discover that his willful young wife________ her wealth and__________ the law at every
opportunity.
  c. flaunted/flouted

Question: Complete the following sentence by choosing the correct word from the options below.
She launched her new line of handbags________ a fanfare of publicity.
c. among

 Question: Choose the word that best corresponds with the definition given below.
n. Local or provincial dialect
b. Patois

Question: Choose the word or phrase that is most nearly a synonym for the word in CAPITAL LETTERS in the following sentence.
She entered the ballroom on the arm of a DEBONAIR young man.
  d. Charming and elegant

 Question: Complete the following sentence by choosing the correct word from the options below.
We expected the waiter to show us out of that snooty restaurant in a hurry, but he turned out to be quite jolly and ____
  c. complaisant

oDesk 2012 readiness test answer

which of the following are TRUE about the odesk dispute process?
answer:   all of the above

which of the following are TRUE work diary?
answer:   all of the above


which of the following is FALSE about weekly limits on hourly contracts?
answer:   the weekly limit can changed by the contractor

what happens when a contact ends?
answer:   all of the above

can i start my own agency on odesk?
answer:   yes! you can create an agency and earn money by selling the services of your agency contractors

which of the following are requred to qulify for  gurantee payment
answer:   all of the above


which of the following action are NOT allowed when appplying to job posting?
answer:   all of the above

which of the following are not permitted on odesk?
answer:   all of the above

which of the following is true about fixed price contract?
answer:   how much to pay and when to pay is at the employer' discretion

which of the following stament about odesk fees is FALSE?
answer:   the odesk fee is$2/ hour for hourly contracts

the odesk team application time tracker record which of teh following
answer:   all of the above

how does feedback work in odesk?
answer:   all of the above

which of the following brak the odesk user agrement?
answer:   all of the above