ODesk 23 Test Answers ~ JAHIDSUJON

ODesk Readiness Test Answers:

Today I share you,How to pass oDesk Readiness test.Let's Start,At first login to your oDesk account and click on add skill to your profile

Question No.1
Which of the following statements are correct about oDesk Fees?
Answer:
e. All of the above

Question No.2
How does feedback work on oDesk?
Answer:
e. All of the above

Question No.3
If you have not done so please download and install the oDesk Team application...............
Answer:
a. Team Room

Question No.4
Employers set weekly limits on hourly contracts, how do these work?
Answer:
e. All of the above

Question No.5
Which of the following statements about the oDesk Team application are true?
Answer:
e. All of the above

Question No.6
What do you need to do ensure guaranteed payment on hourly jobs?
Answer:
e. All of the above

Question No.7
How does oDesk's dispute resolution policy for work?
Answer:
e. All of the above

Question No.8
Which of the following is true of your oDesk's Work Diary?
Answer:
e. All of the above

Question No.9
Which of the following break the oDesk's user agreement?
Answer:
e. All of the above

Question No.10
Which of the following actions are Not allowed when applying to job postings?
Answer:
e. All of the above

Question No.11 Last Question
Can I start my own agency on oDesk?
Answer:
a. Yes................

oDesk Readiness Test Answers Letest(New):

Question: 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
Ans: b

Question: 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
Ans: d

Question: 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
Ans: e

Question: 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
Ans: c

Question: 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
Ans: e

Question: 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
Ans: e

Question: 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
Ans: e

Question: 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
Ans: a

Question: Which of the following are required to qualify for guaranteed payment?
a. An hourly contract
b. Tracking your time with the oDesk Team application
c. Entering relevant memos
d. An employer with a verified payment method
e. All of the above
Ans: e

Question: 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
Ans: e

Question: 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
Ans: e

oDesk-U.S- English-Basic-Skills-Test

Question 1:
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 wasn’t happening.
Answer: a. of, about

Question 2:
Choose the series of adjectives and adverbs that best completes the following sentence.
I think Pamela deserves to be punished for her________stupid and________behavior.
Answer: b. totally, irresponsible

Question 3:
Which of the following sentences punctuated correctly?
a. Tracy bought three suits; seven scarves; and ten pairs of shoes.
Answer: b. We are expecting a hurricane this afternoon, therefore we have closed the school early.

Question 4:
Choose the series of adjectives and adverbs that best completes the following sentence.
While_________of our relatives live on the__________hill in the county, _________of our friends live in the _________areas of the valley.
Answer: c. many, windiest, most, more, protected

Question 5:
Complete the following sentence by choosing the phrase with the best word order from the options given.
Those who are not wise_____________.
Answer: d. does not need to be necessarily stupid.

Question 6:
Choose the series of pronouns that best completes the following sentence.
Don’t _________think Larry should call__________wife if______________is going to be late for dinner?
Answer: a. you, his, he

Question 7:
Rearrange the following words to create most logical and grammatically correct sentence.
days for last has good weather few The been the not
Answer:d. The weather has not been good for the last few days

Question 8:
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____________.
Answer: b. shortest, accordingly

Question 9:
Rearrange the following words to create most logical and grammatically correct sentence.
Answer: e. Whenever I can’t spend time with my friend, I always speak to him on the phone.

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

Question 11:
Which of the following sentence illustrates correct pronoun usage?
a. is those the set of plates the bride wanted, or did she want this set?
d.Whose book is that-his or our?
Answer: e. None of the above

Question 12:
Which of the sentence illustrates proper sentence structure?
a. Everyone knows that a mango is much sweeter to an orange
Answer: d. The queen had hardly finished her speech when the people began to disperse.

Question 13:
Change the following sentence from a quotation to indirect speech.
“It may snow tomorrow.” he said.
Answer: d. He said it might snow tomorrow.
Question 14:
Which of the following sentence punctuated correctly?
Answer: d. “Come here.” she said, “and let me get a good look at you.”

Question 15:
Change the following sentence from a quotation to indirect speech.
“Sharon must go to the bank today.” said Albert.
Answer: d. Albert said Sharon had to go to the bank today.

Question 16:
Choose the option that correctly changes original sentence from active to passive.
ORIGINAL SENTENCE:
That tall man is carrying a lot of lumber.
REWRITTEN SENTENCES:
Answer: d. A lot of lumber is being carried by that tall man.

Question 17:
Choose the series of prepositions that best completes the following sentence.
I placed my notes__________my desk and referred to them____________ the meeting.
Answer: b. beside, during

Question 18:
Rearrange the following words to create most logical and grammatically correct sentence.
Sleeping likes the . midday Katie until on weekends
Answers: Katie likes sleeping until midday on the weekends.

Question 19:
Choose the series of verbs that best completes the following sentence.
Everyone ____________too busy cooking and __________ the campsite ____________ the family _________ from the woods.

Answers: d. was, setting up, to notice, watching

Question 20:
Choose the series of verbs that best completes the following sentence.
I find it very hard to remember ______________ letters that are entrusted to me. In fact, I remember_____________to do so dozens of times!
Answer: d. mailing, forgetting

Question 21:
Choose the series of articles and conjunctions that best completes the following sentence.
Lilacs ___________ violets are usually purple, I have seen some _________ are white.
Answer: c. and, although, that

Questions 22:
Complete the following sentence by choosing the phrase with the best word order from the options given.
Only after they had an exhaustive study__________ how to adapt the technology to the needs of our company.
Answer: c. they did begin to understand

Question 23:
Which of the following sentence illustrates proper use of comma?
a. Randy wanted to end the meeting, but Amy wanted to prolong it.
e. a and b
answer: f. All of the above

Question 24:
Which of the following sentence does NOT illustrates correct verb and tense usage?
Answer: b. Clarabelle’s mother absolutely hated nicknames and always calls her daughter by her full name.

Question 25:
Choose the series of prepositions that best completes the following sentence.
Victor, who stole ____________ ideas and used them to make _________ a millionaire, never once offered ______________ a world of thanks.
Answer: d. our, himself, us

Question 26:
Choose the series of prepositions that best completes the following sentence.
______________ is the name of the opera, and ___________ role did you say Maria would play?
Answer: c. What, which

Question 27:
Choose the verbs and phrases that best completes the following sentence.
This dish _____________ too spicy. Why ___________ so pepper?
Answer: e. a and c

Question 28:
Change the following sentence from a quotation to indirect speech.
Carol has said, “I am responsible for this project.”
Answer: a. Carol has said that she is responsible for this.

Question 29:
Choose the series of prepositions that best completes the following sentence.
Although Marvin said he had the keys___________ the flower pot, we were unable to find them___________ the dark. In the end, we waited for him at the coffee shop ____________the corner.
Answer: a. under, in. around

Question 30:
Complete the following sentence by choosing the phrase with the best word order from the options given.
The excited children who had run toward the loud _______________.
Answer:d. music, told the others about the ice cream truck outside.

Question 31:
Rearrange the following words to create most logical and grammatically correct sentence.
your company name? of what the is
Answer: c. What is the name of your company?

Question 32:
Which of the following sentences NOT punctuated correctly?
a. All of the apple’s at the grocers were rotten so I bought oranges instead.
Answer: b. “Seven canteens full of water should enough for the hike,” said Tabitha.

Question 33:
Choose the series of prepositions that best completes the following sentence.
After realizing that our hosts hadn’t actually invested _________ to ____________ party. ____________ excused ____________ from the table and slipped out the back door.
Answer: a. us, their, we, ourselves.

Question 34:
Which of the following sentences illustrates the proper use of parallel construction?
Answer: b. We painted the conference room yellow, hung a poster on the wall, and are rearranging the chairs.

Question 35:
Which of the following sentence uses correct pronoun usage?
a. to whom are your employees going to report while you’re gone?
Answer: e. All of the above

Question 36:
Choose the series of adjectives and adverbs that best completes the following sentence.
The archeologists were_____________ to discover such a __________ and__________ ____________ artifact at that mostly uncovered site.
Answer: b. amazed, rare, incredibly, beautiful

Question 37:
Change the following sentence from a quotation to indirect speech.
“I’m not feeling well,” Agatha said.
Answer: a. Agatha has said that she doesn’t feel well.

ODesk English Vocabulary Test (U.S. Version) Answers

1. Choose the word or phrase that is most nearly an antonym of the word below.
--Itinerant
a. permanent
b. flexible
c. transient
d. dissatisfied
Ans: c

2. 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
b. elicit
Ans: b

3. Choose the word that best corresponds with the definition given below.
adj. Tending to create ill will or give offense
a. labyrinthine
b. invidious
c. titillating
d. envious
Ans: b

4. Choose the word that best corresponds with the definition given below.
n. Capacity for producing a desired result; effectiveness
a. contumacy
b. defenestration
c. conversion
d. efficacy
Ans: d

5. Choose the word or phrase that is most nearly an antonym of the word below.
Lassitude
a. simplicity of speech
b. leniency
c. philanthropy
d. vigor
Ans: d

6. 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 by his team's INDOLENCE and nasty attitude.
a. violent behavior
b. odorousness
c. laziness
d. disappearance
Ans: c

7. Choose the word or phrase that is most nearly a synonym for the word in Capital Letters in the following sentence.
Her MELLIFLUOUS voice is perfectly suited to lullabies and never fails to put us all to sleep.
a. smoothly flowing; sweet-sounding
b. dull; tiresome
c. cacophonous
Ans: a

8. 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.
a. empathetic
b. dangerous
c. pathetic
d. sickening
Ans: a
9. Complete the following sentence by choosing the correct word from the options below.
The crafty spy gave a _____ name to the hotel clerk.
a. fictive
b. fictional
c. fictitious
Ans: a

10. Choose the word that best corresponds with the definition given below.
adj. Understood by or intended for only a select few or a particular group.
a. esoteric
b. eccentric
c. narcissistic
d. languid
Ans: a

11. Choose the word that best corresponds with the definition given below.
n. A position that entails little work but provides a salary.
a. quiescence
b. theocracy
c. swindle
d. sinecure
Ans: d

12. Choose the word that best corresponds with the definition given below.
adj. Sluggish; apathetic; dull
a. turbid
b. torpid
c. turgid
d. tepid
Ans: d

13. 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.
a. flouted/flouted
b. flouted/flaunted
c. flaunted/flouted
d. flaunted/flaunted
Ans: c

14. Choose the word or phrase that is most nearly an antonym of the word below.
Refute
a. expose
b. support
c. garbage
d. safe place
Ans: b

