-How to pass the U.S. Word Usage Test 2012

Hi. in this tutorial i will show ou how to pass the odesk U.S. Word Usage Test 2012.

 Question1:
The word "______________" means to convey an additional, nuanced meaning of a word, whereas the word "______________" specifies the literal meaning of a word or phrase.


    a.     denote / connote
    b.     connote / denote

the answer is:    a.     denote / connote       
----------------------------------------------------------------------------------------------------------------------------------
 Question2:
From the options below, choose the correct preposition to complete the underlined prepositional idiom in the following sentence.

Fred is always willing to help out, and that's something you can bank ____________.


    a.     at
    b.     on
    c.     off
    d.     with
    e.     No preposition is needed

the answer is:    c.     off        ----------------------------------------------------------------------------------------------------------------------------------
 Question3:
Complete the following sentence by choosing the correct word from the options below.

Amanda was adamant about having no ____________ than three hundred people at her wedding, but also insisted on having much _____________ space for silly dances.


    a.     less / fewer
    b.     less / less
    c.     fewer / fewer
    d.     fewer / less
    e.     Both b and d may be used.
    f.     Both a and c may be used.

the answer is:    b.     less / less        ----------------------------------------------------------------------------------------------------------------------------------
 Question4:
Which of the following similar words is more commonly associated with a physical reliance on something?


    a.     Addiction
    b.     Dependence

the answer is:    a.     Addiction        ----------------------------------------------------------------------------------------------------------------------------------
 Question5:
The preferred form for directional words in American English is ___________.


    a.     without an "s," as in toward, afterward, upward, forward, and backward
    b.     with an "s," as in towards, afterwards, upwards, forwards, and backwards

the answer is:    b.     with an "s," as in towards, afterwards, upwards, forwards, and backwards    ----------------------------------------------------------------------------------------------------------------------------------   

 Question6:
Complete the following sentence by choosing the correct phrase from the options below.

________________, I have enclosed our sales brochure and product information pamphlets.


    a.     Per your request
    b.     As per your request
    c.     As you requested
    d.     As per the request you recently made

the answer is:    c.     As you requested        ----------------------------------------------------------------------------------------------------------------------------------
 Question7:
Which of the following words would be most appropriate when referring to a vessel's ability to hold or contain something?


    a.     Ability
    b.     Capability
    c.     Capacity

the answer is:    a.     Ability        ----------------------------------------------------------------------------------------------------------------------------------
 Question8:
Which of the following words refers to a state of immobility?


    a.     Stationery
    b.     Stationary

the answer is:    b.     Stationary        ----------------------------------------------------------------------------------------------------------------------------------
 Question9:
From the options below, choose the correct preposition to complete the underlined prepositional idiom in the following sentence.

Griffin swore up and down that his comment had been meant ____ a compliment.


    a.     as
    b.     for
    c.     to
    d.     No preposition is needed.

the answer is:    d.     No preposition is needed.        ----------------------------------------------------------------------------------------------------------------------------------
 Question10:
Complete the following sentence by choosing the correct word from the options below.

The herd of gazelles successfully ____________ the wild cheetahs.


    a.     alluded
    b.     eluded
    c.     illuded

the answer is:    b.     eluded        ----------------------------------------------------------------------------------------------------------------------------------
 Question11:
The word "____________" refers to an agreement made between two or more parties, whereas the word "____________" refers to conformity, as to someone's rules or wishes.


    a.     accord / accordance
    b.     accordant / accord
    c.     accordance / accordant

the answer is:    c.     accordance / accordant        ----------------------------------------------------------------------------------------------------------------------------------
 Question12:
The word "______________" refers to something that is immoral, improper, or incorrect, whereas the word "______________" refers to something that is unjust, unfair, or unsanctioned by law.


    a.     wrong / wrongful
    b.     wrongful / wrong
    c.     The two words are completely interchangeable.

the answer is:    b.     wrongful / wrong
----------------------------------------------------------------------------------------------------------------------------------       
 Question13:
The article "an" is normally used before all of the following words except ________.


    a.     hour
    b.     eulogy
    c.     umbrella
    d.     X-ray

the answer is:    a.     hour    ----------------------------------------------------------------------------------------------------------------------------------
 Question14:
Which of the following words is used to show uncertainty or a conditional statement?


    a.     Can
    b.     Could
    c.     Will
    d.     None of the above

the answer is:    d.     None of the above        ----------------------------------------------------------------------------------------------------------------------------------
 Question15:
The word "____________" refers to feeling satisfied with one's life, whereas the word "____________" means to be easygoing and eager to please.


    a.     complacent / compliant
    b.     complaisant / complacent
    c.     compliant / complaisant
    d.     complacent / complaisant

the answer is:    c.     compliant / complaisant        ----------------------------------------------------------------------------------------------------------------------------------
 Question16:
From the options below, choose the correct preposition to complete the underlined prepositional idiom in the following sentence.

We've noticed that the new horse has a predilection ______ jumping over bales of hay.


    a.     with
    b.     for
    c.     to
    d.     of
    e.     No preposition is needed.

the answer is:    c.     to        ----------------------------------------------------------------------------------------------------------------------------------
 Question17:
From the options below, choose the correct preposition to complete the underlined prepositional idiom in the following sentence.

The chef has decided that his lobster bisque will be accompanied ______ a puff pastry for dipping.


    a.     with
    b.     in
    c.     by
    d.     of

the answer is:    a.     with        ----------------------------------------------------------------------------------------------------------------------------------
 Question18:
Which of the following statements is CORRECT?


    a.     The word "continuous" refers to something that occurs constantly, uninterrupted, or without a break, whereas the word "continually" refers to something that is frequently repeated.
    b.     The word "continually' refers to something that occurs constantly, uninterrupted, or without a break, whereas the word "continuous" refers to something that is frequently repeated.
    c.     The words "continuous" and "continually" are synonyms and are interchangeable.
    d.     The word "continually" does not exist in American English usage.

the answer is:    b.     The word "continually' refers to something that occurs constantly, uninterrupted, or without a break, whereas the word "continuous" refers to something that is frequently repeated.        ----------------------------------------------------------------------------------------------------------------------------------
 Question19:
Of the similar words below, the word "________________" is most commonly used to express a formal request.


    a.     can
    b.     could
    c.     may
    d.     might

the answer is:    b.     could                ----------------------------------------------------------------------------------------------------------------------------------
 Question20:
Which of the following similar words is more commonly associated with secretly working together to plot a misdeed?


    a.     Conspire
    b.     Connive

the answer is:    a.     Conspire                ----------------------------------------------------------------------------------------------------------------------------------
 Question21:
Complete the following sentence by choosing the correct word from the options below.

My parrot _____________ have won the talent contest if I had entered him in time.


    a.     may
    b.     must
    c.     might
    d.     mightn't        ----------------------------------------------------------------------------------------------------------------------------------
 Question22:    b.     must
Complete the following sentence by choosing the correct sequence of words from the options below.

Not only was Marlon's handwriting practically _____________, but the story was so dull and convoluted that I also found it ____________.


    a.     unreadable / illegible
    b.     legible / readable
    c.     illegible / unreadable

the answer is:    c.     illegible / unreadable                ----------------------------------------------------------------------------------------------------------------------------------
 Question23:
Select the correct meaning of the adjective "noisome."


    a.     Making much noise
    b.     Noxious or offensive
    c.     Boring

the answer is:    b.     Noxious or offensive
        ----------------------------------------------------------------------------------------------------------------------------------
 Question24:
Complete the following sentence by choosing the correct word from the options below.

Abigail had just reached the ______________ scene of the play when the theater suddenly went dark.


    a.     Climatic
    b.     Clichéd
    c.     Climactic

the answer is:    a.     Climatic                ----------------------------------------------------------------------------------------------------------------------------------
 Question25:
Which of the following words means "to excite, arouse, or offend"?


    a.     Peak
    b.     Peek
    c.     Pique

the answer is:    a.     Peak                ----------------------------------------------------------------------------------------------------------------------------------
 Question26:
From the options below, choose the correct preposition to complete the underlined prepositional idiom in the following sentence.

Josh is completely enamored ______ that puppy!


    a.     with
    b.     of
    c.     at
    d.     No preposition is needed.

the answer is:    d.     No preposition is needed.                ----------------------------------------------------------------------------------------------------------------------------------
 Question27:
The following related words have similar meanings but varying degrees of negative connotation. Which list from the options below best represents these words from least negative to most negative?

CRIMINAL                 ILLEGAL                     UNLAWFUL                      ILLICIT


    a.     Illicit / Unlawful / Illegal / Criminal
    b.     Criminal / Illicit / Unlawful / Illegal 
    c.     Unlawful / Illegal / Illicit / Criminal
    d.     Unlawful / Criminal / Illicit / Illegal

the answer is:    c.     Unlawful / Illegal / Illicit / Criminal                ----------------------------------------------------------------------------------------------------------------------------------
 Question28:
From the options below, choose the correct sequence of prepositions to complete the underlined prepositional idioms in the following sentence.

We simply cannot decide whether to trade _____ our car for a new model or, as our neighbors suggested, trade it _____ their houseboat.


    a.     in / as
    b.     for / in
    c.     in / for
    d.     for / on

the answer is:    c.     in / for                ----------------------------------------------------------------------------------------------------------------------------------
 Question29:
Complete the following sentence by choosing the correct word from the options below.

Martha has a real ______________ for writing ballads and odes.


    a.     flare
    b.     flair
    c.     flayer

the answer is:    b.     flair                ----------------------------------------------------------------------------------------------------------------------------------
 Question30:
Which of the following words is often associated with money?


    a.     Disperse
    b.     Disburse
    c.     Dispense

the answer is:    b.     Disburse                ----------------------------------------------------------------------------------------------------------------------------------
 Question31:
Complete the following sentence by choosing the correct sequence of words from the options below.

Sophia managed to ___________ Igor's crude advances; in a huff, the __________ little man ___________ down the castle wall and scooted off into the underbrush.


    a.     repulse / repulsive / repelled
    b.     rappel / repelled / repulsed
    c.     repel / repulsive / rappelled
    d.     rappel / repulsed / repelled

the answer is:    a.     repulse / repulsive / repelled                ----------------------------------------------------------------------------------------------------------------------------------
 Question32:
Which of the following options best defines the word "friendly"?


    a.     Amiable
    b.     Amicable
    c.     Both words mean "friendly," but "amiable" refers to people and "amicable" refers to relationships.
    d.     Both words mean "friendly," but "amiable" refers to relationships  and "amicable" refers to people.

the answer is:    d.     Both words mean "friendly," but "amiable" refers to relationships  and "amicable" refers to people.                ----------------------------------------------------------------------------------------------------------------------------------
 Question33:
Which of the following similar words refers to something that is well-known or momentous in history?


    a.     Historic
    b.     Historical

