test answers to Ms Excel 2000/2003

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

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

Now Finally Question & Answers

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.

Scams and Cheats at oDesk

oDesk is a marketplace. Like any marketplace, it attracts the less than honorable, the cheat, and the outright swindler. In this article, I’ll show you some of the problem people and the scams they use so you can avoid them.

Caveat Emptor- let the buyer beware.

You’ve probably seen it in chat rooms. It’s epidemic on dating sites. You may have done a little bit of it yourself on a resume. Misrepresentation. A better word is lying.
How is it done by providers on oDesk?

• Profile inflation- posting other works or projects as your own.
• Cheating on tests- getting someone else to test for you in a subject that you don’t know.
• Lowering your hourly rate and then milking time by just running odesk while you do other things.
• Stealing articles for submission and representing them as your own original work.
• Claiming expertise in an area where you really have none.

All of these amount to lying. All of them will get you fired. Most of them will get you interviews and maybe a job offer. All of them piss me off.
Providers who scam the system upset me because oDesk works. It works when it brings willing sellers and buyers together. They get good product and I get money. But the whole thing is built on trust. When someone violates ethical standards to ‘game’ the system, buyers get upset and lose faith. It hurts me when I try to bid for their next job. It hurts me even more when buyers are driven away altogether.

Avoiding the problem provider

Ask these questions-

• Is the provider too good for the job? Someone with very high skill levels showing in their profile and a very low hourly rate might be a ‘milker’- underbidding on their rates and inflating their time.
• Does the cover letter match the provider? Someone who has excellent English skills isn’t going to type “I is now right for your job”
• If you are suspicious, ask for some small, original work sample. Good providers will be happy to show you what they can do.

Caveat exigo- let the seller be wary.

The job posting looks good. They are hiring 5 writers to do articles on candle making for their site; the money is good; you apply and get an interview.
The buyer wants to ‘see what you can do’ and asks you to write a couple of articles for titles they provide. Reasonable, right?
Not always. The buyer interviews 20 people, gets 40 articles for free and walks. No job. No money and you’ve wasted your time.

Investigate your buyer.

Buyers get ratings just like providers do. Look at them. Check out their website or other contact information. Look for these warning signs-

• First time buyer or buyer with lots of previous job postings but no previous hires.
• Buyer with low rating or with bad feedback.
• Buyer who interviews lots of people but doesn’t seem to hire anyone.
• Buyer who asks you to provide free samples of work they need even though you have similar work showing in your profile.
• Buyers who lowball their project with the promise of more work later.

There is no sure way to avoid all problem buyers. This is especially true when you are just starting out and hungry for work. But use your common sense. When you are suspicious, ask questions. A good buyer will be happy to clarify the project.
Working together, we can make oDesk what it should be- a place for honest people to come together and get the job done.


Well, I’m upset again. Someone is messing with my marketplace. And what’s worse, it is likely they will nail some new users with their scam, ruining what should be an exciting first job and driving hopeful, new-to-oDesk writers away.

How it works

The job asks for writers to do a sales letter. It offers some fixed price that’s attractive to newbies. So far, nothing special.
But then the interviews start. It turns out that this buyer wants you to work on commission, to ‘prove’ your sales letter works. He/she offers you a commission based on leads and sales for the letter. Again, suspicious, but not unheard of.
I have to interject here that working for a percentage of future sales is against all my instincts, but, since this is targeted to new providers who are looking for any job to get started, it might be attractive to them.

Something smells

The first real stink of ‘this is a crook’, comes when the buyer suggests that working for commission means that payment can be made directly, cutting out oDesk and oDesk fees. Someone so willing to cheat oDesk is showing you his true colors- bile green and vomit yellow.
The second and convincing tip-off is that to increase the effectiveness of your sales letter, he suggests/demands that you market it online yourself by posting on forums, chat rooms and sending it out to all your email contacts. At this point, an experienced provider will say, “No thanks. I am a writer and I don’t want to be your sales rep.”
Unfortunately, I fear that someone new to the freelance community might go for it.

What’s going on

Plainly, it’s a new sort of multi-level marketing ploy. Get someone to write copy for free and then recruit them as a shill for your ‘product’.
I wouldn’t mind it except that these folks are impersonating real buyers and soon, if they follow their typical herd instinct, wonderful oDesk will be clogged with other multi-level marketers copycatting the technique.
The only way to nip it in the bud is to turn it into a method that doesn’t work for them. If you spot this happening, post a message explaining what’s going on in the message board for the project. And let oDesk know when a buyer wants to do an end-run around the legitimate process.
By the way, the ad that had a fixed price of a million dollars seemed a bit scammy too, but at least it was obviously an ad. I only hope that oDesk keeps a tight lid on bogus job postings and keeps my marketplace on the up and up.
If you’ve been burned by a bogus job on oDesk or another site, let me know about it and I’ll post it here on the blog.

oDesk php 5 test answers

What is true regarding this code?

setcookie will return true

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

echo "Plain text";

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

session_initiate()

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

None of the above

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

STDPRT

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

a. An abstract class cannot have final methods

Question:
Which composite data types are supported by php?

Array

Question:
The default value of register_globals in PHP is:

Off

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

 open

Question:
Choose the correct statement:

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:

3 hrs

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

function Argument()

{

$count++;

echo $count;

}

Argument();

?>

 It will print 1

Question:
State whether True or False

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

True

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

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?

function_exists

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

$a = 0.0;

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

1

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

$j=30;

$k=0;

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

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

5 31 7.5

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

/#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?

18

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

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?

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:

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;

Both of them

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

&amp

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

These can't be converted to non-persistent connections

Question:

Which of the following are invalid data types in PHP?

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?

$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?

 public function getName(){}

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

var $term =3;

Question:
What will be the output of following code?

$arr = "a";

$arr[0]="b";

echo $arr;

echo $arr[0];

bb

Question:
For the following code:

the output will be:

171

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

19

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

echo $var;

-1299

Question:
What will be the output of following code?

$var1="a";

$$var1="b";

echo "$var1 $a";

a b

Question:What is the output of the following code?

$a = 500;

$b = 200;

echo $a % 2

* $b;

?>

0

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

if (-1)

print "true";

else

print "false";

?>

true

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

echo 12 . 6;

126

Question:
Consider the following sample code:

$x = 0xFFFE;

$y = 2;

$z = $x && $y;

What will be the value of $z?