15. 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.
a. tortious
b. tortuous
c. torturous
Ans: b

16. Choose the word that best corresponds with the definition given below.
adj. Easily provoked to anger; irritable
a. sapid
b. irascible
c. jocund
d. incorrigible
Ans: b

17. 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.
a. sage
b. shriveled
c. creepy
d. jocular
Ans: b

18. 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
a. abject
b. agrarian
c. analogous
d. amalgam
Ans: c

19. Choose the definition that best reflects the meaning of the word in Capital Letters as it is used in the sentence below.
These artists really IMBUE their work with a spirit of profound freedom.
a. spoil
b. detract from; debase
c. fill or permeate with a particular feeling or quality
Ans: c

20. Complete the following sentence by choosing the correct set of words from the options below.
Our lawyers have informed us that while the new tax laws will not _____ our business directly, they may have an adverse _____ on the spending power of our customers.
a. effect/affect
b. affect/affect
c. effect/effect
d. affect/effect
Ans: d

21. Complete the following sentence by choosing the correct homophone from the options below.
The company is _____ committed to developing educational television programs for children.
a. holey
b. holy
c. wholly
Ans: c

22. Choose the definition that best reflects the meaning of the word in Capital Letters as it is used in the sentence below.
The diplomats, who have been accused of DUPLICITY by their respective countries, have been removed from their posts.
a. bad taste
b. deceitfulness; double-dealing
c. embezzlement
Ans: b

23. Complete the following sentence by choosing the correct homophone from the options below.
Oscar, who did not possess a discerning _____, preferred hotdogs to steak.
a. palette
b. pallet
c. palate
Ans: c

24. 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.
a. lay/lain/laid
b. lie/laid/lain
c. lie/lain/lain
d. lay/laid/laid
Ans: d

25. Complete the following sentence by choosing the correct homophone from the options below.
That grueling competition really tested the _____ of the gymnastics team.
a. meddle
b. metal
c. medal
d. mettle
Ans: d

26. Choose the word that best corresponds with the definition given below.
adj. Narrow-minded; limited in scope
a. hermetic
b. foreseeable
c. sporadic
d. sectarian
Ans: d

27. Choose the word or phrase that is most nearly an antonym of the word below.
Inordinate
a. reasonable
b. on a waiting list
c. unprepared
d. immense
Ans: a

28. Choose the word that best corresponds with the definition given below.
v. To issue a vehement verbal attack; to denounce explosively
a. vituperative
b. litigant
c. fulminate
d. exhume
Ans: c

29. Choose the word that best corresponds with the definition given below.
v. To impose with authority; urge strongly
a. enjoin
b. prevalent
c. dissonance
d. relegate
Ans: a

30. 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.
a. except/accept
b. except/except
c. accept/accept
d. accept/except
Ans: d

31. 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.
a. imminent/eminent
b. eminent/immanent
c. immanent/imminent
d. eminent/imminent
Ans: d

32. Choose the word that best corresponds with the definition given below.
adj. Hardhearted; unmoved by pity
a. apologetic
b. parsimonious
c. obdurate
d. abdicated
Ans: c

33. Choose the definition that best reflects the meaning of the word in Capital Letter as it is used in the sentence below.
The publicist was surprised by the INUNDATION of fan letters for her top client.
a. deluge
b. dearth
c. hindrance
Ans: a

34. Choose the definition that best reflects the meaning of the word in Capital Letters as it is used in the sentence below.
Alicia, who loved both men equally and wanted to hurt neither, found herself in quite a QUANDARY over which one she should choose.
a. happy circumstance
b. puzzling predicament
c. easy decision
Ans: b

35. 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
b. worried
c. neglected
d. laughed
Ans: a

36. Choose the word or phrase that is most nearly an antonym of the word below.
Pretentious
a. modest
b. understanding
c. uneasy
d. pleasant
Ans: a

37. 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
b. expression of affection or love
c. expression of apology or regret
Ans: a

38. 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.
a. influential
b. positive
c. hysterical
d. harmful
Ans: d

39. Complete the following sentence by choosing the correct set of homophones from the options below.
The skillful candidate's _____ speech was delightful to listen to, but failed to explain how he would achieve the ______ goals of peace and prosperity.
a. illusive/elusive
b. allusive/elusive
c. elusive/allusive
d. allusive/illusive
Ans: a

ODesk Office Skill Test Answers

1) Dr. Jones’s office, Doctor at sea, Doctor come quickly
Ans: c

2) Which of the following are considered bad manners while greeting a business visitor to your office
Ans: e) all of the above

3) which of the following file formats relate to a graphic file or scannedimage file?
Ans: e) a and d

4) What are the dimensions of an A4 size sheet of paper
Ans: d) 210 mm x 297 mm

5) Traditionally, approximately how many pages should a business CV or resume have?
Ans: a) 1-3, preferably 2

6) Which of the following are commonly used computer web browser
Ans: c) Chrome, Explorer, Firefox,

7) When reply to an e-mail, who do you place in the cc: and who in the bcc:line?
Ans: c) A person you wish to openly inform goes in the cc: line,
and the personyou wish to read the e-mail, but without knowledge
of either the recipient or the person in the cc: line, goes in the bcc: line.

8) What is very important to remember to do when entering an office business meeting
at any level, especially when clients are there?
Ans: e) a and c

9) There are 20 new PC’s in the account department. Should there be anapostrophe in PC’s?
Ans: a) No

10) What does the abbreviation CEO stand for
Ans: e) Chief Executive Officer

11) When a client visits the office and arrives early what do office etiquette require you to
do to handle the situation?
Ans: d) All of the above.

12) What does the CTRL+V shortcut accomplish in Word 2000?
Ans: b) it pastes the text that

13) You send a package through FEDEX to a client in Korea. The client calls up after a few days and
says that he has not received it. What is the best way to immediately let the client know the status of a courier?
Ans: d) Track the packet on the FEDEX website and send the client a copy of thecurrent status of packet.

14) What is flexi-time
Ans: b) The flexible use of personal office hours, such as working an hour earlier one day,
in order to leave an hour earlier another day

15) What does the glass ceiling refer to in a business context?
Ans: c) The upper level of senior management or company execution positions
which is traditionally hard to break through, for example, for women and/or minorities.

16) What is the best way to handle an angry colleague or client with acomplaint?
Ans: a) listen to their concerns, and calmly but firmly explain what you are able todo,
offering other solutions and oppositions without getting angry in turn.

17) What are the traditional office hours in the Western world, now muchmore flexible, though still adhered to in most office?
Ans: a) 9 a.m. – 5 p.m.

18) What common injury can result from too much concentration typingover too little amount of time?
Ans: d) Repetitive strain injury

19) What does administration generally handle in an office environment?
Ans: c) The efficient day-to-day running of the office, with regards to companyfiles, communication, management of jobs such as overseeing hiring andfiring and human resources, etc.

20) What is the benefit of e-mailing documents rather than always providinghard copies to individuals?
Ans: d) b and c

21) What is the difference between Microsoft Access and Microsoft Excel?
Ans: b) Access is mainly for database and Excel is for spreadsheets

22) What is the person in charge of administering an office commonly called?
Ans: d) CEO

23) Which of the following activities could possibly infect your computer with virus?
Ans: a) Installing pirate software from a CD

ODesk Microsoft Execl 2000/2003 test answers

01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Ans: It allows you to scroll through two or more workbooks simultaneously

02. Which of the following functions would return a value of 8?
Ans: round(8.4999,0)

03. 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 bellow?
B1:27
B2:22
B3:28
B4:21
Ans: 0

04. How can you select all the blank cells in your worksheet?
Ans: Choose blank in the Edit->Go to->special Menu option

The question is based upon the figure shown
05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Ans: Its adds up the values in the selected cells

06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
Ans: Use the wrap txt option in the Format->Cells>Alignment Menu

07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: #N/A

08. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get John_Smith in Cell C1?
Ans: = A1&”_”&B1

09. Which of the following date and time function will you use to return the serial number of the last day of the month before or after specified number of months?
Ans: EOMONTH

10. Which of the following shortcuts can be used to insert a new line in the same cell?
Ans: Alt+Enter

11. Which of the following function you will use to find the highest number in a series of numbers?
Ans: MAX(B1:B3)

12. State Whether True or false.
Ans: True

13. This question is based upon the figure bellow
What does the purple triangle at the bottom right corner of the cell signify?
Ans: Smart Tag

14. You have created a worksheet which consists a 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

15. This question is based upon the figure shown bellow
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
Ans: There is a comment associated with the cell

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

17. The figure shows the calculation tab under the Tools->options menu. The option under Calculation has been checked as Automatic. What does this mean?
Ans:c

18. Which of the following statements regarding the QUARTILE function is not true?
Ans: The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.

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

20. This question is based upon the figure shown below
What will be the value in the cell C2 as shown in the figure when we use formula = A2+B2?
Ans: 120

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

22. What does the NOW() function returns?
Ans: Returns the serial number of the current date and time

23. A smart tag will be removed from a cell when……………….
Ans: The data in the cell is changed or deleted

24. You would like to restrict the values that can be entered into a cell so that only whole numbers between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?
Ans: The setting tab under the menu Data->Validation

25. What should you add before a fraction to avoid it as a date, e.g.1/3, in Excel?
Ans:D

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

27. How does the AutoComplete feature in Excel help you save time?
Ans: It automatically completes abbreviated words

28. The 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

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

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

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

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

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

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

35. The figure shows an Excel worksheet. If you want to F 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

36. Which of the following functions would return a value of 8?
Ans: b and c

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

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

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

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

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

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

43.Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans: #N/A

44. Which of the following function you will use to find the highest number in a series of numbers?
Ans: MAX(B1:B3)

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

46. 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: #N/A

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

48. What does the NOW() function returns?
Ans: Returns the serial number of the current date and time

49. Which toolbar is shown in the figure?
Ans: Forms toolbar

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

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

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

53. The multiplication arithmetic operator is represented by which of the following symbols
Ans: *

54. You can select the current row by pressing
Ans: Shift + Spacebar

55. Donelp you do this?
Ans: Select the cells, open the Window menu and click on Hide

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

57. 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->Print What->Selection. What will happen?
Ans: The selected area will be printed

58. By default, how is text horizontally aligned inside a cell in Excel?
Ans: Left aligned

59. When using the AutoFill handle to quickly fill a range of cells with the same or consecutive data, the cells need not be adjacent as long as they are within the same sheet.
Ans: False

60. When the AutoSum button is clicked, Excel first looks for a range of numbers above the active cell.
Ans: True