the answer is:    b.     Historical                ----------------------------------------------------------------------------------------------------------------------------------
 Question34:
Which of the following similar words means "to inflict a punishment or penalty in return for an unjust act"?


    a.     Avenge
    b.     Revenge
    c.     The words are synonyms and can be used interchangeably.

the answer is:    b.     Revenge                ----------------------------------------------------------------------------------------------------------------------------------
 Question35:
Which of the following words means "once every two years"?


    a.     Annual
    b.     Biennial
    c.     Semiannual

the answer is:    a.     Annual                ----------------------------------------------------------------------------------------------------------------------------------
 Question36:
Which of the following words is a verb meaning "to change"?


    a.     Alter
    b.     Alder
    c.     Altar
    d.     Antler

the answer is:    a.     Alter                ----------------------------------------------------------------------------------------------------------------------------------
 Question37:
Which of the following similar words is used to describe one's negative feelings and antipathy for something?


    a.     Adverse
    b.     Averse

the answer is:    b.     Averse                ----------------------------------------------------------------------------------------------------------------------------------
 Question38:
Which of the following words means "to inform or notify"?


    a.     Appraise
    b.     Appease
    c.     Apprise
    d.     Appall

the answer is:    b.     Appease                ----------------------------------------------------------------------------------------------------------------------------------
 Question39:
Complete the following sentence by choosing the correct sequence of words from the options below.

Harold buried his ___________ change in a shoebox so he wouldn't _____________ it.


    a.     loose / lose
    b.     loose / loose
    c.     lose / loose
    d.     lose / lose

the answer is:    c.     lose / loose               ----------------------------------------------------------------------------------------------------------------------------------
 Question40:
Which of the following similar words generally has a negative connotation?


    a.     Childlike
    b.     Childhood
    c.     Childish

the answer is:    b.     Childhood

MORE ODESK TESTS ANSWERS 2012.

odesk English Spelling Test (U.S. Version) answers 2012 100% complete and correct.

Hello to every one. in this tutorial i will show you how to pass the odesk English Spelling Test (U.S. Version) answers 2012.

Question1:
Identify the misspelled word in the list below.


    a.     Dexterity
    b.     Desicate
    c.     Dyeing
    d.     Desecrate

 the answer is:    b.     Desicate       

 Question2:
Complete the following sentence by choosing the correct spelling of the missing word.

Sam _________ a successful political campaign.


    a.     orchestraited
    b.     orchestrated
    c.     orchestreated
    d.     orcestrated

the answer is:    b.     orchestrated       

 Question3:
Complete the following sentence by choosing the correct spelling of the missing word.

Helen was surprised by the __________ stature of her blind date.


    a.     diminutive
    b.     diminuative
    c.     deminutive
    d.     dimminutive

the answer is:    a.     diminutive       

 Question4:
Identify the misspelled word in the list below.


    a.     Parallel
    b.     Prevalent
    c.     Prejudice
    d.     Perserverance

the answer is:    d.     Perserverance       

 Question5:
Complete the following sentence by choosing the correct spelling of the missing word.

Sally’s nervous __________ left her standing at the altar.


    a.     fiancé
    b.     finance
    c.     feancé
    d.     fience

the answer is:    b.     finance

 Question6:
Complete the following sentence by choosing the correct spelling of the missing word.

Arthur spent hours admiring the gothic ____________of all those French cathedrals.


    a.     architecture
    b.     arkhitecture
    c.     arcitecture
    d.     arckitecture

the answer is:    a.     architecture       

 Question7:
Choose the correct spelling of the word from the options below.


    a.     Priveledge
    b.     Privilage
    c.     Privilege
    d.     Privelege

the answer is:    c.     Privilege       

 Question8:
Complete the following sentence by choosing the correct spelling of the missing word.

Let me tie your mittens to your sleeves so you don't ______________ them.


    a.     loose
    b.     looze
    c.     lose
    d.     louse

the answer is:    c.     lose       

 Question9:
Choose the correct spelling of the word from the options below.


    a.     Ligitimate
    b.     Legitimate
    c.     Legetimate
    d.     Legitemate

the answer is:    b.     Legitimate       

 Question10:
Complete the following sentence by choosing the correct spelling of the missing word.

Peter always makes such a _____________ of himself!


    a.     nuisance
    b.     nuisents
    c.     newsanse
    d.     nuisince

the answer is:    a.     nuisance       

 Question11:
Identify the misspelled word in the list below.


    a.     Hemorrhage
    b.     Harass
    c.     Hankerchief
    d.     Hypocrisy

the answer is:    c.     Hankerchief       

 Question12:
Identify the misspelled word in the list below.


    a.     Yacht
    b.     Youthful
    c.     Yeilding
    d.     Yesterday

the answer is:
       
 Question13:
Choose the correct spelling of the word from the options below.


    a.     Embarassment
    b.     Embrassement
    c.     Embarrasment
    d.     Embarrassment

the answer is:    a.     Embarassment       

 Question14:
Identify the misspelled word in the list below.


    a.     Occasion
    b.     Occurrence
    c.     Orangutan
    d.     Opponant

the answer is:    d.     Opponant       

 Question15:
Identify the misspelled word in the list below.


    a.     Quixotic
    b.     Quite
    c.     Questionaire
    d.     Quarantine

the answer is:    c.     Questionaire       

 Question16:
Choose the correct spelling of the word from the options below.


    a.     Adress
    b.     Addrress
    c.     Addres
    d.     Address

the answer is:    d.     Address       

 Question17:
Identify the misspelled word in the list below.


    a.     Sophomore
    b.     Supersede
    c.     Susceptable
    d.     Spontaneous

the answer is:    c.     Susceptable       

 Question18:
Identify the misspelled word in the list below.


    a.     Rhythmical
    b.     Reminiscence
    c.     Rheumatism
    d.     Resevoir

the answer is:    d.     Resevoir       

 Question19:
Choose the correct spelling of the word from the options below.


    a.     Goverment
    b.     Governmant
    c.     Government
    d.     Govermant

the answer is:    c.     Government       

 Question20:
Identify the misspelled word in the list below.


    a.     Cachet
    b.     Connoisseur
    c.     Charateristic
    d.     Catastrophe

the answer is:    c.     Charateristic

 Question21:
Complete the following sentence by choosing the correct spelling of the missing word.

The purpose of your report should be to ___________ the most relevant facts, not to obscure them.


    a.     illumenate
    b.     iluminate
    c.     illuminate
    d.     elluminate

the answer is:    c.     illuminate       

 Question22:
Complete the following sentence by choosing the correct spelling of the missing word.

The protesters hurled ___________ insults at us as we walked by.


    a.     vicous
    b.     vicious
    c.     vicoius
    d.     vicius

the answer is:    b.     vicious       

 Question23:
Choose the correct spelling of the word from the options below.


    a.     Neccesary
    b.     Necessary
    c.     Neccessary
    d.     Necesary

the answer is:    b.     Necessary       

 Question24:
Identify the misspelled word in the list below.


    a.     Fluorescent
    b.     Fullfil
    c.     Facsimile
    d.     Fictitious

the answer is:    b.     Fullfil       

 Question25:
Complete the following sentence by choosing the correct spelling of the missing word.

My father does not believe in ____________ , but my mother does.


    a.     reincanation
    b.     reincarenation
    c.     reincarnation
    d.     reincantation

the answer is:    c.     reincarnation       

 Question26:
Choose the correct spelling of the word from the options below.


    a.     Heinous
    b.     Henous
    c.     Heinus

the answer is:    a.     Heinous       

 Question27:
Complete the following sentence by choosing the correct spelling of the missing word.

The church members accused the cult of _______________ practices.


    a.     sacreligious
    b.     sacrelegious
    c.     sacrilegious
    d.     sacrilgious

the answer is:    c.     sacrilegious       

 Question28:
Complete the following sentence by choosing the correct spelling of the missing word.

The judge granted the reluctant witness complete ____________ from prosecution for his part in the crime.


    a.     amnesty
    b.     amnasty
    c.     anmesty
    d.     emnesty

the answer is:    a.     amnesty       

 Question29:
Complete the following sentence by choosing the correct spelling of the missing word.

He __________ a summer house, an exercise bike, and a hamster in the divorce settlement.


    a.     accquired
    b.     ecquired
    c.     acquired
    d.     akquired

the answer is:    c.     acquired       

 Question30:
Complete the following sentence by choosing the correct spelling of the missing word.

The clown’s performance was _______________, to say the least.


    a.     dissapointing
    b.     dissappointing
    c.     disapointing
    d.     disappointing

the answer is:    d.     disappointing       

 Question31:
Identify the misspelled word in the list below.


    a.     Managable
    b.     Millennium
    c.     Minuscule
    d.     Miscellaneous

the answer is:    a.     Managable       

 Question32:
Choose the correct spelling of the word from the options below.


    a.     Excesive
    b.     Exccesive
    c.     Excessive
    d.     Exceesive

the answer is:    c.     Excessive       

 Question33:
Complete the following sentence by choosing the correct spelling of the missing word.

Mrs. Baker took her ______________ class on a field trip to the zoo.


    a.     kindergarden
    b.     kindegarten
    c.     kindergarten
    d.     kindegarden

the answer is:    c.     kindergarten       

 Question34:
Choose the correct spelling of the word from the options below.


    a.     Pronounciation
    b.     Pronuciation
    c.     Pronuncitation
    d.     Pronunciation

the answer is:    d.     Pronunciation       

 Question35:
Choose the correct spelling of the word from the options below.


    a.     Leiutenant
    b.     Luietenant
    c.     Lieutanent
    d.     Lieutenant

the answer is:    d.     Lieutenant       

 Question36:
Complete the following sentence by choosing the correct spelling of the missing word.

On the ____________ day of Christmas, Lucy was annoyed to find her yard full of noisy drummers drumming.


    a.     twelvth
    b.     twelfth
    c.     twelfeth
    d.     twelth

the answer is:    b.     twelfth       

 Question37:
Complete the following sentence by choosing the correct spelling of the missing word.

Their relationship was plagued by __________ problems.


    a.     perpetual
    b.     perpechual
    c.     purpetual
    d.     perptual

the answer is:    a.     perpetual       

 Question38:
Complete the following sentence by choosing the correct spelling of the missing word.

The professor made it clear that ___________ would not be tolerated.


    a.     plagiarism
    b.     plagiarizm
    c.     plagerism
    d.     plagirism

the answer is:    a.     plagiarism       

 Question39:
Choose the correct spelling of the word from the options below.


    a.     Efficency
    b.     Efficentsy
    c.     Efficiensy
    d.     Efficiency

the answer is:    d.     Efficiency       

 Question40:
Choose the correct spelling of the word from the options below.


    a.     Temperamental
    b.     Tempermental
    c.     Temperamentle
    d.     Temparamental

the answer is:    a.     Temperamental

