oDesk Microsoft Excel 2010 Skill Test Answers

oDesk Microsoft Excel 2010 Skill Test Answers

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

Answer:  a

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

Qu: 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.
  Answer : c

Qu: 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.
  Answer: c

Qu: 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
  Answer: b

Qu: 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.
  Answer : b

Qu: 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.
  Answer : c

Qu: 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.
  Answer : a

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

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

Answer : b

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

Qu: 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
  Answer : c

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

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

Answer : c

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

Answer : d

 Qu: 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
  Answer : c

Qu: 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
  Answer: b

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

Answer : b

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

Answer: a

Read More

Odesk Test answer Adobe Photoshop CS3

Odesk Test answer Adobe Photoshop CS3

Q: Changing units on the Info Palette automatically changes the units on Rulers.
A: TRUE

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

Q: With which of the given options does the Signal Strength Meter appear?
A: It appears when you choose ‘merge to hdr command’

Q: Channels can not be added to which of the following image modes?
A: Bitmap

Q: Which among the following Modes does not support layers?
A: All of the above

Q: Which of the following is not true about Filters?
A: None of the above

Q: Which of the following is not true about the Curves dialog box?
A: The Curves dialog box lets you adjust up to 14 different points throughout an image’s tonal range

Q: Which of the following Slices is created with the Slice Tool?
A: User slices

Q: Which of the following features is supported by the EPS file format?
A: It supports the Grayscale and Bitmap color modes

Q: Which among the following blending modes is available only for the Apply Image and Calculations commands?
A: Both a and b

Q: What is the use of the Make Work Path command in the Paths palette ?
A: It can alter the shape of a selection

Q: Which type of information is not displayed by the Info Palette?
A: It does not display the opacity of the current layer

Q: Which among the following is not a right option for selecting a web-safe color from the Color Palette?
A: Choose Current Color from the Color Palette Menu

Q: Which keyboard shortcut (windows) will you choose to close a Path?
A: None of the above

Q: Anti-aliasing option is available for which of the given Tools?
A: All of the above

Q: Which of the following options displays the Spot Channels in the Channels palette?
A: B

Q: What happens when Use Legacy is selected as shown in the given picture?
A: It is used to apply proportionate (nonlinear) adjustments to image pixels

Q: Which option will you select to open the Levels dialog box?
A: Choose Image > Adjustments > Levels

Q: Which type of images are resolution-dependent?
A: Vector images

Q: Which Liquify Tool is used to reconstruct a part of a distorted image?
A: A

Q In which Format will you save your file to preserve the Alpha channels?
A: All of the above

Q: Which of the following is not a kind of text type?
A: Line type

Q: Which option will you select to convert Types to Shapes?
A: Both b and c

Q: The mask created by the Replace Color command is permanent.
A: FALSE

Q: Which of the following Layer properties can be animated?
A: All of the above

Q: Which View will you choose to display a Histogram with no controls or statistics?
A: All of the above

Q: Which of the given options displays left indent in the Paragraph palette?
A: B

Q: Which keyboard shortcut (windows) will you choose to group Layers?
A: Control + G

Q: The Rotate Canvas command does not work on which of the following
A: All of the above

Q: Which of the Saving commands is available for an image that is managed by a Version Cue Workspace?
A: Check In

Q: When will the Dynamic shortcuts appear in the Character Palette Menu as shown in the picture?
A: All of the above

Q: Hanging Punctuation controls the alignment of the punctuation marks for a specific paragraph.
A: TRUE

Q: Which option will you choose to select all layers of a similar type?
A: All of the above

Q: Which of the following is not a Color Adjustment command?
A: Adjustment command

Q: By default, Masks applied to Smart objects are linked to Smart object layers. .
A: FALSE

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

Q: Which option will you select to remove the existing profile from the document in the given image?
A: C

Q: You cannot change the order of the Vector masks or working paths in the Paths palette.
A: FALSE

Q: The Color Replacement Tool does not work in which of the following Image modes?
A: All of the above

Q: In which of the following Modes can you draw while working with the Shape or Pen tools?
A: All of the above

Q: The Out Of Gamut option works only on RGB and Lab images
A: TRUE

Q: Which among the following QuickTime Video formats is supported by Photoshop extended?
A:  MOV

Read More

oDesk Test Answar PHP5 2013/2014

oDesk Test Answar PHP5 2013/2014

Question 1:
What will be the result of following operation?

Print 4<<5;

1. 3
2. 128
3. 120
4. 6

Answer is:       120

Question 2:

You wrote following script to check for the right category:

1. 2
2. $cate=5;
3. ...
4. …
5.  
6. if ($cate==5)
7. {
8. ?>
9. Correct category!
10. 11 }
11. else {
12. ?>
13. Incorrect category!
14. 15 }
15. }
16. ?>

What will be the output of the program if value of ‘cate’ remains 5?

1. Correct category!
2. Incorrect category!
3. Error due to use of invalid operator in line 6:”if ($cate==5)”
4. Error due to incorrect syntax at line 8, 10, 12 and 14

Answer is:       Correct category!

Question 3:

You need to count the number of parameters given in the URL by a POST operation. The correct way is:

1. count($POST_VARS);
2. count($POST_VARS_PARAM);
3. count($_POST);
4. count($HTTP_POST_PARAM);

Answer is:       count($_POST);

Question 4:

If expire parameter of setCookie function is not specified then:

1. Cookie will never expire.
2. Cookie will expire with closure of the browser
3. Cookie will expire with within 30 minutes
4. Cookie will expire in 24 hours

Answer is:       Cookie will expire with closure of the browser

Question 5:

Which of the following variables declarations within a class is invalid in PHP5?

1. Private $type = ‘moderate’;
2. Internal $term =3;
3. Public $name =’500’;
4. Protected $name = ‘Quantas Private Limited’;

Answer is:       Protected $name = ‘Quantas Private Limited’;

Question 6:

Which of the following statements is not true with regard to abstract classes in PHP5?

1. Abstract classes are introduced in PHP5
2. A class with a single abstract method must be declared abstract
3. Abstract class can contain non abstract methods
4. Abstract method must have method definition and can have optional empty braces following it

Answer is:       Abstract method must have method definition and can have optional empty braces following it

Question 7:

Which of the following pair have non-associative equal precedence?

1. +,-
2. ==, !=
3. <<, >>
4. &=, |=

Answer is:       &=, |=empty braces following it

Question 8:

You have two strings, which you want to concatenate.

$str1 = ‘Have a ‘;

$str2 = ‘Nice Day’;

The fastest way would be:

1. $str1. Concat($str2);
2. $str1. $str2;
3. “$str1$str2”;
4. None of the above

Answer is:       None of the above

Question 9:

For the following code:

1. Function Expenses()
2. {
3. Function Salary()
4. {
5. }
6. Function Loan()
7. {
8. Function Balance()
9. {
10. }
11. }
12. ?>

Which of the following sequence will run successfully?

1. Expenses();Salary();Loan();Balance();
2. Salary();Expenses();Loan();Balance();
3. Expenses();Salary();Balance();Loan();
4. Balance();Loan();Salary();Expenses();

Answer is:       Salary();Expenses();Loan();Balance();

Question 10:

Which of the following is not supported in PHP5?

1. Type Hinting
2. Reflection
3. Magic Methods         
4. Multiple Inheritance
5. Object Cloning

Answer is:       Multiple Inheritance

Question 11:

How would you start a session?

1. Session(start);
2. Session();
3. Session_Start();
4. Begin_sesion();

Answer is:       Session_Start();

Question 12:

What do you infer from the following code?

$str=’Dear Customer,\nThanks for your query. We will reply very soon.?\n Regards.\n Customer Service Agent’: Print $str;

?>

1. Only first\n Character will be recognized and new line will be inserted.
2. Last \n Will not be recognized and only first two parts will come in new lines.
3. All the \n Will work and text will be printed on respective new lines.
4. All will be printed on one line irrespective of the \n.

Answer is:       All the \n Will work and text will be printed on respective new lines.  

Question 13:

What will be the result of the following expression:
6+4*9-3

1. 60
2. 87
3. 39
4. 30

Answer is:       87

Question 14:

What is true regarding $a+$b where both of them are arrays?

1. Duplicated keys are NOT overwritten
2. 87
3. The + operator is overloaded
4. This produces a syntax error

Answer is:       $b is appended to $a

Question 15:

Which of the following characters are taken care of by html special chars?

1. <
2. >
3. Single quote
4. Double Quote
5. &
6. All of the above

Answer is:       >

Question 16:

The value of a local variable of a function has to be retained over multiple calls to that function. How should that variable be declared?

1. Local
2. Global
3. Static
4. None of the above

Answer is:       Static

Question 17:

Which of the following multithreaded servers allow PHP as a plug-in?

1. Netscape FastTrack
2. Microsoft’s Internet Information Server
3. O’Reilly’s WebSite Pro
4. All of the above

Answer is:       All of the above

Question 18:

Multiple select/load is possible with:

1. Checkbox
2. Select
3. File
4. All of the above

Answer is:       All of the above

Question 19:

Which of the following variable names are invalid?

1. $var_1
2. $var1
3. $var-1
4. $var/1
5. $v1

Answer is:       $var1

Question 20:

Which of the following are useful for method overloading?

1. _call,_get,_set
2. _get,_set,_load
3. _get,_set,_load
4. _overload

Answer is:       _get,_set,_load

Question 21:

What will be the output of the following code?

Function fn(&$var)

{

$var=$var-($var/10*5);

Return $var;

}

Echo fn(100);

1. 100
2. 50
3. 98
4. Error message
5. None of the above

Answer is:       None of the above

Question 22:

Which of the following type cast is not correct?

1. $fig=23;
2. $varb1 = (real) $fig;
3. $varb2 = (double) $fig;
4. $varb3 = (decimal) $fig;
5. $varb4 = (bool) $fig;
6. ?>

1. Real
2. Double
3. Decimal
4. Boolean

Answer is:       Double

Question 23:

What will be the output of following code?

$a = 10;

Echo “value of a = $a”;

1. Value of a = 10
2. Value of a = $a
3. Undefined
4. Syntax Error

Answer is:       Value of a = $a

Question 24:

What will be the output of following code?

$var = 10;

Function fn()

{

$var = 20;

Return $var;

}

Fn();

Echo $var;

1. 10
2. 20
3. Undefined Variable
4. Syntax Error

Answer is:       Syntax Error

Question 25:

Which of the following attribute is needed for file upload via form?

1. Enctype=”multipart/form-data”
2. Enctype=”singlepart/data”
3. Enctype=”file”
4. Enctype=” form-data/file”

Answer is:       Enctype=”file”

Question 26:

Which of the following is not a file related function in PHP?

1. Fclose
2. Fopen
3. Fwrite
4. Fgets
5. Fappend

Answer is:       Fgets

Question 27:

Which of the following is correct with regard to echo and print?

1. Echo is a construct and print is a function
2. Echo is a function and print is a construct
3. Both are functions
4. Both are constructs

Answer is:       Echo is a function and print is a construct

Question 28:

Which of the following is a correct declaration?

1. Static $varb = array(1,’val’,3);
2. Static $varb = 1+(2*90);
3. Static $varb = sqrt(81);
4. Static $varb = new object;

Answer is:       Static $varb = new object;

Question 29:

Consider the following two statements:

I.          While (expr) statement

II.         While (expr): statement…endwhile;

Which of the following are true in context of the given statements?

1. I is correct and II is wrong
2. I is wrong and II is correct
3. Both I & II are wrong
4. Both I & II are correct

Answer is:       I is wrong and II is correct

Question 30:

You are using sessions and session register() to register objects. These objects are serialized automatically at the end of each PHP page and are de-serialized automatically on each of the following pages. Is this true of false?

1. True
2. False

Answer is:       True

Read More

oDesk Readiness Test for Independent Contractors and Staffing Managers

oDesk Readiness Test for Independent Contractors and Staffing Managers

This Post only for beginner freelancers oDesk Readiness Test for Independent Contractors and Staffing Managers . here you can learn this odesk test answer

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

Answer: E

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

Answer: D

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

Answer:B

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

Answer: E

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

Answer:

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

Answer: A

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

Answer: E

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

Answer: E

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

Answer: E

          10.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 guaranteedpayment

Answer: C

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

Answer: E

Question no.1: the oDesk team application time tracker records which of the following:

Ans: all of the above

Question no.2: can i start my own agency on oDesk?

Ans: yes!you can create an agency and earn money by selling the services of your agency construtors.

Question no.3: which of the following are NOT  permitted on oDesk?

Ans: all of the above. 

Question no.4: which of the following actions are NOT allowed when applying to job posting?

Ans: all of the above.

Question no.5: what happens when a contract ends?

Ans: all of the above.

Question no.6: which of the following is FALSE about weekly limits on hourly contracts?

Ans: the weekly limit can be changed by the constractor.

Question no.7: which of the following is TRUE about fixed contracts?

Ans: how much to pay and when to pay is at the employer's discretion.

Question no.9: which of the following are TRUE about the oDesk Work Dairy ?

Ans: all of the above.

Question no.10: which of the following are TRUE about the oDesk dispute process?

Ans: all of the above.

Question no.11: which of the following are required to qualified for guaranteed payment?

Ans: all of the above.

Question no.12: which of the following statements about oDesk fees is FALSE?

Ans: the Odesk fee is $2/hour for hourly contracts  .

Read More