61. A relative cell reference changes when a formula is copied or moved to other locations.
Ans: True

62. If cell entries are changed, the formula will automatically recalculate the values and insert the result in the cell containing the formula.
Ans: True

62. The Merge button on the Formatting toolbar will merge selected cells and right align data within the cells.
Ans: False

63. To move the insertion point down to the next cell, press:
Ans: Enter

64. The cell range A3 through G3 should be keyed in as:
Ans: A3:G3

65. A document created in Excel is referred to as a
Ans: workbook

67. Use this handle to automatically insert the next month in the series, January:
Ans: Fill

68. Which of these operators are in the correct order of operations?
Ans: ^,*,-

69. If the text you entered into a cell does not fit, Excel will display ##### to indicate that the text is too long
Ans: True

70. By default, data in a cell is centered
Ans: False

71. When a new row is added into an Excel worksheet, by default, this row will be inserted just below the active cell.
Ans: True

72. To insert a row, click Insert and then Rows
Ans: True

73. The Split option causes the worksheet to be split into two window panes.
Ans: False

74. A column is inserted immediately to the left of the column containing the active cell unless you choose otherwise
Ans: True

75. To delete a specific cell as well as the text within it, make the cell active and then
Ans: click Edit and then Delete

76. Which of the following is an absolute cell reference
Ans: $B3

77. To select nonadjacent cells, columns, or rows, you must
Ans: hold down the Ctrl key while clicking column, row header, or specific cells

78. When copying selected cells to a new location, you must position the mouse pointer on any border around the selected cells until it turns into a(n)
Ans: arrow pointer

79. When data is linked, a change made in a linked cell is automatically made to other cells in the link.
Ans: True

80. Selected cells and cell contents can be moved or copied within a worksheet but not between worksheets.
Ans: False

81. Time in a cell in Excel is stored as a decimal fraction representing a portion of the day
Ans:True

82. The PMT function is used to calculate a loan payment based on a variable interest rate, payment, and the time period.
Ans: False

83. The gridlines that appear on your worksheet will print as displayed.
Ans: False

84. The FV function is used to calculate the future value of an investment based on a periodic constant payment and interest rate
Ans: True

85. To apply page numbering to a worksheet page, which option in the Page Setup dialog box should you choose
Ans: Header/Footer

86. If a function is included in an argument within a function, it is called a
Ans: Nested Function

87. If you want row and column headings to print, which tab do you click from the Page Setup dialog box?
Ans: Header/Footer

88. A new workbook initially contains this many sheets
Ans: Three

89. An Excel workbook saved in HTML format allows Internet or intranet users to have access to workbook data even if they do not have Excel installed
Ans: True

90. Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells
Ans: False

91. Certain chart elements automatically inserted in a chart created by Chart Wizard include a chart legend, labels for the x-axis and y-axis, and a chart title
Ans: False

92. You can double-click a chart element to display the appropriate formatting dialog box.
Ans: True

93. You can change the size of an image by using the white sizing handles.
Ans: True

94. To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Ans: False

95. Which of the following is not a tab on the Chart Options dialog box?
Ans: Patterns

96. This chart is the default chart
Ans: Column Chart

97.Which of the following displays the contents of the active cell?
Ans: Formula bar

98. A worksheet is an individual page or tab in the workbook.
Ans: True

99. You can copy cell formats from one cell to another by using the
Ans: Format Painter

ODesk MS Word 2007 test answers

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 in

oDesk Windows XP Tests Answers

Everyone take this test for getting more job.

QUESTION 1:Which of the following statements is true if you open an existing file, make changes to it, and save it with a new name?

a.The original file will be deleted.

b.The original file remains unchanged.

c.The changes will be saved in the original file

d.The original file is sent to the Recycle Bin

Ans:b

QUESTION 2:The left side of the Start menu contains two parts, separated by a thin horizontal line. The Windows XP term for manually inserting a shortcut to one of your chosen applications into the top part of the left side (by using the right-context menu of the application in Windows Explorer) is called:

a.Attaching an application to the Start menu.

b.Pinning an application to the Start menu

c.Placing an application into the Start menu.

d.Porting an application to the Start menu

Ans:a

QUESTION 3:Which of the following features is/are available in Windows XP?

a.A built-in CD burner

b.Windows Media Player

c.Windows antivirus

d.Internet Connection Firewall

e. Microsoft Excel

Ans:a,b,d

QUESTION 4:The Microsoft file format that contains the bitmapped graphics and metadata for the skins used in the three preinstalled Windows XP visual themes is:

a..msthemes

b..msstyles

c..msskins

d..msluna

Ans:a

QUESTION 5:Which of the following statements about the Stand By option while shutting down your computer is/are correct?

a.It waits for 5 minutes before shutting down the computer.

b.It helps to conserve power by shutting off some hardware, like the hard disk.

c.It shuts down the computer for a specific time and then restarts it.

d.Stand By will save your desktop and all open files to a special Windows file called hiberfil.sys. This file usually resides in the computer's root folder (C:\hiberfil.sys).

Ans:b

QUESTION 6:Which statement(s) about the Recycle Bin is/are correct?

a.All deleted files except media files are sent to the Recycle Bin

b.You can restore any selected files from the Recycle Bin folder by right clicking and then selecting Restore.

c.The Recycle Bin stores files for one month before permanently deleting them.

d.More than one file at a time cannot be restored from the Recycle Bin.

Ans:b

QUESTION 7:Which of the following statements about Windows XP features is/are correct?

a.Windows XP can automatically download updates.

b.Windows XP offline files allows you to synchronize your files with your file server.

c.If Fast User Switching is enabled, you cannot use offline files.

d.There is a "System Restore" functionality within Windows XP.

Ans:abd

QUESTION 8:While viewing file names through the Windows Explorer, what happens if you drag and drop a file named letter1.txt on top of another file named letter2.txt lying in the same folder?

a.The contents of letter2.txt will be replaced by the contents of letter1.txt.

b.The contents of letter1.txt will be replaced by the contents of letter2.txt.

c.The contents of letter1.txt will be appended to the contents of letter2.txt.

d.The contents of letter2.txt will be appended to the contents of letter1.txt.

e.Nothing will happen.

Ans:e

QUESTION 9:Which of the following type of objects can you search on your computer and on the network, using Windows XP Search Companion?

a.People in your contact list

b.Pictures

c.Documents

d.Windows Help

e.All of the above

Ans:e

QUESTION 10:You can create and edit files using the Windows Notepad. What is the extension of a file that has been created using Notepad?

a..doc

b..text

c..txt

d..html

Ans:c

QUESTION 11:Microsoft makes available a tool called the _____________________ for checking computers with a Windows operating system. This tool helps remove infections left by third-party software installed on the computer and displays a report describing the outcome in a log file named mrt.log in the %WINDIR%\debug folder.

a.Microsoft Reliability Tool

b.Microsoft Windows Malicious Software Removal Tool

c.Microsoft Windows Antivirus Tool

d.Microsoft Recovery Tool

Ans:b

QUESTION 12:Windows XP includes a new type of view for folders that contain graphics files. This folder view is called _________ and displays small images of all the graphics in the folder in the bottom right-hand pane of Windows Explorer and a large image of a selected picture in the top right-hand pane.

a.Gallery

b.Images

c.Pictures

d.Filmstrip

Ans:a

QUESTION 13:You have created a directory called TEST that includes the files test1.txt, test2.txt, test3.txt, test4.txt, test5.txt, and test6.txt. How can you select test2.txt, text3.txt, and test6.txt from the list of files visible in the Windows Explorer?

a.Press Ctrl and click on the three required files, one by one.

b.Press Shift and click on the three required files, one by one.

c.Press Alt and click on the three required files, one by one.

d.Right-click each file name, one by one, and choose the Cut option.

Ans:a

QUESTION 14:State whether the following statement is true or false.

With Windows XP, you cannot specify that files with certain file name extensions should always open in the same program.

a.True

b.False

Ans:b

QUESTION 15:What should you type on the command prompt to return back to Windows?

a.Quit

b.Return

c.Leave

d.Exit

Ans:d

QUESTION 16:Starting with Windows 95, the File Manager tool for organizing and controlling the files and folders of the computer's storage systems, such as the hard drive(s) and disk drive(s) has been called:

a.Windows Manager

b.Internet Explorer

c.Windows Explorer

Ans:c

QUESTION 16: Windows Ta:Windows XP has several command-line utility tools for troubleshooting the computer. Suppose that your computer seems to have a problem with connecting to the Internet. Before reporting your connectivity problems to your ISP, which tool could you use to display the current TCP/IP network configuration values and to refresh the Dynamic Host Configuration Protocol (DHCP) and Domain Name System (DNS) settings?

a.Ping

b.Ipconfig

c.Tracert

d.Msconfig

Ans:c

QUESTION 18:Which of the following activities can you accomplish with the Remote Desktop feature in Windows XP?

a.You can get a miniature view of your desktop by clicking on the Desktop icon.

b.You can automatically clear up unwanted Desktop icons.

c.You can view files and documents on your computer's desktop from a coworker's computer.

d.You can view files and documents on any computer's desktop from your computer.

Ans:d

QUESTION 19:Windows XP tracks whatever files that load during every boot and application launches, and the operating system uses that information to prefetch files into RAM. These prefetch data are parsed into a file named __________ located in the Windows\Prefetch folder on the boot drive. Every three days, a limited defragmentation operation automatically occurs in the background during idle for only those files in that file to further speed up the computer's file access.

a.Defrag.sys

b.Prefetch.sys

c.Defrag.ini

d.Layout.ini

Ans:b

Microsoft Excel 2000 Test

oDesk ms excel 2000 test only for data entry job.

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: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 ‘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: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: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: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: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?

Ans: #N/A

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: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:#N/A

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

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

Microsoft Excel 2010 Test

Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.

Ans: a

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

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?
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.
Ans: c

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?

a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Ans: c

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?

a. Through
b. Square
c. In Font of Text
d. In Line with Text
Ans: b

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?

a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.
Ans: b

Question: A particular chart layout can be applied to a chart only if:
a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.
Ans: c

Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.
Ans: a

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

Question: With which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above

Ans: b

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

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?
a. BMP
b. PDF
c. XLS
d. JPG
Ans: c

Question: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Ans: b

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?

a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.

Ans: c

Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous

Ans: d

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.

a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Ans: c

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?

a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas
Ans: b

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.

a. True
b. False

Ans: b

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.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table

Ans: a

oDesk Search Engine Optimization Answers