-how to pss the odesk MS Excel 2007 Test.

Hello to every one. in this tutorial i will show you how to pass the odesk MS Excel 2007 Test 2012.

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

 the answers is:    d.     None of the above                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


 Question2:
Which among the following options displays Legend entries in the given picture?


    a.     A
    b.     B
    c.     C
    d.     None of the above

the answers is:    b.     B                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


 Question3:
When does the error, as shown in the picture, occur?


    a.     It occurs when a column is not wide enough
    b.     It occurs when a negative date is used
    c.     It occurs when a negative time is used
    d.     All of the above

the answers is:    c.     It occurs when a negative time is used                ----------------------------------------------------------------------------------------------------------------------------------
 Question4:
Which keyboard shortcut should be used to minimize or restore the ribbon?


    a.     CTRL+F3
    b.     CTRL+F2
    c.     CTRL+F1
    d.     None of the above

the answers is:    b.     CTRL+F2                ----------------------------------------------------------------------------------------------------------------------------------
 Question5:
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

the answers is:    d.     None of the above                ----------------------------------------------------------------------------------------------------------------------------------
 Question6:
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

the answers is:    a.     True                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


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

the answers is:    c.     C                ----------------------------------------------------------------------------------------------------------------------------------
 Question8:
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

the answers is:    d.     Hidden Rows and Columns
        ----------------------------------------------------------------------------------------------------------------------------------
 Question9:
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

the answers is:    b.     False                ----------------------------------------------------------------------------------------------------------------------------------
 Question10:
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

the answers is:    b.     False                ----------------------------------------------------------------------------------------------------------------------------------
 Question11:
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

the answers is:    c.     When the workbook is shared or protected                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


 Question12:
Refer to the given image. What will be the result if the formula =B3&", "&A3 is applied on the given table?


    a.     It will display Nancy Davolio
    b.     It will display Fuller Andrew
    c.     It will display Fuller, Andrew
    d.     Both b and c

the answers is:    b.     It will display Fuller Andrew                ----------------------------------------------------------------------------------------------------------------------------------
 Question13:
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?


    a.     Consolidate by position
    b.     Consolidate by category
    c.     Consolidate by formula
    d.     None of the above

the answers is:    a.     Consolidate by position                ----------------------------------------------------------------------------------------------------------------------------------
 Question14:
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

the answers is:    d.     None of the above                ----------------------------------------------------------------------------------------------------------------------------------
 Question15:
Which file format is typically used to remove printer corruption?


    a.     XLS format
    b.     HTML format
    c.     SYLK format
    d.     All of the above

the answers is:    c.     SYLK format                ----------------------------------------------------------------------------------------------------------------------------------
 Question16:
State whether true or false:

When a part of a formula is replaced with its calculated value, it cannot be restored.


    a.     True
    b.     False

the answers is:    a.     True                ----------------------------------------------------------------------------------------------------------------------------------
 Question17:
Which chart displays axes but cannot display axis titles?


    a.     Radar chart
    b.     Doughnut chart
    c.     Pie chart
    d.     All of the above

the answers is:    c.     Pie chart                ----------------------------------------------------------------------------------------------------------------------------------
 Question18:
How will you find cells with data validation?


    a.     On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go To Special. Click on Data Validation, and then click All
    b.     On the View tab, in the Windows group, click Data Validation
    c.     Both a and b
    d.     None of the above

the answers is:    b.     On the View tab, in the Windows group, click Data Validation                ----------------------------------------------------------------------------------------------------------------------------------
 Question19:
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

the answers is:    c.     On the Review tab                ----------------------------------------------------------------------------------------------------------------------------------
 Question20:
Which of the given methods would you follow to add an alternative text to a picture?


    a.     Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
    b.     Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
    c.     Both a and b
    d.     None of the above

the answers is:    b.     Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text                ----------------------------------------------------------------------------------------------------------------------------------
 Question21:
As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?


    a.     This option does not let you change the consolidation
    b.     This option does not let you create the consolidation
    c.     Both a and b
    d.     None of the above

the answers is:    d.     None of the above                ----------------------------------------------------------------------------------------------------------------------------------
 Question22:
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

the answers is:    a.     Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'                ----------------------------------------------------------------------------------------------------------------------------------
 Question23:
Which of the following charts have no axes?


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

the answers is:    c.     Both a and b                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


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

the answers is:    b.     It selects a large range of cells in the worksheet                ----------------------------------------------------------------------------------------------------------------------------------
 Question25:
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

the answers is:    d.     Some keyboard characters can cause unexpected results if used in cell names                ----------------------------------------------------------------------------------------------------------------------------------
 Question26:
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

the answers is:    c.     By value field                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


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

the answers is:    b.     It prevents the text from blurring                ----------------------------------------------------------------------------------------------------------------------------------
 Question28:
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

the answers is:    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                ----------------------------------------------------------------------------------------------------------------------------------
 Question29:
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

the answers is:    b.     It means that Filtering has been enabled but not applied                ----------------------------------------------------------------------------------------------------------------------------------
 Question30:
State whether true or false:

A Macro project can be digitally signed.


    a.     True
    b.     False

the answers is:    b.     False                ----------------------------------------------------------------------------------------------------------------------------------
 Question31:
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

the answers is:    d.     All of the above are valid                ----------------------------------------------------------------------------------------------------------------------------------
 Question32:
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

the answers is:    b.     A column width between 0 to 255 can be specified                ----------------------------------------------------------------------------------------------------------------------------------
 Question33:
Which among the following settings is the default macro setting?


    a.     Disable all macros without notification
    b.     Disable all macros except digitally signed macros
    c.     Disable all macros with notification
    d.     Enable all macros

the answers is:    d.     Enable all macros                ----------------------------------------------------------------------------------------------------------------------------------
 Question34:
Which keyboard shortcut should be used to enter the current time?


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

the answers is:    b.     CTRL+SHIFT+:                ----------------------------------------------------------------------------------------------------------------------------------
 Question35:
Which tab should be used to display or hide axes?


    a.     Data tab
    b.     Layout tab
    c.     Insert tab
    d.     View tab

the answers is:    c.     Insert tab                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


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

the answers is:    b.     B                ----------------------------------------------------------------------------------------------------------------------------------
 Question37:
State whether true or false:

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


    a.     True
    b.     False

the answers is:    b.     False                ----------------------------------------------------------------------------------------------------------------------------------
 Question38:
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

the answers is:    c.     Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left                ----------------------------------------------------------------------------------------------------------------------------------
 This question is based upon the figure shown below


 Question39:
What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?


    a.     It signifies that the cell contains a formula
    b.     It signifies that the cell contains a comment
    c.     It signifies that the cell contains a macro
    d.     All of the above

the answers is:    c.     It signifies that the cell contains a macro
        ----------------------------------------------------------------------------------------------------------------------------------
 Question40:
State whether true or false:

A Macro project can be digitally signed.


    a.     True
    b.     False
       
the answers is:    a.     True

Source

Hello to every one. in this tutorial i will show you how to pass the odesk ASP.Net 3.5 using C# Test 2012.
 Question1:
The earliest event in which all viewstate information has been restored is:


    a.    Init
    b.    PreLoad
    c.    Load
    d.    Render

 the answer is:    b.    PreLoad       

 Question2:
Which of the following differentiates a UserControl from a Custom Server control?


    a.    UserControl can directly express rendering information via markup; a Custom Server control can not.
    b.    UserControl does not require the use of the @Register directive; a Custom Server control does require it.
    c.    UserControl can make use of script based validation;  a Custom Server control can not.
    d.    UserControl can represent complete compositate hierarchy; a Custom Server control can not.

 the answer is:    b.    UserControl does not require the use of the @Register directive; a Custom Server control does require it.       

 Question3:
What is the proper declaration of a method which will handle the following event?

Class MyClass
{
      public event EventHandler MyEvent;
}


    a.    public void A_MyEvent(object sender, MyArgs e)
{
}
    b.    public void A_MyEvent(object sender, EventArgs e)
{
}
    c.    public void A_MyEvent(MyArgs e)
{
}

 the answer is: c.    public void A_MyEvent(MyArgs e)
{
}       

 Question4:
Given the code below, which items will cause a compilation error?

static void F1(params int [] y)
{
}

static void Sample()
{
   int [] j = new Int32[3];
List k = new List();
// ANSWER GOES HERE
}


    a.    F1(j);
    b.    F1(k);
    c.    F1(1, 2, 3);
    d.    F1(new [] {1,2,3})
    e.    None of the above

 the answer is:    e.    None of the above       

 Question5:
By which of the following can the .NET class methods be included in .aspx files?


    a.    Including .Net code within the script element with the runat attribute set to server
    b.    Including .Net code within the code element
    c.    Including .Net code using the @code directive on the page
    d.    Including .Net code within the execute attribute of the individual control

 the answer is:    c.    Including .Net code using the @code directive on the page
       
 Question6:
Which of the following are true about System.Security.Cryptography under version 3.5 of the framework?


    a.    Support is provided for the "Suite B" set of cryptographic algorithms as specified by the National Security Agency (NSA).
    b.    Cryptography Next Generation (CNG) classes are supported on XP and Vista systems.
    c.    The System.Security.Cryptography.AesManaged class allows custom block size, iteration counts and feedback modes to support any Rijndael based encryption.

 the answer is:    b.    Cryptography Next Generation (CNG) classes are supported on XP and Vista systems.       

 Question7:
Where should an instance of an object which provides services to all users be stored?


    a.    ApplicationState
    b.    SessionState
    c.    ViewState
    d.    None of the above

 the answer is:    d.    None of the above       

 Question8:
Which of the following are the goals of the Windows Communciation Foundation?


    a.    Bringing various existing communication technologies into a unified environment.
    b.    Cross vendor/platform communication.
    c.    Support for asynchronous communications.
    d.    Support for distributed applications based on technologies such as MSMQ and/or COM+
    e.    All of the above

 the answer is:    e.    All of the above       

 Question9:
When using a DataReader to access the results of a Database operation, which of the following is true?


    a.    The DataReader provides a cursor that can be used to move forward and backwards through the result.
    b.    The DataReader provides random access capabilities on the result.
    c.    The DataReader can provide the Schema information of the result to the application code.

 the answer is:    b.    The DataReader provides random access capabilities on the result.       

 Question10:
Which of the following types guarantee atomic reads and writes?


    a.    int
    b.    double
    c.    long
    d.    float

 the answer is:    d.    float       

 Question11:
Which of the following does Event Bubbling allow composite controls to perform?


    a.    Propagate container related events to the child controls.
    b.    Propagate child events up to control hierarchy
    c.    Distribute events between peer child controls.
    d.    Translate control unhandled control events into exceptions.

 the answer is:    b.    Propagate child events up to control hierarchy       

 Question12:
Which of the following is/are true regarding the use of Authentication to control access to the HTML file (.htm or .html)?


    a.    ASP.NET authentication handles these by default in a manner equivalent to .aspx pages
    b.    ASP.NET authentication can be associated with these extensions using aspnet_isapi.dll in IIS 6.0, for the appropriate directory
    c.    ASP.NET authentication cannot be used for this purpose

 the answer is:    c.    ASP.NET authentication cannot be used for this purpose       

 Question13:
Which of the following is false about declarative attributes?


    a.    They must be inherited from the System.Attribute.
    b.    Attribute classes may be restricted to be applied only to application element types.
    c.    By default, a given attribute may be applied multiple times to the same application element.

 the answer is:    c.    By default, a given attribute may be applied multiple times to the same application element.       

 Question14:
Which of the following is false about System.GC under version 3.5 of the .NET Framework?


    a.    You can request that the garbage collector processes a generation if it determines that it is appropriate at specific points in your code
    b.    You can control the intrusiveness of the garbage collector (how often it performs collections) while your program is running
    c.    You can control the intrusiveness of the garbage collector (how often it performs collections) only during application initialization

 the answer is:    b.    You can control the intrusiveness of the garbage collector (how often it performs collections) while your program is running       

 Question15:
With which of the following are Declarative Databinding expressions delimited?


    a.    <%#    %>
    b.    <%--   --%>
    c.  
    d.    <#  >

 the answer is:<%--   --%>       

 Question16:
Which of the following statements are applicable in LINQ to SQL?


    a.    It is pure Object Relational (O/R) model.
    b.    It is a set of enhancements to the DataSet and DataTable classes.
    c.    It requires the use of SQLServer as the database.
    d.    Because LINQ is based on Queries, it can not be used to modify the data in the database.

 the answer is:    b.    It is a set of enhancements to the DataSet and DataTable classes.       

 Question17:
Which of the following is used to remove a cookie from a client machine?


    a.    Remove the cookie from the System.Web.UI.Page.Request.Cookies collection.
    b.    Remove the cookie from the System.Web.UI.Page.Request.Browser.Cookies collection.
    c.    Set the Expires property to DataTime.Now for a cookie in the Web.UI.Page.Response.Cookies
    d.    Remove the cookie from the System.Web.UI.Page.Response.Cookies collection.

 the answer is:    d.    Remove the cookie from the System.Web.UI.Page.Response.Cookies collection.       

 Question18:
Which of the following are true of using ADO.NET DataSets and DataTables?


    a.    The DataSets and DataTables objects requires continuous connection to the database
    b.    All tables in a dataset must come from the same database
    c.    A given instance of a DataTable can be in only one DataSet
    d.    Content from multiple DataSets can easily be combined into a single DataSet that contains the net result of all changes

 the answer is:    b.    All tables in a dataset must come from the same database       

 Question19:
The following are two statements related to System.DateTimeOffset namespace.

Statement X: DateTimeOffset values can be converted to DateTime values and vice versa.
Statement Y: DateTimeOffset does not supports arithmetical operations


    a.    Statement X is incorrect and Statement Y is correct
    b.    Statement X is correct and Statement Y is incorrect
    c.    Both Statements X, Y are correct
    d.    Both Statements X, Y are incorrect

 the answer is:    d.    Both Statements X, Y are incorrect       

 Question20:
Which of the following are true regarding System.Web.Mail and System.Net.Mail namespaces?


    a.    System.Web.Mail is not supported under version 3.5 of the Framework
    b.    System.Web.Mail is deprecated under version 3.5 of the Framework, and it is officially recommended that System.Net.Mail be used.
    c.    System.Web.Mail is the preferred solution when using IIS hosted applications
    d.    There are no functional differences; the items were moved to a new namespace to better reflect their applicability

 the answer is:    b.    System.Web.Mail is deprecated under version 3.5 of the Framework, and it is officially recommended that System.Net.Mail be used.       

 Question21:
In which file are Predefined Client Side Validation Scripts defined?


    a.    WebUIValidation.js
    b.    ClientValidation.js
    c.    AspNetValidation.js
    d.    USerValidation.js

 the answer is:    d.    USerValidation.js       

 Question22:
Which of the following are common methods of supplying "Help" information to an ASP.NET application?


    a.    Setting the ToolTip property of a control to a string containing the information.
    b.    using the open method of the browser window object to open a new browser window and display a help related ASP.NET page
    c.    Using the showHelp method of the browser window object to display a topic from a compiled help file (.chm).
    d.    All of the above

 the answer is:    c.    Using the showHelp method of the browser window object to display a topic from a compiled help file (.chm).       

 Question23:
When using Cascading Style Sheets (CSS) to format output, which of the following is/are true?


    a.    Styles can be applied to all elements having the same CSS Class attribute
    b.    Styles can be applied to specific elements based on their ID attribute
    c.    Styles can be applied to elements based on their position in a hierarchy
    d.    Styles can be used to invoke script based code
    e.    All of the above

 the answer is:    e.    All of the above       

 Question24:
Which of the following is false regarding System.Threading.ReaderWriterLockSlim?


    a.    It is optimized for single processor/core operations
    b.    A thread which has a read lock on a resource may not acquire a write lock on the same resource
    c.    By default, a thread which has a read lock on a resource and attempts to get another read lock on the same resource will throw an exception

 the answer is:    b.    A thread which has a read lock on a resource may not acquire a write lock on the same resource       

 Question25:
Which of the following conditions can trigger the automatic recycling of an ASP.NET application hosted in IIS?


    a.    A specific number of requests to the application process.
    b.    A percentage of physical memory utilized by the process.
    c.    A specific time interval
    d.    All of the above

 the answer is:    d.    All of the above       

 Question26:
Which of the following is not a characteristic, that a Query expression should have?


    a.    It must contain a from clause
    b.    It must begin with a select clause
    c.    It can end with a group clause

 the answer is:    b.    It must begin with a select clause       

 Question27:
When using asynchronous partial updates with an UpdatePanel, which of the following are true?


    a.    Only the UpdatePanel and any child controls go through the server lifecycle.
    b.    The entire page always goes through the entire lifecycle.
    c.    Only the UpdatePanel which initiated the Postback and its child controls can provide updated information.
    d.    UpdatePanels can not be used with Master Pages.

 the answer is:    d.    UpdatePanels can not be used with Master Pages.       

 Question28:
Which of the following statements is false about Passport Authentication?


    a.    The Passport SDK must be installed.
    b.    Passport authentication requires a network path between the Client and the Microsoft Passport Server
    c.    Passport Authentication provides persistent authentication across sessions

 the answer is:    b.    Passport authentication requires a network path between the Client and the Microsoft Passport Server       

 Question29:
The default number of threads per processor in the System.Threading.ThreadPool class under version 3.5 of the Framwork is:


    a.    1
    b.    25
    c.    250
    d.    100
    e.    500

 the answer is:    d.    100       

 Question30:
Which of the following statements do Expression Trees fit best?


    a.    Expression trees are a data structure which can be initially composed using language syntax.
    b.    Expression trees are a dynamically generated code which is executed to perform the desired function.
    c.    Expression trees can be modified once they are created

 the answer is:    c.    Expression trees can be modified once they are created       

 Question31:
Which of the following are performed to fully debug an ASP.NET Application running on the same machine as the debugger?


    a.    Enabling debug information in the .NET Assembly
    b.    Setting the debug attribute of the compilation element to true in the web.config file.
    c.    Enabling ASP.NET debugging in the IIS metabase.

 the answer is:    c.    Enabling ASP.NET debugging in the IIS metabase.       

 Question32:
Which of the following are included in the advantages of Lambda Expressions over Anonymous methods?


    a.    More concise syntax
    b.    The types for a Lambda Expression may be omitted
    c.    The body of an Anonymous method can not be an expression
    d.    Lambda Expressions permit deferred type inference, that anonymous methods do not
    e.    All of the above

 the answer is:    b.    The types for a Lambda Expression may be omitted       

 Question33:
Which of the following controls allows the use of XSL to transform XML content into formatted content?


    a.    System.Web.UI.WebControls.Xml
    b.    System.Web.UI.WebControls.Xslt
    c.    System.Web.UI.WebControls.Substitution
    d.    System.Web.UI.WebControls.Transform

 the answer is:    d.    System.Web.UI.WebControls.Transform       

 Question34:
Which of the following is not an unboxing conversion?


    a.    void Sample1(object o)
{
   int i = (int)o;
}
    b.    void Sample1(ValueType vt)
{
   int i = (int)vt;
}
    c.    enum E { Hello, World}

void Sample1(System.Enum et)
{
   E e = (E) et;
}
    d.    class C { public int Value { get; set; } }

void Sample1(C vt)
{
   int i = vt.Value;
}

 the answer is:    d.    class C { public int Value { get; set; } }

void Sample1(C vt)
{       

 Question35:
Which of the following are true about Nullable types?


    a.    A Nullable type is a reference type.
    b.    An implicit conversion exists from any non-nullable value type to a nullable form of that type.
    c.    A predefined conversion from the nullable type S? to the nullable type T? exists if there is a predefined conversion from the non-nullable type S to the non-nullable type T

 the answer is:    c.    A predefined conversion from the nullable type S? to the nullable type T? exists if there is a predefined conversion from the non-nullable type S to the non-nullable type T       

 Question36:
Which of the following are required to be true by objects which are going to be used as keys in a System.Collections.HashTable?


    a.    They must handle case-sensitivity identically in both the GetHashCode() and Equals() methods.
    b.    Key objects must be immutable for the duration they are used within a HashTable.
    c.    Get HashCode() must be overridden to provide the same result, given the same parameters, regardless of reference equality unless the HashTable constructor is provided with an IEqualityComparer parameter.
    d.    Each Element in a HashTable is stored as a Key/Value pair of the type System.Collections.DictionaryElement
    e.    All of the above

 the answer is:    d.    Each Element in a HashTable is stored as a Key/Value pair of the type System.Collections.DictionaryElement       

 Question37:
Where should information about a control created at design time be stored?


    a.    ApplicationState
    b.    SessionState
    c.    ViewState
    d.    None of the above

 the answer is:    d.    None of the above       

 Question38:
Which directive allows the utilization of  a custom web control in an ASP.NET page?


    a.    @Register
    b.    @Include
    c.    @Control
    d.    @Import

 the answer is:    d.    @Import       

 Question39:
The output generated by the following code will be:

string t = @"This\Is\a\Test";
Response.Write(t);


    a.    ThisIsaTest
    b.    This\Is\a\Test
    c.    It will give a compilation error: Unrecognized escape sequence

 the answer is:    c.    It will give a compilation error: Unrecognized escape sequence       

 Question40:
Which of the following events should be used for assigning a Theme dynamically to a page?


    a.    PreInit
    b.    Init
    c.    PreLoad
    d.    PreRender
    e.    Render

 the answer is:    c.    PreLoad

Source