Question: Which of the following search engines or directories provides the directory search results for Yahoo?

a. Windows Live

b. Yahoo Directory

c. Google

d. Wikipedia

e. DMOZ

Ans: B

Question: Which of the following statements regarding website content are correct?

a. If you have two versions of a document on your website, Google recommends that you only allow the indexing of the better version

b. Linking to a page inconsistently does not affect the way Google views the page/s. Examples of inconsistent linking could be http://www.expertrating.com/page/ and http://www.expertrating.com/page and http://www.expertrating.com/page/index.htm

c. Syndicating your content could lead to Google viewing the material as duplicate

d. Placeholders for pages which do not have content are never viewed as duplicate content by Google

Ana:c

Question: What is Keyword Density?

a. The number of times the keyword is used / (DIVIDED BY) the total word count on page - (MINUS)the total words in HTML on the page

b.The number of times the keyword is used X (MULTIPLIED BY) the total word count on page

c.The number of times the keyword is used in the page description

d.The number of times the keyword is used in the page title

e.The number of times the keyword is used / (DIVIDED BY) the total word count on the page

Ans: D

Question: Which of the following statements about the Google Sitemap are correct:

a.Repeated submission of the Sitemap to Google could be penalized

b.It is possible to create and submit specialized Sitemaps to Google for Video and Mobile content

c.The Sitemap acceptable to Google follows an XML format

Ans: A

Question: Are RSS/Atom feeds returned in Google's search results?

a.Yes

b.No

Ans: B

Question: What does the term Keyword Prominence refer to?

a.It refers to the fact that the importance of choosing high traffic keywords leads to the best return on investment

b.It refers to the importance attached to getting the right keyword density

c.It refers to the fact that the keywords placed in important parts of a webpage are given priority by the search engines

d.It refers to the fact that the keywords in bold font are given priority by the search engines

Ans: C

Question: Which of the following factors does Google take into account while assessing whether or not a website is an authority website?

a.The frequency with which the content of the website is updated

b.The number of web pages containing relevant information on the main theme of the website

c.The number of in-bound natural links related to the website's theme (or keywords)

d.None of the above

Ans: A,B,C

Question: What is Anchor Text?

a.It is the main body of text on a particular web page

b.It is the text within the left or top panel of a web page

c.It is the visible text that is hyper linked to another page

d.It is the most prominent text on the page that the search engines use to assign a title to the page

Ans: C

Question: If you search for the term "iq test" in the Word Tracker keyword suggestion tool, will it return the number of independent searches for the term "iq"?

a.Yes

b.No

Ans:B

Question: What is the illegal act of copying of a page by unauthorized parties in order to filter off traffic to another site called?

a.Trafficjacking

b.Visitorjacking

c.Viewjacking

d.Pagejacking

Ans: D

Question: Do search engines such as Google detect unnatural linking patterns by checking the Class C IP address of the page where the link to the website originates?

a.Yes

b.No

Ans: A

Question: What term is commonly used to describe the shuffling of positions in search engine results in between major updates?

a.Waves

b.Flux

c.Shuffling

d.Swaying

Ans: B

Question: While grading your website, Google gives credit to outbound links pointing to authority websites?

a.True

b.False

Ans: B

Question: Which of the following URLs can the Google search engine spider?

a.http://www.expertrating.com/exams/seo.asp?examnum=243&examtype=244

b.http://www.expertrating.com/exams/seo.asp?examnum=243

c.http://www.expertrating.com/exams/seo.asp

d.http://www.expertrating.com/exams/seo.html

e.All of the above

Ans: E

Question: Google displays up to _____ characters of a webpage's Title Tag.

a.56

b.60

c.66

d.80

Question: What does the 302 server response code signify?

a.It signifies conflict, too many people wanted the same file at the same time

b.The page has been permanently removed

c.The method you are using to access the file is not allowed

d.The page has temporarily moved

e.What you requested is just too big to process

Ans: D

Question: Which of the following statements is correct with regard to the description meta tag?

a.It should be about 50 characters in length

b.The description should not contain the keywords

c.If the meta description is not included, the search engines will use the meta keywords for information

d.Google uses the meta description to generate the search engine results pages

Ans: D

Question: State whether true or false.

The Yahoo Directory listing is a free service for commercial sites.

a.True

b.False

Ans: A

Question: Which of the following statements is correct with regard to the images within a webpage?

a.Images cannot be spidered by the search engines

b.Important keywords related to the image should be placed in the ALT text

c.Images should always be kept close to the top of a webpage

d.Image maps should be used while including the images

Ans: B

Question: Cloaking is a controversial SEO technique. What does it involve?

a.Increasing the keyword density on the web pages

b.Offering a different set of web pages to the search engines

c.Hiding the keywords within the webpage

d.Creating multiple pages and hiding them from the website visitors

Ans: B

Question: Which of the following facts about Alexa are correct?

a.Alexa provides free data on relative website visitor traffic

b.Alexa and Quantcast provide information on visitor household incomes

c.Alexa is biased towards US based traffic

d.Quantcast only tracks people who have installed the Quantcast toolbar

ANS: A

Question: Google looks down upon paid links for enhancing page rank. If a website sells links, what action/s does Google recommend to avoid being penalized?

a.The text of the paid links should state the words "paid text link" for Google to identify it as a paid link

b.Only Paid text links to non profit websites should be accepted

c.Paid links should be disclosed through the "rel=nofollow" attribute in the hyperlink

d.Paid links should be disclosed through the "index=nofollow" attribute in the hyperlink

Ans: C

Question: Which of the following actions could get you banned by Google?

a.Hiding text on the webpage

b.Stuffing keywords on the webpage

c.Linking to sites banned by Google

d.None of the above

Ans: A

Question: Which of the following statements about Google's technical and quality guidelines is true?

a. It is advantageous if your web server supports the If-Modified-Since HTTP heade

b. If using dynamic pages, it helps to keep the parameters short and the number of them few

c. Avoid using robots.txt to prevent crawling of search results pages or other auto-generated pages, even if they don't add much value for users coming from search engines

d. Submitting new pages of your website at http://www.google.com/addurl.html as soon as they are online, helps to speed up indexing

Ans: B

Question: Which of the following is an ethical SEO Technique?

a.Creating a subdomain with the hottest keyword and creating duplicate copies of existing pages on it

b.Filling your pages with keywords, whether relevant to the page content or not

c.Creating a page which serves a different content to the search engine bots and different to human users

d.None of the above

Ans: D

Question: All major search engines are case sensitive.

a.True

b.False

Ans: B

Question: While optimizing your website it is important to generate the right type of traffic, how does the Bounce Rate information help in this regard?

a.By letting you know the percentage of users who entered the website and then went on to visit additional pages

b.By letting you know the percentage of users who entered the website and then left without viewing any other page

c.By letting you know the percentage of users who decided to go back to the source from where they found your website

d.By letting you know the percentage of users who left your website within 10 seconds of viewing the first page

Ans: B

Question: Which of the following factors contribute towards link popularity of a website?

a.The number of websites that link to it

b.The number of pages of the website indexed by Google

c.The number of pages in the website

d.The quality of websites that link to it

Ans: A,B,C,D

Question: Search engines do not index some common words (such as "or", "and", "when", and "in") within the webpage. What are these common words called?

a.Barrier words

b.Non-indexable words

c.Slow words

d.Stop words

Ans: D

Question: Which of the following activities could be looked down upon by Google as per their quality guidelines?

a.Using automated website submission software

b.Loading pages with irrelevant links

c.Intentionally adding keywords to the TITLE tags and ALT attributes

d.Registering misspellings of well-known websites

Ans: B,C

Question: Which of the following statements about RSS are correct?

a.It is a form of XML

b.tstands for Realtime streamlined syndication

c.It is a good way of displaying static information

d.It is a Microsoft technology

Ans: A

Question:_________ is usually the best web page to get linked to while receiving a themed in-bound link from another website.

a.The sitemap

b.The contact page

c.The home page

d.The page which you would like to improve in the search engine rankings

Ans: D

Question: Which of the following can be termed as good keyword selection and placement strategies?

a.Targeting synonyms of the main keyword

b.Targeting the highest searched keywords only

c.Copying competitor keywords

d.ofive or more keywords per page

ANS: A, D

Question: If your site is not appearing in Google search results because of some unethical SEO practices in the recent past, _________________.

a.abandon and close your website permanently.

b.modify the page contents, make them useful and relevant to the human users, and request Google to reconsider your site.

c.start a PPC campaign to get your site included in the sponsored results.

d.it is better to discontinue the website and shift your webpages to a fresh website with a new domain name.

Ans: D

Question: Which of the following statements about search engine optimization techniques are correct:

a.Making a keyword bold does not influence the way that the search engine looks at the keyword

b.Websites with deep linking are looked at favorably by search engines

c.search engine robots follow the first link they find to any particular page and they do not follow additional links to the same page

d.It is not a good idea to have the same anchor text for all inbound links as it could look automated to the search engines

Ans: A, B, D

Question: A Hallway Page is used to:

a.Attract visitors from the search engines straight onto the Hallway Page

b.Organize the Doorway Pages

c.Help people navigate to different Doorway Pages

d.Enable search engine bots to index the Doorway Pages

Ans: D

Question: Which of the following free tools/websites could help you identify which city in the world has the largest search for the keyword - "six sigma"?

aYahoo Search Term Suggestion Tool

b.Alexa

c.Google Traffic Estimator

d.Google Trends

e.WordTracker

Ans: D

Question: How are site maps important for the search engine optimization process?

a.Site maps help the search engine editorial staff to quickly go through a website, hence ensuring quicker placement

b.Ggives credit to the websites having site maps. The GoogleBot looks for the keyword or title "Site Map" on the home page of a website.

c.Site maps help the search engine spider pick up more pages from the website

d.None of the above

Ans: C

Question: State whether the following statement is true or false.

A Sitemap provides a list of internal links to user accessible pages on a website.

a.True

b.False

Ans: A

Question: What is the function of "indexer" part of the Google search engine?

a.It helps to retrieve web pages from the world wide web

b.It helps to gather information from other search engines

c.It helps to sort the documents that Google has retrieved

d.It helps to generate meaningful results based upon the user's search term

Ans: D

Question: Which of the following conditions will Google treat favorably from the 'Relevancy' perspective?

a.The website offering products and services to the visitors country

b.A website that provides free content for the related keywords

c.Hidden keywords on the home page matching the search term

d.Image Alt tags on the home page matching the search term

Ans: D

Question: Some words, when followed by a colon, have special meanings to Yahoo. What is performed by the link: operator?

a.It shows all the outbound links from the URL

b.It shows how many pages of the site Yahoo is pointing to

c.It shows all the pages that point to that URL

d.It shows URLs with broken links

ANS: C

Question: Which of the following factors have an impact on the Google PageRank?

a.The total number of inbound links to a page of a web site

b.The subject matter of the site providing the inbound link to a page of a web site

c.The text used to describe the inbound link to a page of a web site

d.The number of outbound links on the page that contains the inbound link to a page of a web site

ANS: A

Question: What is the term for Optimization strategies that are in an unknown area of reputability/validity?

a.Red hat techniques

b.Silver hat techniques

c.Grey hat techniques

d.Shady hat techniques

ANS: C

Question: Why is it a bad idea from the seo perspective to host free articles and write ups that are very common on the internet.

a.Because they will not lead to fresh traffic

b.Because you could get penalized by search engines for using duplicate content

c.Because you will not get the benefits of proper keyword targeting

d.Because people could turn up claiming copy right infringement

ANS: B

Question: The following robots meta tag directs the search engine bots:

<META NAME="robots" CONTENT="noindex,nofollow">

a.Not to index the homepage and not to follow the links in the page

b.Not to index the page and not to follow the links in the page

c.To index the page and not to follow the links in the page

d.Not to index the page but to follow the links in the page

ANS: B

Question:_________________ use both crawlers and directories to generate relevant results.

a.Crawler-based Search Engines

b.Human-Powered Directories

c.Hybrid Search Engines

d.Meta Search Engines

ANS: D

Question: Which of the following statements is correct with regard to natural links?

a.They are two way links (reciprocal links)

b.They are from authority websites

c.They are voluntary in nature

d.They are from .edu or .gov extension websites

ANS: C

Question: What will happen if you type the words 'Certification -Networking' in the Google search box?

a.Google will find the web pages about Certification and also containing the word "Networking"

b.Google will find all the web pages containing the words "Certification" and "Networking"

c.Google will find all the web pages in which the words "Certification" and "Networking" appear together

d.Google will find the web pages about Certification that do not contain the word Networking

ANS: D

Question: If you enter 'Help site:www.microsoft.com' in the Google search box, what will Google search for?

a.It will open up the Google help pages applicable to www.expertrating.com

b.It will find pages about help within www.expertrating.com

c.It will only find page titles about help within www.expertrating.com

d.It will direct you to the request page for re-indexing of www.expertrating.com

ANS: B

Question: Which of the following statements about FFA pages are true?

a.They are greatly beneficial to SEO

b.They are also called link farms

c.They are paid listings

d.They contain numerous inbound links

ANS: B

Question: What is the name of the search engine technology due to which a query for the word 'actor' will also show search results for related words such as actress, acting or act?

a.Spreading

b.Dilating

c.RSD (real time synonym detection)

d.Stemming

e.Branching

ANS: D

Question: If a website's search engine saturation with respect to a particular search engine is 20%, what does it mean?

a.20% of the webpages of the website have been indexed by the search engine

b.Only 20% of the pages of the website will be indexed by the search engine

c.20% of the websites pages will never be indexed

d.The website ranks in the first 20% of all websites indexed by the search engine for its most important search terms

ANS: A

Question: What is the main reason for the effectiveness of optimizing a webpage towards a long tail keyword search?

a.There are more long tail searches than shorter keyword queries

b.Search engines often pass on long tail searches to lesser known and new websites

c.Search engines do not pass on long tail search traffic to websites that rank high for shorter keyword searches

d.There are fewer websites that have targeted such keywords

ANS:A

oDesk Css test solution

Question 1:Which of the following is true for a class selector?

a. It uses a hash as the separator symbol

b. It applies the style to only the first element defined with that style

c. It applies the style to only the last element defined with that style

d. It applies the style to all the elements defined with that style
Ans:D

Question 2:

Which of the following does not apply to external styles?

a. Clean separation of design & content

b. Minimal code duplication

c. Highest priority

d. Reduces page download time

Ans: C

Question 3:

Read the following Code:

BODY {

Background: white url(“bar.gif”);

Background-repeat: repeat-y;

Background-position: center;

}

What will be the output of this code?

a. Image bar.gif will be tiled vertically in the background in the center of the page.

b. Image bar.gif will be tiled horizontally in the background in the center of the page

c. Image bar.gif will be displayed in the center of the page

d. Image bar.gif will be stretched in the center of the page

Ans: A

Question 4: Which of the following is not a valid text-decoration option?

a. Text-decoration :line-through

b. Text-decoration :in-line

c. Text-decoration :overline

d. Text-decoration :underline

e. Text-decoration :none

Ans: B

Question 5:

You defined some links as follows:

A:link{color:green}

A:visited{color:blue}

A:hover{color:red)

A:active{color:black}

What will be the color, when the mouse goes over a link?

a. Green

b. Blue

c. Red

d. Black

Ans: B

Question 6:

The following is a style definition:

Td#aln

{text-align:center;

color:blue}

How will you refer to this style in your web page?

A. by using the class attribute in a td cell·

B. by using the id Attribute in a td cell·

C. by using the class attribute in any html element which supports the class attribute·

D. by using the id attribute in any html element which support the id attribute·

Ans: B

Question 7: Which of the following is not a valid property of an aural style sheet?

a. Cue

b. Voice-family

c. Load

d. Speak

Ans: C

Question 8:

Your website displays some articles on java programming. The articles contain blocks of java code as well. If you want to leave ‘1 cm’ space above and below the code blocks, you would use:

a. Code{margin:1cm}

b. Code{margin-top:1cm; margin-bottom:1cm}

c. P{margin:1cm}

d. P{margin-top:1cm; margin-bottom:1cm}

Ans: B

Question 9:

Text text text text

A Text text

Sentence text text

Inside text text

A text ext

Text text text

Text text

Text text text text

You have and article of 100 lines. If for instance, you want to describe the theme with a few lines inside the text highlighted separately as show in the image which of the following property will you use?

a. Outline

b. Display

c. Float

d. Merge

Question 10:

You are fetching customer names from a database. The names in the database are mostly in lowercase. What is the name of the text property which will facilitate capitalization of these names?

a. Text-mode

b. Text-transform

c. Text-decoration

d. Text-shadow

e. Text-case

Ans: B

Question: 11:

Here is one of the styles defined in your webpage:

.redborder

{

border-color:#ff0000;

border-width:thin thick

}

What type of border will be displayed if one of the paragraphs defined in the webpage uses this style?

a. This will display a red border with thin top and bottom

b. This will display a red border with thick top and bottom

c. This will display a red border with thick left and right

d. This will not display any border

Question 12: Which of the following are correct values of the overflow property?

a. Visible

b. Hidden

c. Scroll

d. Auto

Ans: A,B,C,D

Question 13: Which of the following is correct?

a. Blockquote{text-padding:2em 4em 5em}

b. Blockquote{padding-x:2em 4em 5em}

c. Blockquote{padding-y:2em 4em 5em}

d. Blockquote{padding:2em 4em 5em}

Question 14: Which element property is required to define internal styles?

a. Class

b. Style

c. span

d. link

Ans: B

Question 15 Which style property can be used to display only some part of an image?

a. Snap

b. Clip

c. Scroll

d. Visible

Question 16 Which of the following is not true for a style sheet?

a. A style sheet defines how an html element will be displayed

b. Internal and external style sheets can not be used together

c. Multiple style definitions will cascade into one

d. The same style sheet can be used by many html pages

Ans: A

Question 17 Which of the following font properties deals with aspect value?

a. Font-weight

b. Font-variant

c. Font-size-adjust

d. Font-size

Question 18:

Consider this style definition:

P i{color:red}

What do you understand about the contextual selector used above?

a. All the text within a paragraph will be italicized

b. All the italic text in the page will have red color

c. All the page text under
tag and tag will be red

d. All the italic text with in a paragraph will be red

Question 19

Background-position sets the position of the background image what happens if its value is 0% 0%?

a. Image will have zero width and height so it will be hidden.

b. Image will be positioned at the upper left corner.

c. Image will be positioned at the lower right corner

d. None of the above

Question 20: You want to increase the space between the lines in all you paragraphs. What will you use?

a. P{width:1cm}

b. P{height: 1cm}

c. P{line-height:1cm}

d. P{line-width:1cm}

Ans: C

Question 21: The default value for the overflow property is:

a. Scroll

b. Visible

c. Hidden

d. Auto

Ans: C*

Question 22:

Which of the following will set the page size to 8.5 inches x 11 inches with 2cm margin al all sides?

a. @page {width:8.5in;Height:11in; margin:2cm}

b. @page {width:8.5in x 11in; margin:2cm}

c. @page {size:8.5in 11in; margin:2cm}

d. @page {size:8.5in 11in; margin:2cm}

Question 23: Which of the following is not a valid list property?

a. List-style-type

b. List-style-position

c. List-style-image

d. List-style-align

Question 24: Which of the following is not a pseudo class?

a. Link

b. Active

c. Lang

d. Ins

Question 25: Which of the following Statement is correct?

a. When using css, positioning can be absolute, relative or dynamic

b. The float Property for text/images can be left, right or center

c. The values of visibility can be true or False

d. The display Property sets how an element is displayed

Question 26:

The Font “Times New Roman” has an aspect value of 0.46 .What do you understand from this?

a. When font size is set to 46px. The height of the letter ‘x’ will be 100px

b. When font size is set to 100px. The height of the letter ‘x’ will be 46px

Question 27: The font-family property is used to specify a:

a. Family name

b. Generic Family

c. Family name and /or generic Family

Question 28: Paged media differ from continuous media in that the content of the document is divided into one or more pages. When you set the dimensions, which of the following will be applied?

a. The dimensions of the page area are the dimensions of the page box minus the margin area

b. The dimensions of the page area are the dimensions of the page box plus the margin area

c. The dimensions of the page area are the dimensions of the page box and margin area does not affect it.

d. None of the above

Question 29: Which of the following is not a correct keyword value for the display property?

a. Expended

b. Inline-table

c. Table-row

d. Table-column-group

Question 30: Which of the following properties specifies the minimum number of lines of a paragraph that must be left at the bottom of a page?

a. Orphans

b. Widows

c. Bottom

d. Overflow

e. None of the above

Question 31 Which of the following is correct with regard to comments in a style sheet?

a. Comments can appear outside the style definition only

b. Comments start with//

c. Comments end with */

d. Comments are not permitted in a style sheet

Question 32 Which of the following border styles is not correct?

a. Border-style: ridge

b. Border-style : outset

c. Border-style : dotted

d. Border – style : matted

Question 33: How will you display text as a superscript?

a. Vertical-align: super

b. Vertical-align: superscript

c. Vertical-align : top

Question 34

The following is a style definition:

#styl2

{

Color: red;

}

How will you refer to this style in you web pages?

a. By using the class attribute in a td cell

b. By using the id attribute in a td cell

c. By using the class attribute in any html element which supports the class attribute

d. By using the id attribute in any html element which supports the id attribute.

Question 35 Which of the following is true for an ID selector?

a. It uses a dot as the separator symbol

b. It applies the style to only the first element defined with that selector

c. It applies the style to only the last elements defined with that selector

d. It applies the style to all the elements defined with that selector

Question 36: Which of the following values are correct for Font-style?

a. Normal, wider, narrower

b. Normal , italic, oblique

c. Normal, bold, lighter

d. Small , medium , large

oDesk HTML 4.01 Test Answer

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.

Ans: b. It defines the start of a long quote.

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.

Ans: b. XHTML is almost identical to HTML 4.01.

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.

Ans: b. HTML is case sensitive.

Question no. 4 Which of the following tags can be used in place of a button tag?

a. legend
b. ol
c. input
d. dl

Ans: c. 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

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

Ans: c. default

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

Ans: a. text , 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

Ans: d

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

Ans: a,b,c

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.

Ans: a

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.

Ans: ()

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.

Ans: b,c

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

Ans: d

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

Ans: a

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

Ans: d

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.

Ans: b

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.

Ans: a

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

Ans: ()

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.

Ans: d

Question no. 20 The tag that is used to pass the parameters to an applet is:

a. appletpar
b. applet
c. param
d. val

Ans: c

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

Ans: d

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

Ans: b

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

Ans: a

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>

Ans:c

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"/>

Ans: d

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"

Ans: b

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.

Ans: c

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

Ans: b

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

Ans: b

Question no. 30 How will you specify a comment in an HTML document?

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

Ans: c

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.

Ans: b

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.

Ans: b

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.

Ans: e

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>

Ans: ()

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

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.

Ans: a

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.

Ans: c

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>

Ans: b

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

a. method
b. action
c. name
d. id

Ans: b

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

a. <td>
b. <th>
c. <tt>
d. <b>

Ans: b

Odesk PHP 5 test answers

PHP 5 test for Web designer and Developers to get more job on oDesk.

Question: What is true regarding this code?

Ans: setcookie will return true

Question: Which of the following is not a correct way of printing text in php5?

Ans: echo "Plain text";

Question: Which of the following is not the correct way of starting a session?

Ans: session_initiate()

Question: Which of the following functions do you need to implement HTTP Basic Authentication?

Ans: None of the above

Question: Which of the following Command Line Interface constant is not defined in the CLI SAPI?

Ans: STDPRT

Question: Which of the following statements is correct with regard to final and abstract?

Ans: a. An abstract class cannot have final methods

Question: Which composite data types are supported by php?

Ans: Array

Question: The default value of register_globals in PHP is:

Ans: Off

Question: Which of the following is not a valid PHP connection status?

Ans: open

Question: Choose the correct statement:

Ans: include() includes and evaluates a specific file

require_once() includes and evaluates a specific file only if it has not been included before

Question: If the session_cache_expire() is not set, then by default the session cache will expire after:

Ans: 3 hrs

Question: What will be the output of the following script?
$count=50;

function Argument()

{

$count++;

echo $count;

}

Argument();

?>

Ans: It will print 1

Question: State whether True or False

Paamayim Nekudotayim operator allows access only to the static members of a class?

Ans: True

Question: Which of the following statements is true with regard to comparisons in PHP5?

Ans: With (===) operator, object variables are identical if and only if they refer to the same instance of the same class.

Question: Which of the following built-in function assist in checking if actually the function exists or not?
Ans: function_exists

Question: What will be the output of the following code?

$a = 0.0;

for ($i = 0; $i < a ="="">

Ans: 1

Question: What will be the output of the following code?
$i=4;

$j=30;

$k=0;

$k=$j++/$i++;

echo $i . " " . $j . " " . $k . " ";

Ans: 5 31 7.5

Question: Which of the following is a not a correct way of commenting in php?

Ans: /#PHP Comment

Question: Following is a php code block:

$m=9;

$n=99;

$z=8;

$z=$n++/$m++ + --$z;

echo $z;

what will be the output?

Ans: 18

Question: Which of the following is the correct way of specifying default value?

Ans: function GetDiscount($Type = "Special") { . . . }

Question: With reference to the following php script:

print 'Text Line1'

print 'Text Line2'

?>

What will be the output on running the script?

Ans: Error message will be printed

Question: What will be the ouput of the following code?

for ($i = 0; $i < i ="="">

0134

Question: Late PHP versions support remote file accessing for the functions:

Ans: include_once()

require_once()

both of them

Question: You have designed a user login form as follows:

User Name:

Password:

How can you access the username entered by the user in the 'Validate.php' webpage?

a. $var= $_POST['username'];

b. $var= $_REQUEST['username'];

c. import_request_variables('p', 'p_');

$var= $p_username;

Ans: Both of them

Question: Which of the following does not represent logical AND operator in PHP?

Ans: &amp

Question: Which of the following is not true for a persistent connection?

Ans: These can't be converted to non-persistent connections

Question: Which of the following are invalid data types in PHP?

Ans: char

Question: The Manager and Office classes are as follows:
class Manager{

function printName() {

echo "Manager";

}

}

class Office{

function getManager() {

return new Manager();

}

}

$ofc = new Office();

???

?>

Which of the following should replace '???' to obtain the value of printName() function?

Ans: $ofc->getManager()->printName();

Question: The classes are defined as follows:abstract class BaseCls{

protected abstract function getName();

}

class ChildCls extends BaseCls{

}

Which of the following implementations of getName() is invalid in ChildCls?

Ans: public function getName(){}

Question: Which of the following variable declarations within a class is invalid in PHP5?

Ans: var $term =3;

Question: What will be the output of following code?

$arr = "a";

$arr[0]="b";

echo $arr;

echo $arr[0];

Ans: bb

Question: For the following code:

the output will be:

Ans: 171

Question: What is the result of the following expression?
Ans: 5+2 * 4+6

Question: What will be the output of following code?
$var = 1 + "-1.3e3";

echo $var;

Ans: -1299

Question: What will be the output of following code?

$var1="a";

$var1="b";

echo "$var1 $a";

Ans: a b

Question:What is the output of the following code?

$a = 500;

$b = 200;

echo $a % 2

* $b;

?>

Ans: 0

Question: What will be the ouput of the following code?

if (-1)

print "true";

else

print "false";

?>

Ans: true

Question: What will be the output of the following code?

echo 12 . 6;

Ans: 126

Question: Consider the following sample code:

$x = 0xFFFE;

$y = 2;

$z = $x && $y;

What will be the value of $z?

Ans: 1

oDesk PHP Test Answer

oDesk PHP test for developer only.

Question.1:The setrawcookie() method of setting cookies is different from PHP standard method of cookie setting as:

a. It does not allow expiry time to be set

b. It can be used only once

c. It does not URL-ENCODE the value on its own

d.It does not allow domain setting

Solution:C

Question.2You need to keep an eye on the existing number of objects of a given class without introducing a non-class varibale. which of the following makes this happen?

a. Add a member varibale that gets incremented in the default constructer and decremented the destructer.

b. Add a local variable that gets incremented in each constructer and decremented in the desructer

c. Add a static member variable that gets incremented in each constructer and decreented in the destructor

d. This cannot be accomplished since the creation of objects is being done dynamically via “new”

Question.3which of the following variable declaration within a class is invalid in PHP5?

a. private $type = “moderate”;

b. var $term = 3;

c. public $amn = “500″;

d. protected $name = ‘Quantes Private Limited’;

Solution:

Question.4which of the following is not valid PHP parser tag?

a. script

b. ?p

c. %

d. ?php;

Solution:

Question.5How can you hide the fact that web pages are written in PHP?

a. By using AddType application/X-httpd-php asp

b. Specify all file names without any dot and extension

c. By using .htaccess diretive in Apeche

d. All of the above

Solution:C

Question.6What is the output of the following code?

$a = 3;

$b = 2;

echo (int)$a/(int)$b

?>

a. 1

b. 1.5

c. 2

d. 3

e. Eroor

Solution:b

Question.7Which one is correct?

a. $s = fwrite (“a string here”);

b. $s = fwrite ($fp,”a string here”);

c. $s = fwrite (“a string here”,$fp);

d. non of the above

Solution:b

Question.8 Which of the following set of operations is not valid in PHP 5?

a. >, >=

b. =,==

c. !==,!==

d. +=, *=

Solution: C

Question.9 Late PHP version support remote file accessing for the functions:

a. include()

b. include_once()

c. require_once()

d. All of the above

Solution: D

Question.10 What will be the output of the following script?

$count=50;

function Argument()

{

$count++;

echo $count;

}

Argument()

?>

a. It will print 50

b. It will print 51

c. It will print 52

d. It will print 1

Solution:D

Question.11 which of the following are used for code reuse?

a. Loops

b. functions

c. Database

d. include files

Solution: B,D

Question.13 which of the following is the corect way of specifying default value?

a. Function GetDiscount($Type = “Special”) {………}

b. Function GetDiscount(Type := “Special”) {………}

c. Function GetDiscount($Type: = “Special”) {………}

d. Function GetDiscount($Type : “Special”) {………}

Solution:

Question.14 Which of the following are ”magic constant’?

a. __LINE__

b. __FILE__

c __PRETTY_FUNCTION__

d __CLASS__

e. __METHOD__

Solution:

Question.15you have defined three variables $to, $subject, and $body to send an email. Which of the following methods would you use for sending an email?

a. mail($to, $subject,$body)

b. sendmail($to, $subject,$body)

c. mail(to, subject,body)

d. sendmail(to, subject,body)

Solution:

Question.16 Which one of the following is turnary operator?

a. &

b. =

c.

d. ?:

e. +=

f. &&

Solution:D

Question.17What is the result of the following Exprssion?

5+2*4+6

a. 70

b. 19

c. 34

d. 21

Solution:B

Question.18 The default value of register global in PHP is:

a. Off

b. On

Solution:A

Question.19 What would b the outpur of the following code?

$string = ‘good day’;

$string = ucword($string);

echo $string;

?>

a. good day

b. GOOD DAY

c. Good Day

d. non of the above

Solution: C

Question.20 If you want to pass a value to a function by reference, the correct way is:

a. function ModifyReport(&$Rptfile){}

b. function ModifyReport($Rptfile){}

c. function ModifyReport(ByRef $Rptfile){}

d. function ModifyReport(&Rptfile){}

Solution: D

oDesk Java programming test answer

Question 1 What is the java.net.IDN class in 1.6?

Methods to resolve integrated domain names (IDNs), such domain names are special embedded names
Methods to swap bytes between network byte order and host byte order
Methods to convert internationalized domain names (IDNs) between a normal Unicode representation and an ASCII Compatible Encoding (ACE) representation
This class does not exist
None of the above

Question 2 What will be the output of the following program?public class Test

{

public static void main (String args[]) throws Exception
{
Test o = new Test ();
System.out.println (o.content ());
}public String content () throws Exception
{throw new Exception ("This is an exception on this.content ()");
}private static class B
{public String content ()
{return ''B'';
}
}private static class A extends B
{public String content ()
{return ''A'';
}
}
}

The code will fail to compile
The code will compile but throw an exception at runtime
The code will compile and on running, it will print ''A''
The code will compile and on running, it will print ''B''

Question 3 Which of these interfaces are used by implementations of models for JTable?

TableModel
TableColumnModel
TableSelectionModel
ListModel

Question 4 How many times can classes be nested within a class?

5
8
4
Any number of times

Question 5 One method in your application needs to be synchronized. Which of the following options are correct for synchronization?

public synchronized void Process(void){}
public void Process(){ synchronized(this){ } }
public void synchronized Process(){}
public synchronized void Process(){}

Question 6 What could be the replacement of "//ABC" in the following code?public class Jam

{

public void apple(int i, String s)
{}
//ABC
}

public void apple(String s, int i){}
public int apple(int i, String s){}
public void apple(int i, String mystring){}
public void Apple(int i, String s) {}

Question 7 What will be the output when the following code is compiled and run?public class Test

{

public static void main (String args[])
{
int i;
i = 3;
System.out.println ((int)i * 2.5 / 3.0);
}
}

The code will compile, but it will throw an exception when it is run
The code will compile and it will not produce any output when it is run
The code will fail to compile
The code will print 3
The code will print 2.5
The code will print 2

Question 8 What would happen on trying to compile and run the following code?public class MainCls

{

public static void main(String argv)
{
System.out.println("My Text");
}
}

A compile error will be generated because 'main' is a reserved word and cannot be used for a class
"My Text" will be displayed
The code will compile. A runtime error will occur because 'main' is not properly defined
The code will compile. A runtime error will occur because constructor is not defined

Question 9 What will be the output when this code is compiled and run?public class Test

{

static int x = 10;
public Test ()
{
Bar b = new Bar ();
Bar b1 = new Bar ();
update (b);
update (b1);
}private void update (Bar bar)
{
bar.x = ++x;
System.out.println (bar.x);
}public static void main (String args[])
{
File f = new File("/","autoexec.bat"); b.DataInputStream d = new DataInputStream(System.in);c.RandomAccessFile r = new RandomAccessFile("OutFile"); d.OutputStreamWriter o = newOutputStreamWriter(System.out);
}private class Bar
{public int x = 10;
}
}

The code will fail to compile
11 12
11 11
12 12

Question 10 Which of the following statement will not compile?

File f = new File("/","autoexec.bat");
DataInputStream d = new DataInputStream(System.in);
RandomAccessFile r = new RandomAccessFile("OutFile");
OutputStreamWriter o = new OutputStreamWriter(System.out);

Question 11 Which of the following are "keywords" in Java?

default
NULL
String
throws

Question 12 Which of the following statements is true of the HashMap class?

It stores information as key/value pairs
Elements are returned in the order they were added
It does not permit null keys
It does not permit null values

Question 13 How does the set collection deal with duplicate elements?

Duplicate values will cause an error at compile time
A set may contain elements that return duplicate values from a call to the equals method
An exception is thrown if you attempt to add an element with a duplicate value
The add method returns false if you attempt to add an element with a duplicate value

Question 14 What is wrong with the following code?class X extends Exception {}

public class Y
{public void foo()
{
try {
b();
}
finally {
ba();
}
catch (MyException e) {}
}
public void b() throws X {
throw new X();
}public void ba() throws RuntimeException {
throw new RuntimeException();
}
}

Nothing is wrong with the code
Finally block should come after the catch block
An empty catch block is not allowed
None of the above

Question 15 Is the following code valid?InetAddress ad = InetAddress.getByName ("195.186.2.111");

Yes

No

Question16 What will be the output of this program?public class Test

{

public static void main (String args[])
{
String a, b, c, d;
a = ''Hello1234'';
b = ''Hello'' + String.valueOf(1234);
c = ''Hello'' + ''1234'';
d = new String (new char[]{'H', 'e', 'l', 'l', 'o', '1', '2', '3', '4'});
System.out.print (a == b);
System.out.print ('' '');
System.out.print (a.equals(b));
System.out.print ('' '');
System.out.print (a == c);
System.out.print ('' '');
System.out.print (a.equals(c));
System.out.print ('' '');
System.out.print (a == d);
System.out.print ('' '');
System.out.print (a.equals(d));
System.out.print ('' '');
}
}

true truetruetrue false true
false true truetrue false false
false true truetrue false true
false false true true false true

Question 17 Which of the following cannot apply to constructors?

Name same as class name
Void return type
Can have parameters
Overloading

Question 18 Choose the correct declarations for the main() method which will allow the class to be run as a standalone program.

public void main(String str[])
static public void main(String str[])
public static int main(String str[])
public static void main(String str[])

Question 19 For a class defined inside a method, what rule governs access to the variables of the enclosing method?

The class can only access transient variables
The class can only access static variables
The class can only access final variables
The class can access any variable

Question 20 A method can be defined as native to:

Overcome the limitation of the private scope of a method
Get to access hardware that Java does not know about
Write optimized code for performance in a language such as C/C++
Define a new data type such as an unsigned integer

Question 21 What will be the output of the following line?System.out.println(Math.floor(-2.1));

-2

2.0

-3

-3.0

Question 22 For the given variables, which of the following will compile without an error?char c = 'c';

int i = 50;
double d = 80;
long l = 200;
String s = "Goodbye";

s+=i;
i+=s;
c+=s;
c=c+i;

oDesk joomla 1.5 test answer

oDesk Joomla 1.5 test only for joomla developer.

1) The index.php file is a combination of HTML and PHP code.

Odesk test answer: True

2) What is the default super administrator account for Joomla called?

Odesk test answer: Administrator

3) Which of the following PHP directives are important to Joomla execution to define an alternate compression library if the standard library is not available?

Odesk test answer: extension_dir

4) Which of the following files is archive and contains the actual CB component that you must install into Joomla while downloading CB?

Odesk test answer: com_comprofiler

5) Which option will you choose to set the site metadata for the installed website?

Odesk test answer: Global Configuration

6) What will happen if we set the SSL enabled option to On?

Odesk test answer: This option will make the link from the menu begin with an https://

7) The core editor events apply to plug-ins that provide editor functionality such as TinyMCE or XStandard Lite.

Odesk test answer: True

8) Which PHP file does the index.php file load to provide the menu bar to the administrator interface?

Odesk test answer: Toolbar.php

9) Which of the given database systems is supported by Joomla?

Odesk test answer: Mysql

10) Which of the following is the default editor of Joomla?

Odesk test answer: TinyMCE

11) Joomla provides an abstracted method called getEscaped() that returns the escaped string regardless of the target database.

Odesk test answer: False

12) From which package are the classes (i.e JSite, JAdministrator and JInstallation) which make up the Joomla CMS application extended?

Odesk test answer: Installer

13) What is not true about JoomlaXplorer?

Odesk test answer: None of the above

14) Which of the following is a system event?

Odesk test answer: OnDisplay

15) Which Joomla file provides the central logic of the template, including any module and component display?

Odesk test answer: Index.php

16) When will you use SMTP authentication mail settings?

Odesk test answer: When you want to use an internal mail server

17) What do you understand by the type of error?

Odesk test answer: It means that STRICT_ALL_TABLES is enabled

18) Which path variable holds the path of the currently executing application?

Odesk test answer: All of the above

19) Which user events occur with plug-ins that are installed for the front end of the system?

Odesk test answer: Both a and b

20) Which type of positioning elements define a concrete area such as a p, td, div or table in a CSS file?

Odesk test answer: Block elements

21) Which of the following files does the "/includes" directory not contain?

Odesk test answer: None of the above

22) Which option will you select to install or to add the module to your website?

Odesk test answer: C

23) Why does Joomla use templateDetails.xml files?

Odesk test answer: All of the above

24) Which of the following events is activated after content rendering is complete for content type plug-ins?

Odesk test answer: OnAfterDisplayContent

25) All the Joomla settings are contained within a PHP class called JConfig.

Odesk test answer: True

26) In which PHP file is the central configuration data for Joomla contained?

Odesk test answer: configuration.php

27) What is not true about the MD5 hash value?

Odesk test answer: Each password in Joomla is stored as a MD5 hash value

27) There are two root classes for the Joomla framework: JFactory and JVersion.

Odesk test answer: True

28) Which option will you select to find unpublished articles?

Odesk test answer: Article manager

29) What do you understand from the following code?

Odesk test answer: SQL statement is executed against the Joomla database to find empty data fields

30) Which SEO settings will you activate to make Joomla article URL shown in picture A appear as shown in picture B?

Odesk test answer: B

31) In which option are errors, warnings and references logged?

Odesk test answer: None of the above

32) Which type of files can media manager not upload?

Odesk test answer: None of the above

33) Which among the following switches display the current version of PHP?

Odesk test answer: v

34) The Joomap extension uses the style-sheets from the currently selected default template to display the sitemap in the site style.

Odesk test answer: True

35) Which type of server technology is used by Joomla?

Odesk test answer: All of the above

36) Which of the following is not true about the FrontPage Manager?

Odesk test answer: You cannot select your content for the FrontPage from all the contents

37) What happens if the Text Separator Field is left empty while using the breadcrumbs module in the module manager?

Odesk test answer: None of the above

38) Which of the following support libraries must you include when you are doing a manual compile of PHP to use with Joomla?

Odesk test answer: All of the above

39) What is the role of the template metadata file in the system?

Odesk test answer: It contains the basic authorship information

oDesk WordPress 2.8 Test Answer

WordPress 2.8 Test for wordpress website designer and developer.

Question: A possible way to collect real-time statistics about traffic to a WordPress site is to
a) use a built-in tool
b) use a plug-in (Answer)
c) use a widget
d) None of the above

Question: In order to to display a widget, the user must _____
a) Set he “Show Property” of the desired widget to “true”
b) Drag the desired widget of the side bar (answer)
c) Add the Desired widget to the post
d) Change the source code

Question: Image size can be set __________
a) Directly in the post’s
b) in the wp-imageresize plug-in
c) in the admin settings (Answer)
d) a and b

Question: Which of the following blog site can be imported into wordpress?
a) Joomla (Answer)
B) Yahoo Blog (Answer)
c) Drupal (Answer)
d) Blogspot
e) All of the above

Question: Which of the following methods can be used to display the time in every post?
A) Changing the config file
B) Setting the feature in the admin settings
C) Changing the index.php file (answer)
D) Updating the database

Question : Which of the following methods can be used to make permalinksSEO friendly?
A) Updating the database
B) Changing the source code
C) Configuring the features in the config file
D) Configuring the features in the admin settings (Answer)

Question: Where can Google Adsense be integrated into a WordPress blog?
A) Only in the sidebar (Answer)
B) Only in the header
C) Anywhere
d) Only in the content

Question: Which of the following are true about Template Tags?
A) The template tag comprises of the three tag (PHP code tag, WordPress function, optional Parameters)
B) A template tag is code that instruct WordPress to do or get somethings (Answer)
C) There are only two types of parameters that are supported by wordpress template tag (String, Boolean)
D) All of the above

Question: Which of the following files are mandatory for a WordPress theme?
A) Index.php (Answer)
B) Style.css (Answer)
C) functions.php
D) page.php

Question: Contributor may change the timestamp on a post?
A) True
B) False (Answer)

Question: “Shortcodes” can be defined in WordPress.
A) True (Ture)
B) False

Question: Which of the following statements are true regarding widgets and plug-in in WordPress?
A) Plug-in is a software used to add function to blog (Answer)
B) Widget is an object derived from a plug-in and can be added to the sidebar (Answer)
C) Widgets are alwasy plugins (Answer)
D) All of the above

Question: A plug-in must be used in order to allow users to post flast or multimedia files.
A) True (Answer)
B) Flase

Question: The “function_exist()” function can be used to check whether a plug-in activated or not?
A) True (Answer)
B) False

Question: To manually make the sidebar widget ready, the user must___
A) modify the sidebar.php file (Or this)
B) Enable it in the admin settings (Answer)
C) Change the index.php

Question: A theme’s source code must be changed manually in order to customize the admin login page
A) True
B) False (Answer)

Question: Which of the following tasks must be performed to add a favicon icon to your site?
A) Upload a favicon icon to your side
B) Add a favicon link to the theme’s header file or update the exising favicon icon link to the new one (Answer)
C) Change the favicon icon in admin settings
D) The favicon icon can not be changed

Question: How can a WordPress blog theme be used to display content in two coloumns?
A) By changing the theme options to two columns in admin settings
B) By changing the layout in the config file (Answer)
C) WordPress theme cannot be customized to display posts in two columns
D) By using two-columns theme (Answer)

Question: Which of the following method helps you put HTML code into a post, and get it to format the way you expect?
A) Replacing special characters with corresponding html codes or character codes
B) Using the <codegt; <pre=”” c)=”” tag=”” the=”” using=””>tag
D) None of the above : WordPres auto-replaces special character with substituted characters

Question: Which of the following options are true regarding Plug-ins in WorpPress?
A) Plug-ins can be used to eliminate spam (Answer)
B) Plug-ins can be used to integrate a WordPress blog with a forum (Answer)
C) Plug-ins can be used to integrate Twitter with a WordPress blog (Answer)
D) Plug-ins can be used to embed javascript in a WordPress blog
E) All of the above

Question: How can a logo be placed on a WordPress header?
A) Manually add the logo to the source code (answer)
B) Upload a new logo in admin settings
C) Update the logo path in the config file

Question: Which of the following is a good reason to delete the admin account?
A) Because other users know this admin name (Answer)
B) Because it is not necessary
C) To enhance performance
D) TO enhance security (Answer)

Question: Which of the following keywords can be defined as “Those useful ‘one-click‘ buttons that insert code for you?
A) Quicktags (Answer)
B) Shotcodes
C) Permalinks
D) Excerpts

Question: Which of the following methods can be used to add Pagination to a WordPress site?
A) Using a widget
B) Setting the feature in the admin settings
C) Using a plug-in (Answer)
D) Pagination cannot be added to WordPress site

Question: Which of the following methods can be used to enable posting via e-mail?
A) Installing the wp-emailpost plug-in
B) Configuring the feature in admin settings (Answer)
C) Using a widget
D) This feature is not available in WordPress

Question: Which of the following are true regarding Pages in WordPress?
A) Pages are listed in reverse chronological order
B) Pages can be static
C) Pages can be found in Categories
D) Page are not associated with a date/time like post

Question: State whether True or False
Wordpress supports all the following:
1. Create new posts
2. Edit Posts
3. Schedule post for future publishing

A) True
B) False

Question: Which of the following role level has the highest privilege?
A) Level_0
B) Level_10 (Answer)
C) Depends on your settings
D) Every role has the same privilege

Question: A possible way to add additional information to a wordpress blog post is to ____
A) Use the wp-addinfor plug-in
B) Use custom fields
C) Use a widget

Question: Which of the following actions performed before upgrading WordPress?
A) Back up the site (Answer)
B) Disable plugins (Answer)
C) Enable FTP on the site
D) All of the above

Question: Which of the following methods can be used to eliminate spam?
A) Using the “wp-captcha-free” plug-in
B) Using the “askimet” plug-in (Answer)
C) Using a widget
D) None of the above

Question: Which of the following needs to be edited in order to creat the function for the shortcode?
A) Index.php
B) functions.php (Answer)
C) post.php
D) page.php

Question: Which of the following arguments are accepted in shortcodes handler function while using shortcode API?
A) $atts
B) $Content
C) $code
D) All of the above (Answer)

Question:A plug-in must be used in order to allow users to post flash of multimedia files.
a)True(Answer)
b)False

Question: You want to schedule a backup of your site database but do not have enough permission to access your host. of the following choices can help you perform this task?
a)se phpMyAdmin
b)Install “wp database backup” plug-in(Answer)
3)Use cron job to schedule.
4)Cannot schedule

Question: Using ——— is a good way to ensure that a WordPress site is indexed by search engines.
a)a sitemap
b)robot.txt
c)a widge

Odesk Test Photoshop cs3

This test for Photoshop designer .

Ø Changing units on the Info Palette automatically changes the units on Rulers.

Ans: TRUE

Ø Which of the following Filters cannot be applied to a Smart Object?
Ans: Pattern Maker

Ø With which of the given options does the Signal Strength Meter appear?

Ans: It appears when you choose 'merge to hdr command'

Ø Channels can not be added to which of the following image modes?

Ans: Bitmap

Ø Which among the following Modes does not support layers?

Ans: All of the above

Ø Which of the following is not true about Filters?

Ans: None of the above

Ø Which of the following is not true about the Curves dialog box?

Ans: The Curves dialog box lets you adjust up to 14 different points throughout an image's tonal range

Ø Which of the following Slices is created with the Slice Tool?

Ans: User slices

Ø Which of the following features is supported by the EPS file format?

Ans: It supports the Grayscale and Bitmap color modes

Ø Which among the following blending modes is available only for the Apply Image and Calculationscommands?

Ans: Both a and b

Ø What is the use of the Make Work Path command in the Paths palette ?

Ans: It can alter the shape of a selection

Ø Which type of information is not displayed by the Info Palette?

Ans: It does not display the opacity of the current layer

Ø Which among the following is not a right option for selecting a web-safe color from the Color Palette?

Ans: Choose Current Color from the Color Palette Menu

Ø Which keyboard shortcut (windows) will you choose to close a Path?

Ans: None of the above

Ø Anti-aliasing option is available for which of the given Tools?

Ans: All of the above

Ø Which of the following options displays the Spot Channels in the Channels palette?

Ans: B

Ø What happens when Use Legacy is selected as shown in the given picture?

Ans: It is used to apply proportionate (nonlinear) adjustments to image pixels

Ø Which option will you select to open the Levels dialog box?

Ans: Choose Image > Adjustments > Levels

Ø Which type of images are resolution-dependent?

Ans: Vector images

Ø Which Liquify Tool is used to reconstruct a part of a distorted image?

Ans: A

Ø In which Format will you save your file to preserve the Alpha channels?

Ans: All of the above

Ø Which of the following is not a kind of text type?

Ans: Line type

Ø Which option will you select to convert Types to Shapes?

Ans: Both b and c

Ø The mask created by the Replace Color command is permanent.

Ans: FALSE

Ø Which of the following Layer properties can be animated?

Ans: All of the above

Ø Which View will you choose to display a Histogram with no controls or statistics?

Ans: All of the above

Ø Which of the given options displays left indent in the Paragraph palette?

Ans: B

Ø Which keyboard shortcut (windows) will you choose to group Layers?

Ans: Control + G

Ø The Rotate Canvas command does not work on which of the following

Ans: All of the above

Ø Which of the Saving commands is available for an image that is managed by a Version Cue Workspace?

Ans: Check In

Ø When will the Dynamic shortcuts appear in the Character Palette Menu as shown in the picture?

Ans: All of the above

Ø Hanging Punctuation controls the alignment of the punctuation marks for a specific paragraph.

Ans: TRUE

Ø Which option will you choose to select all layers of a similar type?

Ans: All of the above

Ø Which of the following is not a Color Adjustment command?

Ans: Adjustment command

Ø By default, Masks applied to Smart objects are linked to Smart object layers. .

Ans: FALSE

Ø A working space is an intermediate color space used to define and edit color in Adobe applications.

Ans: FALSE

Ø Which option will you select to remove the existing profile from the document in the given image?

Ans: C

Ø You cannot change the order of the Vector masks or working paths in the Paths palette.

Ans: FALSE

Ø The Color Replacement Tool does not work in which of the following Image modes?

Ans: All of the above

Ø In which of the following Modes can you draw while working with the Shape or Pen tools?

Ans: All of the above

Ø The Out Of Gamut option works only on RGB and Lab images

Ans: TRUE

Ø Which among the following QuickTime Video formats is supported by Photoshop extended?

Ans: MOV

Posted in: Tips

JAHIDSUJON

Thursday, April 26, 2012

ODesk 23 Test Answers

Popular Posts

Followers