x9Vqys1dSq61ciaKAbaEFXEh5M0 Kholabangla: September 2011

Menu Bar

Sunday, September 25, 2011

How can you write a better cover letter for oDesk?

At oDesk cover letter is perhaps the most important aspect of your application. An oDesk cover letter needs to be written in a way that is relevant to the job at hand. A cover letter can make or break your job application, irrespective of your other portfolio items or previous experience. Therefore, it is extremely important to write the best letter possible to create a good first impression.
There are many misconceptions about writing oDesk cover letters or in fact any other freelance job opening cover letters. Part of this is because people tend to take the advice given for traditional cover letters while applying for offline jobs and use it for oDesk cover letters. This hardly works ever, if at all. Freelancing is a whole different ball game altogether and you need to understand the nuances of online communication.
In addition, it is worthwhile to remember that small business differ in their hiring process compared to big businesses at least when it comes to hiring freelancers. If you fail to know the distinction, you run the risk of losing a very good job opportunity. So here are some oDesk cover letter tips that will help you make that killer first impression. I am giving you these tips as a very successful oDesk freelance writer, with over 50 feedback ratings and a score of 5.00/5.00.
You will also find my 7 oDesk Tips article very useful if you are applying for freelancing jobs at oDesk or elsewhere.

Tip-1: Don’t Beat Around the Bush
This is one of the most common mistakes made by people applying to jobs at oDesk. A cover letter should be short and to the point. Does the job require designing a web page? Don’t talk about your C++ skills. Does the job require blog writing? Don’t talk about your experience in writing academic essays. Get to the point, be precise and show that you are fit for the job.
If you beat around the bush, it can mean that
• You haven’t read the job description fully, which is bad from the employer’s point of view.
• Worse, the employer thinks you are just copy-pasting your cover letter instead of preparing one for the job, so you are not interested.
You would of course not want to sound as either of the above, so once again, don’t beat around the bush: be precise and to the point.

Tip-2: Proofread your Cover Letter
You will be surprised by how many mistakes you can find in a typical cover letter at oDesk. This includes both spelling mistakes and grammatical errors. Make sure you proofread what you have written. If possible, let someone else do the checking as well, say a friend. It is usually hard for you to spot errors in a piece that you have written yourself.
One very important thing to remember is never to make spelling errors. These are instant turn offs. I always use Mozilla Firefox while writing a cover letter, so any spelling mistakes are immediately highlighted. If not, write it in MS Word and paste it in the main cover letter area.
If you have confusion regarding some elements of grammar, always check a reference. Check out the common grammatical errors and see if you make any of those. If needed, use a grammar reference guide as well.

Tip-3: Never Copy-Paste
Here is a little trick that I use whenever I apply to any job at oDesk. Each job is unique and there are unique skills required. There could always be some overlap, but my overall tone needs to be consistent throughout. So, whatever happens, I never copy-paste anything into my cover letter. Not even my standard qualifications, my strengths, my feedback, etc. I write them all from scratch.
Why do I do that? Because of consistency. It is not hard for an experienced person to judge if you have heavily copy-pasted your cover letter and have a generic tone instead of a specific one for the job. Be on the safe side,

Tip-4: Apply Keeping the Job in Mind
Never ever write a very general cover letter which has nothing to do with the job in hand. If you don’t copy paste, half the battle is won. Next, you should read the job description. List out what skills and experience is required for the job. This may not be stated explicitly, so you should be able to understand what skills are required. Now demonstrate that you have those skills. Every sentence you write should be written keeping the job in mind. Of course you want your strengths to be shown, but only as relevant to the job. You may be a national level sprinter, but don’t mention it on a cover letter applying for a PHP programming job. Always be relevant.

Tip-5: Point to your Strengths
oDesk has many tools that help you show your previous experience and work. You should complete your full profile before you get started on the site and before you write any single cover letter.
Now, look at the strengths in your profile. You might have a very good portfolio and may have previously written for magazines and newspapers but be new to oDesk. In that case, your previous experience is your greatest strength. You should mention it in the cover letter. If you have previously designed web pages, show your work.
For those who are a little older at oDesk, mentioning about your feedback might be a good way to catch the attention of the employer if it is good. I often mention that I am one of the highest rated writers at oDesk with a perfect feedback of 5.00/5.00. This helps my application to stand out.
Sometimes, if you don’t have a lot of previous experience at oDesk or elsewhere but are good at what you do, consider giving many relevant oDesk tests. If you are among the Top 10% or 1st place, it is worth mentioning in your cover letter, especially if you are new and don’t have a lot of feedback.
In the end, it is all about standing out. The employer probably gets 15-20 applications on an average for every job posting, and much more in some cases. At a quick glance, he should know that you are worth considering, so write something that distinguishes you from the crowd. Create a unique selling point.

Tip-6: Always Follow Instructions
It is very important to follow the instructions given in the job posting. If the job requires that you show some samples of your work, show the samples. If it requires you to send a detailed resume, send one. Never neglect the steps outlined in a job posting.
In addition, a lot of people, of late, require you to include a letter or phrase at the beginning to ensure that you have read the whole job description. Without this, they will not even read your cover letter and your entire effort will go waste. So make sure you follow such instructions carefully as required.

Tip-7: Show you are Interested
Always show your interest. You can include a sentence or two about why you think the job is exciting for you. Talk about enjoying a challenging assignment and relate the current job to your previous experience working.
Sometimes, to show that you are interested and serious, include an email and phone number. It is highly unlikely they will call you, but it shows that you are serious and interested in the job.

How can start work on oDesk Platform?

To Starting your freelancing job is somewhat challenging. There are a number of things that you should consider in clinching your desired freelance job. I personally love freelancing jobs as I don’t have to go to an office sitting for hours and getting some badly commands from my Boss. I am free and I do what I love to do. I do my jobs sitting on my relaxing armchair whenever I love.


However, truth be told that, it’s not easy to get a freelance job unless you know the exact and appropriate strategies. There are millions of people around the world who seek freelance jobs every day. But do all of them get their desired job? However, no big deal, I am going to tell you how to get a freelance job by the means of odesk.

1. Getting An Overall Idea:

People around the world are getting smarter day by day by the means of technological advancement. However, before starting your freelance career, I personally believe that you have to have a crystal and clear idea about a freelance site. However, visit the website and get an overall idea. Go to you tube and see the animated video. Here are the links:

Website: www.odesk.com

You Tube: [youtube]

2. Sign Up:

I hope you have got a clear idea about odesk. However, now it’s time to sign up. Go to the website and sign up by filling some pieces of information. Sadly, most of the new freelancers don’t seem interested in uploading a photograph. But, I personally think, a photograph is an important thing for your freelance career. Visibility is very important to a buyer. Make sure that you fill everything with valid and correct information.

3. Complete Your Profile:

It’s very disappointing that, most of the new providers don’t complete their profile on odesk. However, in order to get your first freelance job, you have to complete your profile with legitimate information. Make sure that you fill all categories correctly including portfolio projects, employment history, education, certifications etc. Your profile will look good and you will have better chance of getting your first freelance jobs upon completing your profile.

# Be careful in choosing/writing your objectives. Your objective should focus on your skills.

# Be careful in choosing your hourly rate. It’s recommended that in the primary stage it shouldn’t be more than $ 12/ hour. You may increase/ decrease the rate later.

4. Take Some Tests:

Taking some tests make your profile attractive that simply helps you get your first freelance job. However, on odesk you will find hundreds of tests. For instance if you are a PHP developer, you may take php tests, if you are article writer; you should take some writing skill test. However, I recommend that every new provider who is looking for a freelance job should take Basic English language proficiency tests. Such as, US English basic skills test, UK English test etc. In order to get a freelance job, it’s important that you have minimum English language proficiency.

5. Make a Good Cover Letter:

Well, it’s time to make a good cover letter. A cover letter is one of the key elements of getting your first freelance job. However, so what is a cover letter? A cover letter is kind of letter that primarily includes your skills, qualifications, work experience etc. This is the first thing that your buyer will notice prior to hiring you. For each and every job, you have to apply with a cover letter.

Finally, I can say that it may take a few days for you to get your first freelance job by the means of odesk. However, you would be surprised that, it took me almost a month to get a job. The situation was like that I lost the hope of getting a job. Nevertheless, the reason was that, my profile wasn’t complete and my job cover letter wasn’t appealing. So, be patient and consistent. Your desired job is waiting for you.

Why oDesk?

Here are some interesting facts about oDesk:


1. oDesk is FREE! You can create your account free of charge. Yes my friend, you don't have to pay anything to join oDesk. Unlike other websites that ask you for payments before you can join and start earning some money.

2. oDesk is for Everyone! Anyone can join oDesk, even if your a college student trying to earn some pocket money, a Full-Time worker working during the day or a retired employee looking to do something and money out of it. Nationality is not a problem as all are equal here as long you have the equipments, the right attitude and the determination to be successful, you are welcome here.

3. oDesk is not a Get to Rich Scheme! In my point of view, you will not really get rich by doing some jobs here. Although I saw some provider who earns as much as $40,000. Its quite amazing and I sometimes envy them with a smile in my face hoping I can also earn that kind money. But of course, it is a fruit of their month long labor.

4. oDesk provides hundreds of jobs everyday! Everyday is a new day in oDesk, expect to find new jobs every hour of the day. Buyers from different part of the world post their jobs to seek for a quality provider to work from them.


5. oDesk offers vast variety of job categories! It includes Administrative Support, Writing and Translation, Customer Service, Software Development, Sales and Marketing, Networking and Information Systems, Design and Multimedia and Business Services. Those are just the main categories, there are still more sub categories inside it.

6. oDesk has different Payment Options! Worrying about on how you can get your earnings? Worry no more as oDesk has different payment methods available and can be use on different countries in the world. Namely oDesk Debit MasterCard (powered by Payoneer), Paypal, Moneybookers, Direct Deposit/ACH (for US providers only) and Wire Transfer (not recommended as it cost a whooping $30 per transaction).

7. oDesk give their software application for FREE! You can download an application that you will use when doing the job. You don't have to pay for it, just download it from their website or click here. It will be use so that your buyer can manage and look if you are doing your job and it can be your proof that you are really doing your job. This is very applicable if you are working on a hourly rate.

8. oDesk have good Tech Support! If you have questions or problems regarding your accounts or anything related to odesk, you can shoot them some tickets and they will reply back to you as soon as possible. Or while waiting, you may read some threads in their forums and maybe you can find some of the answers in your problem. oDesk have representatives there that actively maintain the forum.

Still having second thoughts in joining oDesk? Try it yourself, it will not hurt. Instead it will open a door of countless opportunities.

What is odesk ?

oDesk is a freelancing website that offers job wherein you can work part-time in your house plus you earn dollars. It is the largest and fastest-growing global employment platform. Contractors are guaranteed every hour worked is an hour paid, and employers are guaranteed that every hour billed is an hour worked.

There are thousands of freelancing website to earn money online and sadly most of them were just scams. But you may find lots of people who are earning from oDesk. If you want you can try it right now.

oDesk allows employers (“buyers”) to create online workteams coordinated and paid through thecompany's proprietary software and website. The name is a short version of "no desk" in reference to the company's intent to enable anyone to work anywhere, anytime. Prospective employers can post jobs for free, and freelance workers (“providers”) may create profiles and bid on jobs, also for free. The company puts potential providers through “a rigorous screening”. The company collects 10 percent of the payment. Payments are made through oDesk, which handles many bookkeeping tasks for the transaction. In addition to the marketplace aspect and the payment/bookkeeping services, the company uses collaborative software, “oDesk Team,” that allows employers to see a provider's progress while he or she is billing time. This aspect of the company's business model has drawn criticism.

The company describes itself as a staffing marketplace and management platform. As of Jan. 10, 2009, the company reports that nearly 37,000 of its 170,000 providers are in the United States. The company's site is entirely in English, and transactions are made in U.S. dollars. The site does not post statistics regarding locations of buyer companies, but a comment posted by an oDesk employee noted that the majority are U.S.-based. In December 2009, the company's self-reported tally of services paid through its site had passed $113 million. The specific areas of expertise supported by the site include web development and a wide variety of programming/software development skills, graphic design, writing and administrative support. The company provides voluntary skills tests in various disciplines from English aptitude to specific programming skills, and profiles include a feedback mechanism.

Want to visit now? [click here]

Thursday, September 22, 2011

oDesk Php 5 Test Answers :

1) Class emp extends person{
funciton GetSal()
{
???
}
}
?>
The getSal() of emp has to behave exactly as getSal() of person .which of the folliwing lines of code would you use to replce the
????


a. perent:: getSal();
b. person:: getSal();
c. parent:: getSal;
d. person:: getSal;

2) what would be the output of the following code?
$stg=’good day’;
$stg= ucwords($stg);
echo $stg;
?>


a. good day
b. GOOD DAY
c. Good Day
d None of the above

3) which of the following command line interface constant is not defined in the cli sapi?

a. STDIN
b. STDOUT
c. STDPRT
d STDERR

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

a. 1 hr
b. 2 hr
c. 3 hr
d 4 hr

5) Which of the following is not a correct way of commenting in php?

a. //php comment
b. /*php comment*/
c. #php comment
d /# php comment

6) What is true regarding this code?

a. setcookie will return false
b. setcookie will return true
c. setcookie will return null
d. Any of the above can happen

7) Which of the following is not a correct way of printing text in php5?

a. echo “Plain text”;
b. <# echo “Plain text” #>

8) Which of the following is not the correct way of starting a session?

a. session.auto_start
b. session_register()
c. session_initiate()
d. session_start()

9) Which of the following functions do you need to implement HTTP Basic Authentication?

a. authenticate ()
b. header ()
c. basic_auth ()
d. None of the above

10) Which of the following Command Line Interface constant is not defined in the CLI SAPI?

a. STDIN
b. STDOUT
c. STDPRT
d. STDERR

11) Which of the following statements is correct with regard to final and abstract?

a. An abstract class cannot have final methods
b. An abstract class cannot have non abstract methods
c. A final class cannot have abstract methods
d. A final class cannot have final methods

12) Which composite data types are supported by php?

a. Array
b. Enumeration
c. List
d. Object
e. Integer

13) The default value of register_globals in PHP is:

a. Off
b. On

14) Which of the following is not a valid PHP connection status?

a. aborted
b. normal
c. open
d. timeout

15) Choose the correct statement:

a. include() includes and evaluates a specific file
b. require() includes and evaluates a specific file
c. include_once() includes and evaluates a specific file only if it has not been included before
d. require_once() includes and evaluates a specific file only if it has not been included before
e. All of the above

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

a. 1 hr
b. 2 hrs
c. 3 hrs
d. 4 hrs

17) 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

18) State whether True or False
Paamayim Nekudotayim operator allows access only to the static members of a class?


a. True
b. False

19) Which of the following statements is true with regard to comparisons in PHP5?

a. With “= =” operator, two object instances are equal if they have the same attributes and values, and are instances of a different class.
b. With “==” operator two object instances are equal if they have the same attributes and values, and are instances of the same class.
c. With (===) operator, object variables are identical if and only if they refer to the same instance of the same class.
d. With (===) operator, object variables are identical if and only if they refer to the different instance of the same class.

20) You have to upload a file using form post method:
1
2 Send this file:
3
4
What should be the code in line 3, if the file name to upload is “SalesFile”?


a.
b.
c.
d.

21)Which of the following built-in function assist in checking if actually the function exists or not?

a. exists
b. function_exists
c. fexists
d. isFunction

20) What will be the output of the following code?
$a = 0.0;
for ($i = 0; $i < a =”=””>


a. 0.9
Not Equals
b. 1
Equals
c. 1
Not Equals

d. 1.1
Not Equals
e. None of the above

21)What will be the output of the following code?
$i=4;
$j=30;
$k=0;
$k=$j++/$i++;
echo $i . ” ” . $j . ” ” . $k . ” “;


a. 5 31 6
b. 5 31 6.2
c. 5 31 7
d. 4 31 7.5
e. 5 31 7.5

22) Which of the following is a not a correct way of commenting in php?

a. //PHP Comment
b. /*PHP Comment*/
c. #PHP Comment
d. /#PHP Comment

23) Following is a php code block:
$m=9;
$n=99;
$z=8;
$z=$n++/$m++ + –$z;
echo $z;
what will be the output?


a. 16
b. 18
c. 19
d. 20
e. 17

24) Which of the following is the correct 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”) { . . . }

25) With reference to the following php script:
print ‘Text Line1?
print ‘Text Line2?
?>
What will be the output on running the script?


a. Text Line1Text Line2
b. Text Line1 Text Line2
c. ‘Text Line1?
d. ‘Text Line2?
e. Error message will be printed


26) Late PHP versions support remote file accessing for the functions:

a. include()
b. include_once()
c. require_once()
d. Both a and b
e. Both b and c

27) 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;
d. All of the above

28) Which of the following does not represent logical AND operator in PHP?

a. &
b. &&
c. And
d. AND

29) Which of the following are invalid data types in PHP?

a. string
b. integer
c. float
d. char
e. array
f. object

30)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?


a. $ofc->getManager()->printName();
b. new Office()->getManager()->printName();
c. $ofc->getManager->printName;
d. Office::getManager()::printName();

31)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?


a. protected function getName(){}
b. function getName(){}
c. private function getName(){}
d. public function getName(){}

32) Which of the following variable declarations within a class is invalid in PHP5?

a. private $type = ‘moderate’;
b. var $term =3;
c. public $amnt = ’500?;
d. protected $name = ‘Quantas Private Limited’;

33) What will be the output of following code?
$arr = “a”;
$arr[0]=”b”;
echo $arr;
echo $arr[0];


a. ab
b. $arr is undefined
c. bb
d. Parse error

34) What is the result of the following expression?
5+2 * 4+6


a. 70
b. 19
c. 34
d. 21

35) What will be the output of following code?
$var = 1 + “-1.3e3?;
echo $var;


a. -1299
b. 1
c. 1-1.3e3
d. Error:cannot add integer and string

36) What will be the output of following code?
$var1=”a”;
$$var1=”b”;
echo “$var1 $a”;


a. a b
b. $var1 $a
c. Error: $a is undefined
d. Error: Parse error in line 2 ($$var1 = “b”)

37) What is the output of the following code?
$a = 500;
$b = 200;
echo $a % 2
* $b;
?>


a. 100
b. 200
c. 500
d. 0
e. Syntax error

38) What will be the ouput of the following code?
if (-1)
print “true”;
else
print “false”;
?>


a. true
b. false

39)What will be the output of the following code?
echo 12 . 6;


a. 12 . 6
b. 126
c. 12.6
d. Error: You cannot add integers through the concatenation operator(.)


40)Consider the following sample code:
$x = 0xFFFE;
$y = 2;
$z = $x && $y;
What will be the value of $z?


a. 0
b. 1
c. 2
d. 3
e. 4

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

42) You 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”

43) How 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

44) What 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. Error

45) Which 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

46) Which of the following set of operations is not valid in PHP 5?

a. >, >=
b. =,==
c. !==,!==
d. +=, *=

47) Late PHP version support remote file accessing for the functions:

a. include()
b. include_once()
c. require_once()
d. All of the above

48) which of the following are used for code reuse?

a. Loops
b. functions
c. Database
d. include files

49) Which of the following are ”magic constant’?

a. __LINE__
b. __FILE__
c __PRETTY_FUNCTION__
d __CLASS__
e. __METHOD__

50)What is the result of the following Exprssion?
5+2*4+6


a. 70
b. 19
c. 34
d. 21

51) The default value of register global in PHP is:

a. Off
b. On

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


53)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){}

Wednesday, September 21, 2011

Odesk test answers

# What is odesk ?

# Why oDesk?

# How can start work on oDesk Platform?

# How can you write a better cover letter for oDesk?

01) oDesk readiness test answers

02) oDesk Microsoft Excel Test answers

03) oDesk U.S. English Basic Skills Test answers

04) oDesk English Spelling Test (U.S. V) answers (part-1)

05) oDesk English Spelling Test (U.S. V) answers (part-2)

06) oDesk C++ Test Answer

07) oDesk Photoshop CS3 test answers

08) oDesk joomla 1.5 test answers

09) oDesk SEO test answer

10) oDesk PHP Test Answers

11) oDesk Php 5 Test Answers
Contact Us

Hello Readers! If you would like to ask some questions, say something to me or share about everything? Please contact me through the contact form below. I will respond it as soon as possible. Thanks.













Contact Form












































Auto Confirm Or Ignore Friends Request on Facebook

When adding tons of friends every day, you will also get at the same time tons of friend requests to confirm. Facebook do not offer an easy way to accept them all, so this task is really boring and long to do one by one. But we found a special tool for you so you can use to do this automatically whit the push a button. This will do the work in around 5 seconds instead of 1 hour or more.

• First you need a new browser if you don’t have it already. It is called Mozilla Firefox and you can download it free here: http://www.mozilla.com/ .

• Then you’ll need to install a little add-on called GreaseMonkey. Open this link with Firefox: https://addons.mozilla.org/firefox/addon/748 .

• Now add a script the GreaseMonkey add-on to work with Facebook click install on this page: http://userscripts.org/scripts/show/43682 (Latest and working, thanks to aljaz)

Now the auto friend confirm is enabled. To see that its enable, in Firefox again you can click on tools and scroll until GreaseMonkey. You’ll see a check before enabled.
But before going on Facebook and trying this script, we suggest you go on internet explorer on your Facebook account you want to confirm request and ignore the others requests (group pages, event, etc..) so that the script will not confirm every request he see. You don’t want to join every groups and pages people invites you. Be careful to Not ignore all your friend request.
To ignore other requests you go on Facebook, click on home, then where you see the request at the top left click on See All. Then click on Ignore All, this will pop-up a little window where you’ll be able to check what you want to ignore. So don’t check friend requests and check all others.
Now that this is done, you can login to this account in Firefox and go click on your friend requests. And Boom!! Automatically they will all be confirmed.
Don’t forget that Facebook allows only 5000 friends per account so don’t try to get more, it is impossible.

Method: 2

This techniques could be a little bit easier for some. First go on this link in Mozilla Firefox: http://vern.com/mwtools/ . Scroll down on the page until you see a ConfirmAll yellow button. What you need to do is click this button and drag it to your bookmarks tab, drag it just under the address bar. This will create a little clickable icon there. Now login to your facebook account, click on your friend request to see them all, and click on your ConfirmAll bookmarked button. You will see at the top right a little fields appearing where you can write the max confirms to do and the seconds between each ones. So depending on how many friend requests you have to confirm write a number in the max confirms field, and we added 0 seconds between so it is faster.
Then Click Start and the script will go and confirm your friend requests.
You will see your friend requests number going down. When you see it stopped this means that the script finish to accept friends on the current page, so just it refresh and click start again.
Hope you enjoyed this cool methods.

Sunday, September 18, 2011

ফোল্ডার লুকান অন্যরকম ভাবে

আপনার কম্পিউটারে কি ব্যবহারকারী অনেক ???

কিন্তু কম্পিউটারে আপনার ব্যক্তিগত কিছু ফো্ল্ডার আছে ???

আপনাকে ফো্ল্ডারটি লুকতে হবে। তার জন্য আপনার software প্রয়োজন হবে না। এর জন্য দরকার দুইটি bat ফাইল। bat ফাইল তৈরির নিয়মঃ

আপনি D ড্রাইভের movies ফো্ল্ডারটি লুকতে চান তাহলে নিচের কাজ অনুসরন করুন

In the same drive create a text file and type ren movies movies.

{21EC2020-3AEA-1069-A2DD-08002B30309D}

Now save this text file as loc.bat

Create another text file and type in it In the same drive create another a text file and type ren movies

{21EC2020-3AEA-1069-A2DD-08002B30309D}

movies Now save this text file as key.bat

এখন আপনি ঐ loc.bat ক্লিক করলে ফোল্ডারটি control panel হয়ে যাবে।

ফোল্ডারটি ফিরে পেতে চাইলে key.bat এ ক্লিক করলেই আবার তা ফিরে আসবে।

নেটওয়ার্কের সকল কম্পিউটার মনিটর এবং নিয়ন্ত্রণ

কম্পিউটার ল্যাব, সাইবার ক্যাফে বা অফিসের কম্পিউটার ব্যবহারকারীরা কে কি করছে তা মনিটর এবং নিয়ন্ত্রণ করা দারুন এক সফটওয়্যার হচ্ছে ক্লাসরুম স্পাই। উইন্ডোজ অপারেটিং সিস্টেমে চালিত কম্পিউটারে এই সফটওয়্যারটি নেটওয়ার্ক এ্যাডমিনিস্ট্রেটরদের দারুন কাজে দেবে।
লোকাল নেটওয়ার্কের মাধ্যমে সংযুক্ত আছে এমন অফিসে কর্মকর্তারা, সাইবার ক্যাফের ব্যবহারকারীরা, কম্পিউটার ল্যাবের ছাত্ররা তাদের কম্পিাউটারে বসে কে কি করছে তা মনিটর করা বা রিমোটলি নিয়ন্ত্রণ করা যাবে ক্লাসরুম স্পাই সফটওয়্যার দ্বারা। মাইক্রোসফটের রিমোট ডেক্সটপ দ্বারা লোকাল নেটওয়ার্কের থাকা রিমোট কম্পিউটার নিয়ন্ত্রণ করা যায় কিন্তু ক্লাসরুম স্পাই এর মত এতো ভালভাবে মনিটর করা যায় না। মাত্র ১১ মেগাবাইটের এই সফটওয়্যারটি www.eduiq.com বা www.classroomspy.com সাইট থেকে ডাউনলোড করা যাবে।
সফটওয়্যার ইনস্টল করা: সফটওয়্যারটির দুটি অংশের একটি হচ্ছে Console আর একটি হচ্ছে Agent| এই Console মুডটা হচ্ছে নেটওয়ার্ক এ্যাডমিনিস্ট্রেটরের জন্য আর Agent মুডটা হচ্ছে যাদের মনিটর করা সেই কম্পিউটারের জন্য।
সফটওয়্যারটি ইনস্টল করার সময় Click here to install ″Classroom Spy Professional Console″ এবং Click here to install ″Classroom Spy Agent″ নামের দুটি বাটন আসবে। এখন Stealth Agent Install চেকবক্স চেক করে Click here to install ″Classroom Spy Agent″ বাটনে ক্লিক করে ইনস্টল করুন এবং পাসওয়ার্ড সেট করুন যা পরবর্তীতে এই কম্পিউটারটিকে রিমোট করার সময় প্রয়োজন হবে। শেষে Start Agent বাটনে ক্লিক করে সার্ভিস চালু করুন এবং ইনস্টল সমাপ্ত করুন।
নেটওয়ার্ক এ্যাডমিনিস্ট্রেটরের কম্পিউটারে Classroom Spy Professional Console মুড ইনস্টল করে চালু করুন তাহলে প্রথমবার পাসওয়ার্ড সেট করতে হবে যা পরবর্তীতে Classroom Spy Professional Console চালু করতে লাগবে।
রিমোট কম্পিউটার যোগ করা: প্রথমে Classroom Spy Professional চালু করে বাম পাশের প্যানেল থেকে Add Computer বাটনে ক্লিক করুন। এবার Remote computer (host or IP) এ রিমোট কম্পিউটারের নাম বা আইপি এড্রেস লিখুন, Nikename এ কম্পিউটারটির নাম দিন (বোঝার সুবিধার্থে) এবং Agent’s password এ উক্ত রিমোট কম্পিউটারের সেট করা পাসওয়ার্ড দিন। Advanced Options ট্যাবে গিয়ে Color Level কালার 16M নির্বাচন করে Basic Options ট্যাবে এসে Remote Assistant Configure / Installation বাটনে ক্লিক করুন এবং উক্ত কম্পিউটারের এ্যাডমিনিস্ট্রেটর ইউজার নেম এবং পাসওয়ার্ড দিয়ে Connect বাটনে করে Classroom Spy Configuration এ পুনরায় রিমোট কম্পিউটারের Agent’s password দিয়ে Ok করুন এবং সবশেষে Add Computer ডায়ালগ বক্সে Ok করুন। তাহলে Classroom Spy Professional এর Remote Screens ট্যাবে কম্পিউটারটির বর্তমান অবস্থান দেখা যাবে। এভাবে আরো রিমোট কম্পিউটার যোগ করা যাবে।
রিমোট কম্পিউটার মনিটর করা: রিমোট কম্পিউটার মনিটর করতে চাইলে Remote Screens ট্যাবে প্রদর্শিত থাকা কম্পিউটারের উপরে মাউসের ডান বাটন ক্লিক করে Zoom Remote Screen এ ক্লিক করলে বড় পর্দায় উক্ত কম্পিউটারের ডেক্সটপ দেখা যাবে। উক্ত কম্পিউটারটি কোন কাজ করতে চাইলে Enable Control চেক বক্স চেক করলে মাউস বা কীবোর্ড দ্বারা উক্ত কম্পিউটারে কাজ করা যাবে। আর প্রদর্শিত থাকা কম্পিউটারের উপরে মাউসের ডান বাটন ক্লিক করে Remote Control এ ক্লিক করলে Enable Control সক্রিয় হয়ে বড় আকারে দেখা যাবে। উক্ত ডেক্সটপটি পূর্ণ পর্দায় দেখতে Full Screen বাটনে ক্লিক করতে হবে।
রিমোট কম্পিউটারে ম্যাসেজ পাঠানো: রিমোট কম্পিউটারের সবগুলোকে বা নির্দিষ্ট কোন কম্পিউটারে ম্যাসেজ পাঠাতে Classroom Spy Professional এর Show Massage/Block Computer ট্যাবে গিয়ে ডানপাশের প্যানেল থেকে কম্পিউটারগুলো নির্বাচন করে Mesage text এ ম্যাসেজ লিখে নিচের Show Message / Block Computer বাটনে ক্লিক করুন তাহলে নির্বাচিত কম্পিউটারগুলোতে ম্যাসেজ প্রদর্শিত হবে। ম্যাসেজ উইন্ডো রিমোট কম্পিউটারের ব্যবহারকারীরা বন্ধ করতে পারবে আর নেটওয়ার্ক এ্যাডমিনিস্ট্রেটর সকল কম্পিউটারে পাঠানো ম্যাসেজ বন্ধ করতে Hide Message / Block Computer বাটনে ক্লিক করলেই হবে।
নিজের ডেক্সটপ শেয়ার করা: নেটওয়ার্ক এ্যাডমিনিস্ট্রেটরের নিজের ডেক্সটপটি শেয়ার দিতে চাইলে Classroom Spy Professional এর Share Desktop ট্যাবে গিয়ে ডানপাশের প্যানেল থেকে যে যে রিমোট কম্পিউটারে ডেক্সটপ শেয়ার দিতে চান সেগুলো নির্বাচন করে Start Sharing Desktop বাটনে ক্লিক করুন। রিমোট কম্পিউটারের ডেক্সটপকে নিস্ক্রিয় করে শুধুমাত্র আপনার ডেক্সটপকে দেখাতে বাধ্য করতে চাইলে নিচের Full Screen এবং Lock Computers চেক করুন শেয়ার দিতে পারেন। এছাড়াও Color Level থেকে কালারের মান পরিবর্তন করতে পারবেন। শেয়ার বন্ধ করতে Stop Sharing Desktop বাটনে ক্লিক করলেই হবে।
ডেক্সটপ রেকর্ড করা: রিমোট কম্পিউটারের ডেক্সটপ রেকর্ড করতে Desktop Recorder ট্যাবে গিয়ে Record বাটনে ক্লিক করুন এবং যে যে রিমোট কম্পিউটারের ডেক্সটপ রেকর্ড করতে চান সেগুলো নির্বাচন করে Ok করুন। তাহলে ডেক্সটপ মনিটর শুরু করলে উক্ত রিমোট কম্পিউটারে সেভ হবে। রেকর্ড করা ভিডিও দেখতে চাইলে Open Network Share বাটনে ক্লিক করলে সেভ হওয়া ফোল্ডার খুলবে।
কম্পিউটার বন্ধ করা রির্স্টাট করা: রিমোট কম্পিউটার বন্ধ, রিস্টার্ট, হাইবারনেট, স্ট্যান্ডবাই, লগঅফ, স্ক্রিনসেভার চালু, স্ক্রিনসেভার বন্ধ বা লক করতে চাইলে Tools ট্যাবে যান এবং নির্দিষ্ট বাটনে ক্লিক করে রিমোট কম্পিউটারগুলো নির্বাচন করে Ok করলেই হবে। এখান থেকে রিমোট কম্পিউটারের কমান্ড প্রম্পট, রান বা ওয়েবসাইট চালু করা যাবে।
প্রোসেস থাকা প্রোগ্রাম বন্ধ করা: রিমোট কম্পিউটারগুলো থেকে প্রোসেস চলতে থাকা নির্দিষ্ট কোন প্রোগ্রাম বন্ধ করতে Processes ট্যাবে গিয়ে যে প্রোসেসটি বন্ধ করতে চান সেটি নির্বাচন করে Kill all with the same name বাটনে ক্লিক করে রিমোট কম্পিউটার নির্বাচন করে Ok করলেই হবে।
পোর্ট বন্ধ করা: রিমোট কম্পিউটারের কোন পোর্ট বন্ধ করতে চাইলে Internet Control ট্যাবে গিয়ে বন্ধ করতে পারেন।
এছাড়াও Classroom Spy Professional Console এর Add Group of LAN Computers বাটনে ক্লিক করে নেটওয়ার্কে থাকা সকল (নির্বাচন করে) কম্পিউটারগুলোতে Classroom Spy Professional Agent ইনস্টল করা যাবে।

কোন সফট ছাড়াই পরিবর্তন করুন মাই কম্পিউটার, রিসাইকেল বিন ইত্যাদির আইকন

আপনার ডেস্কটপে কি মাই কম্পিউটার, মাই ডকুমেন্টস, মাই নেটওয়ার্ক প্লেসেস, রিসাইকেল বিনের আইকন আছে? যদি থাকে তবে আপনি কি তাদের আইকন পরিবর্তন করতে চান?

ডেস্কটপের সকল প্রোগ্রামের শর্টকাট ও ফোল্ডার আইকন সাধারণভাবে অর্থাত রাইট ক্লিক করে পরিবর্তন করা যায় (উদ্দিষ্ট শর্টকাট রাইট ক্লিক করে Properties>Change Icon বা উদ্দিষ্ট ফোল্ডার রাইট ক্লিক করে Properties>Customize>Change Icon)। কিন্তু মাই কম্পিউটার, মাই ডকুমেন্টস, মাই নেটওয়ার্ক প্লেসেস, রিসাইকেল বিনের আইকন এ পদ্ধতিতে পরিবর্তন করা যায় না। এদের আইকন পরিবর্তন করার জন্য ডেস্কটপের যে কোন খালি জায়গায় রাইট ক্লিক করে Properties ক্লিক করুন। প্রাপ্ত ডায়ালগ বক্স থেকে Desktop ট্যাবে ক্লিক করুন। এবার Customize Desktop বাটনে ক্লিক করুন। প্রাপ্ত ডায়ালগ বক্স থেকে General ট্যাবে ক্লিক করুন। এবার যে আইকনটি পরিবর্তন করতে চান সেটি সিলেক্ট করে Change Icon বাটনে ক্লিক করুন। প্রাপ্ত আইকনসমূহের মধ্যে আপনার যদি কোনটি পছন্দ হয় তবে তা সিলেক্ট করে OK বাটনে ক্লিক করুন। অথবা আপনার যদি কোন পছন্দের আইকন থাকে তবে তা Browse বাটনে ক্লিক করে দিয়ে দিন। আপনি ইচ্ছে করলে exe, dll ইত্যাদি ফাইলে ইমবেড করা আইকনগুলোও ব্যবহার করতে পারেন। এছাড়া এক বান্ডেল আইকন পাওয়ার জন্য Browse বাটনের পাশের বক্সে %SystemRoot%\system32\SHELL32.dll টাইপ করে Enter চাপুন। আপনার পছন্দের আইকনটি সিলেক্ট করার পর OK বাটনে ক্লিক করে করে ডায়ালগ বক্সগুলো বন্ধ করুন।

ইউটিউব থেকে উচ্চমানের ভিডিও ডাউনলোড করুন

ভিডিও শেয়ারিং সাইটগুলো এখন বেশ জনপ্রিয়। এর মধ্যে গুগলের ইউটিউব থেকে ভিডিও আপলোড এবং ডাউনলোড হয় সবচেয়ে বেশী। কিন্তু অনলাইনের এই সব ভিডিওগুলো ফ্লাশ বেসড হওয়াতে এগুলোর বেজুলেশন বেশী থাকে না ফলে পর্দাজুড়ে দেখলে ভাল দেখায় না। আবার অন্য ফরম্যাটে কনভার্ট করলেও একই অবস্থা থাকে। সাধারণত ইউটিউব থেকে যে ভিডিওগুলো ডাউনলোড করি সেগুলো 320×240 রেজুলেশনের হয়ে থাকে। কিন্তু আপনি নতুন ভিডিও ডাউনলোড করতে চান তাহলে তা আরো উচ্চ রেজুলেশনে ডাউনলোড করতে পারেন। আপনি যদি http://youtube.com/watch?v=E2s14T6×5AM ঠিকানার ভিডিও ডাউনলোড করেন তাহলে তা 320×240 রেজুলেশনে ডাউনলোড হবে। আর উপরোক্ত ভিডিওএর ঠিকানার শেষে &fmt=6 যুক্ত করে ডাউনলোড করলে তা 448×336 রেজুলেশনে ডাউনলোড হবে। আর যদি শেষে &fmt=18 যুক্ত করে ডাউনলোড করলে তা 480×360 রেজুলেশনে ডাউনলোড হবে। উচ্চ রেজুলেশনে ভিডিও ডাউনলোড পুরাতন ভিডিওর ক্ষেত্রে নাও হতে পারে তবে নতুন আপলোড করা ভিডিও এভাবে উচ্চ রেজুলেশন ডাউনলোড হবে।

পাসওয়ার্ড দেখার সফটওয়্যার

বিভিন্ন সফটওয়্যারে বা অনলাইনে আমরা যে পাসওয়ার্ড দিয়ে থাকি তা স্টার (*) বা ● হিসাবে দেখা যায়। ফলে আপনার টাইপ করা পাসওয়ার্ডের লেখা (টেক্সট) দেখা যায় না। কোন কারণে আপনি যদি পাসওয়ার্ড দেখতে চান তাহলে পাসওয়ার্ড ভিউয়ার সফটওয়্যারের সাহায্যে দেখতে পারেন। ১১৩ কিলোবাইটের ফ্রিওয়্যার এই সফটওয়্যারটি http://www.itsamples.com/software/pwv.html সাইট থেকে ডাউনলোড করা যাবে। এবার জিপ ফাইলটি আনজিপ করে PwViewer রান করে হাতের উপরে মাউস ধরে উপরের টারগেটটি যেকোন পাসওয়ার্ডের উপরে নিয়ে গেলে পাসওয়ার্ডির লেখা (টেক্সট) দেখাবে।

ওয়ার্ডে ছবি কাটছাঁট করা ও ছবি সাজানো।

ওয়ার্ডে ছবি কাটছাঁট করা ও ছবি সাজানো।
প্রথমে ওয়ার্ড লেখার মধ্যে নির্দিষ্ট ছবিটি বসান (পেষ্ট)। এবার ছবিতে ক্লিক করে ছবিটি নির্বাচন করলে পিকচার পাবেন (না থাকলে ভিউ-এর টুলবারে গিয়ে পিকচারে টিক দিন)।

এখান থেকে Crop বাটন নিয়ে ছবিটি তা আপনার ইচ্ছামতো কেটে ছোট করা যাবে। Text র‌্যাপিং বাটন থেকে square,tight ইত্যাদি নির্বাচন করে ছবিটি লেখার বিভিন্ন স্থানে বসানো যাবে।

oDesk English Spelling Test (U.S. V) answers (part-2) :

1) Choose the correct spelling of the word from the options below.

a. Carribean
b. ..Caribbean
c. Carribbean
d. Caribeen

2) Choose the correct spelling of the word from the options below.

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

3) Complete the following sentence by choosing the correct spelling of the missing word.

Many would-be travelers were _____________ by the price of gas last summer.

a. flabergasted
b. flabberghasted
c. ....flabbergasted
d. flabbergashted

4) Identify the misspelled word in the list below.

a. ....Accomodate
b. Analyze
c. Acknowledgment
d. Asterisk

5) Identify the misspelled word in the list below.

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

6) Complete the following sentence by choosing the correct spelling of the missing word.

Hazel Dormouse is a _________ creature.

a. nocternal
b. ..nocturnal
c. noctarnal
d. nacturnal

7) Identify the misspelled word in the list below.

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

8) Choose the correct spelling of the word from the options below.

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

9) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

10) Identify the misspelled word in the list below.

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

11) Identify the misspelled word in the list below.

a. Pageant
b. Poignant
c. ..Plummage
d. Priggish

12) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

13) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

14) Complete the following sentence by choosing the correct spelling of the missing word.

The crowd ________________ me on my acceptance into Mensa.

a. congradulated
b. congrachulated
c. ;;;congratulated
d. congratilated

15) Choose the correct spelling of the word from the options below.

a. Bureaucrasy
b. Buroucracy
c. ;;Bureaucracy
d. Beuraucracy

16) Choose the correct spelling of the word from the options below.

a. Unanimus
b. Unanemous
c. Unanimess
d. ;;;Unanimous

17) Complete the following sentence by choosing the correct spelling of the missing word.

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


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

18) Identify the misspelled word in the list below.


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

19) Identify the misspelled word in the list below.

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

20) Identify the misspelled word in the list below.

a. Enhancement
b. Elicit
c. ;;;Enegma
d. Ecstasy

21) Choose the correct spelling of the word from the options below.

a. ;;Synonymous
b. Synonymus
c. Synonimous
d. Sinonymus

22) Complete the following sentence by choosing the correct spelling of the missing word.

Emma has always been fascinated by the way the mind works, so she’s decided to get a degree in __________.

a. pshycology
b. psycology
c. psyhcology
d. ;;;psychology

23) Complete the following sentence by choosing the correct spelling of the missing word.

The church members accused the cult of _______________ practices.

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

24) Complete the following sentence by choosing the correct spelling of the missing word.

Sam _________ a successful political campaign.

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

25) Complete the following sentence by choosing the correct spelling of the missing word.

He wrote __________on every topic from shoestrings to string theory.

a. prollifically
b. prolificaly
c. prollificaly
d. ''prolifically

26) Identify the misspelled word in the list below.

a. Develop
b. ''Desciple
c. Dilemma
d. Discipline

27) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

28) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

29) Choose the correct spelling of the word from the options below.

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

30) Identify the misspelled word in the list below.

a. ;;Councelor
b. Condescend
c. Camouflage
d. Criticize

31) Choose the correct spelling of the word from the options below.

a. Vengeance
b. Vengance
c. Vengents
d. Vengence

32) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

33) Choose the correct spelling of the word from the options below.

a. Vacuum
b. Vaccuum
c. Vacumm
d. Vaccum

34) Choose the correct spelling of the word from the options below.

a. Persue
b. Parsue
c. Persou
d. Pursue

35) Complete the following sentence by choosing the correct spelling of the missing word.

The waitress brought me a plate of squid even though I _____________ asked for clams.

a. specificaly
b. specifically
c. specifycally
d. specificly

36) Complete the following sentence by choosing the correct spelling of the missing word.

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

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

oDesk English Spelling Test (U.S. V) answers (part-1) :

1. Choose the correct spelling of the word from the options below.

a. Reminiscience
b. Reminiscence
c. Reminescrence
d. Reminisense

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

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

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

3. Identify the misspelled word in the list below.

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

4. Identify the misspelled word in the list below.

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

5. Choose the correct spelling of the word from the options below.

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

6. Identity the misspelled word in the list below.

a. Develop
b. Desciple
c. Dilemma
d. Discipline

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

The savvy dancer acted as a _______ between the detective and the cabaret owner.

a. liasion
b. liaison
c. liasone
d. leason

8. Identify the misspelled word in the list below.

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

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

The annual _______ was ruined when a family of bears stole all the hotdogs.

a. barbecue
b. barbequeue
c. barbycue
d. barbcue

10. Choose the correct spelling of the word from the options below.

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

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

The waitress brought me a plate of squid even though I _______ asked for clams.

a. specificaly
b. specifically
c. specifycally
d. specificly

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

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

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

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

Arthur spent hours admiring the gothic _______ of all those French cathedrals.

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

14. Choose the correct spelling of the word from the options below.

a. Manoeuvar
b. Manouver
c. Maneuver
d. Manuver

15. Choose the correct spelling of the word from the options below.

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

16. Identify the misspelled word in the list below.

a. Wierd
b. Wired
c. Whined
d. Willful

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

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

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

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

Peter always makes such a _______ of himself!

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

19. Choose the correct spelling of the word from the options below.

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

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

Hazel Dormouse is a _______ creature.

a. nocternal
b. nocturnal
c. noctarnal
d. nacturnal

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

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

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

22. Choose the correct spelling of the word from the options below.

a. Referense
b. Refrence
c. Reference
d. Referance

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

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

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

24. Choose the correct spelling of the word from the options below.

a. Definitly
b. Definately
c. Defenitely
d. Definitely

25. Choose the correct spelling of the word from the options below.

a. Carribean
b. Caribbean
c. Carribbean
d. Carebeen

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

Clara the cat simply chose to ignore the ______ of our dog.

a. existence
b. existance
c. existense
d. existanse

27. Identify the misspelled word in the list below.

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

28. Identify the misspelled word in the list below.

a. Indivisible
b. Irresistable
c. Indispensable
d. Irresponsible

29. Choose the correct spelling of the word from the options below.

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

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

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

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

31. Choose the correct spelling of the word from the options below.

a. Restaureter
b. Restaurater
c. Restaurateur
d. Restourateur

32. Choose the correct spelling of the word from the options below.

a. Forfiet
b. Forfeit
c. Forefeit
d. Fourfit

33. Choose the correct spelling of the word from the options below.

a. Unanimus
b. Unanemous
c. Unanimess
d. Unanimous

34. Choose the correct spelling of the word from the options below.

a. Vacuum
b. Vaccuum
c. Vacumm
d. Vaccum

35. Identify the misspelled word in the list below.
a. Parallel
b. Prevalent
c. Prejudice
d. Perserverance

36. Identify the misspelled word in the list below.

a. Mischeivous
b. Misanthrope
c. Mussel
d. Malicious


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

He wrote __________ on every topic from shoestrings to string theory.

a. prollifically
b. prolificaly
c. prollificaly
d. prolifically


38. Choose the correct spelling of the word from the options below.

a. Persue
b. Parsue
c. Persou
d. Pursue
39. Complete the following sentence by choosing the correct spelling of the missing word.

Be sure to leave your travel _________ with the secretary so he'll know how to reach you while you're away.

a. itenreray
b. itinerary
c. iteneray
d. itinirary


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

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

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

oDesk joomla 1.5 test answers:

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

Ans: True

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

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

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

Ans: com_comprofiler

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

Ans: Global Configuration

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

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

Ans: True

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

Ans: Toolbar.php

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

Ans: Mysql

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

Ans: TinyMCE

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

Ans: False

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

Ans: Installer

13) What is not true about JoomlaXplorer?

Ans: None of the above

14) Which of the following is a system event?

Ans: OnDisplay

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

Ans: Index.php

16) When will you use SMTP authentication mail settings?

Ans: When you want to use an internal mail server

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

Ans: It means that STRICT_ALL_TABLES is enabled

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

Ans: All of the above

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

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

Ans: Block elements

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

Ans: None of the above

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

Ans: C

23) Why does Joomla use templateDetails.xml files?

Ans: All of the above

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

Ans: OnAfterDisplayContent

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

Ans: True

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

Ans: configuration.php

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

Ans: Each password in Joomla is stored as a MD5 hash value

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

Ans: True

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

Ans: Article manager

29) What do you understand from the following code?

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

Ans: B

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

Ans: None of the above

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

Ans: None of the above

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

Ans: v

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

Ans: True

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

Ans: All of the above

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

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

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

Ans: All of the above

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

Ans: It contains the basic authorship information

oDesk Photoshop CS3 test answers

1) Changing units on the Info Palette automatically changes the units on Rulers.

Ans: TRUE

2) Which of the following Filters cannot be applied to a Smart Object?

Ans: Pattern Maker

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

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

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

Ans: Bitmap

5) Which among the following Modes does not support layers?

Ans: All of the above

6) Which of the following is not true about Filters?

Ans: None of the above

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

8) Which of the following Slices is created with the Slice Tool?

Ans: User slices

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

Ans: It supports the Grayscale and Bitmap color modes

10) Which among the following blending modes is available only for the Apply Image and Calculations commands?

Ans: Both a and b

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

Ans: It can alter the shape of a selection

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

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

13) 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

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

Ans: None of the above

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

Ans: All of the above

16) Which of the following options displays the Spot Channels in the Channels palette?

Ans: B

17) 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

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

Ans: Choose Image > Adjustments > Levels

19) Which type of images are resolution-dependent?

Ans: Vector images

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

Ans: A

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

Ans: All of the above

22) Which of the following is not a kind of text type?

Ans: Line type

23) Which option will you select to convert Types to Shapes?

Ans: Both b and c

24) The mask created by the Replace Color command is permanent.

Ans: FALSE

25) Which of the following Layer properties can be animated?

Ans: All of the above

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

Ans: All of the above

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

Ans: B

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

Ans: Control + G

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

Ans: All of the above

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

Ans: Check In

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

Ans: All of the above

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

Ans: TRUE

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

Ans: All of the above

34) Which of the following is not a Color Adjustment command?

Ans: Adjustment command

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

Ans: FALSE

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

Ans: FALSE

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

Ans: C

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

Ans: FALSE

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

Ans: All of the above

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

Ans: All of the above

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

Ans: TRUE

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

Ans: MOV

oDesk PHP Test Answers:

1) The setrawcookie() method of setting cookie 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


2) IF visibility is not defined for a method /member then it is treated as public static.

a. True
b. False

3) Which of the following is not a valid php connection status?

a. Aborted
b. Normal
c. Open
d. Timeout

4) Which of the following statements is not true with regard to abstract classes in php5?


a. Abstract classes are introduced in php 5
b. A class with a single abstract method must be declared abstract
c. Abstract class can contain abstract methods
d.Abstract method must have method definition and can have optional empty braces following it

5) What will be the result of following operation?

Print 4<<5;

a. 3
b.128
c.120
d. 6

6) Which of the following type cast in not correct?

$fig=23;
$varbl=(real)$fig;
$varb2=(double)$fig;
$varb3=(decimal)$fig;
$varb4=(bool)$fig;
?>

a. real
b. double
c. decimal
d. Boolean


7) What is the result of the following expression?

5+2*4+6

a.70
b.19
c.34
d.21

8) The classes are defined as follows

Abstract class BaseCls(
Protected abstract function getName();
}
Class childCls extends BaseCls{
}
Which of the following implementations of getName() in invalid in childCls?

a . Protected function getName(){}
b. Function getName(){}
c. Private function getName(){}
d. Public function getName(){}



9) Multiple select/load is possible with:

a. checkbox
b. select
c. file
d. all of the above

10)State whether true or false

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

a. True
b. False

11) What is the output of the following code?

$a=500;
$b=200;
echo $a % 2 * $b;
?>

a. 100
b. 200
c. 500
d. 0
e. Syntax error


12) You need to heck the size of a file in php function .
$size=X(filename);

which function will suitable replace “X”?


a.Filesize
b.Size
c.sizeofFile
d.getSize

13) Which of the following is not true for a persistent connection?

a. these are not closed even after the execution of the script
b. these are mainly used to increase the efficiency of the system
c. these can’t be converted to non-persistent connections
d. these are preferable not used in the scripts involving transactions

14) Which one is correct?

a.$s=fwrite(“a string here”);
b.$s=fwrite($fp,”a string here”);
c.$s=fwrite(“a string here ”,$fp);
d.none of the above

15) Which will be the output of the following code?

$a=0.0;

For($i=0;$i<10;$i++)
$a+=0.1;
print “$a\n”;
if ($a==1.0)
print “equals”;
else
print “not equals”;
?>

a.0.9
Not Equals
b.1
Equals
c.1
not Equals
d.1.1

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

a. Enctype=”multipart/form-date”
b. Enctype=”singlepart/date”
c. Enctype=”file”
d. Enctype=”form-data/file”

17) Late php versions support remote file accessing for the functions:

a. Include()
b. Include_once()
c. Require_once()
d. All of the above

18) Given below is a small php script:

class person {
function getSal()
{
……
……
}
}
class emp extends person {
fucniton getSal()
{
???
}
}
?>
the getSal() of emp has to behave exacltyle as getSal() of person . Which of the following lines of code would you use to replace the “???”?

a. Parent:: getSal();
b. Person::getSal();
c. Parent::getsal;
d. Person::getSal;

পেনড্রাইভ ফরমেট না হলে ফরমেট করার উপায়

পদ্ধতি ১:

(১)প্রথমে My computer এ যেয়ে right click করুন।

(২)তারপরে Manage এ ক্লিক করুন। দেখবেন computer Management window

আসবে।

(৩)এবার Diskmanagement এ ক্লিক করুন।

দেখবেন আপনার ড্রাইভ গুলো শো করছে।

(৪)এবার আপনার পেনড্রাইভ সিলেক্ট করে রাইট ক্লিক করুন।

(৫)তারপরে Fomat এ ক্লিক করুন।





পদ্ধতি ২:

(১)প্রথমে স্টাট বাটন থেকে রানে ক্লিক করুন

(২)তারপরে cmd লিখুন

(৩)এবার কমান্ড প্রমপ্টের মধ্যে লিখুন

convert g:/fs:ntfs লিখে ইন্টার চাপুন।

[এখানে g আপনার পেনড্রাইভের ড্রাইভ লেটার]

(৪)এর পরে পেনড্রাইভ নরমাললি ফরমেট করুন ।





পদ্ধতি ৩:

(১)রান অপশনে যেয়ে Regedit লিখুন

(২)তারপরে যান Mycomputer>HKEY_LOCAL_MACHINE>SYSTEM>CurrentControlset>Control>Storage Device Policies

(৩)ডিলেট করুন Storage Device Policies এই অপশনটি।

(৪)তারপর নরমাললি পেনড্রাইভ ফরমেট করুন।



আশা করছি উপরের দেওয়া পদ্ধতি গুলো দিয়ে আপনি আপনার পেনড্রাইভ ফরমেট করতে পারবেন।

পিসি দ্রুততর করার দশটি সহজ টিপস

১/ কমপিউটার বুটআপ হয়ে ডেস্কটপে পুরোপুরি আসতে দিন , পুরোপুরি এসে স্টেবল হবার আগেই কোন আ্যাপ্লিকেশন স্টার্ট না করাই ভাল ।



২/ কোন এ্যাপ্লিকেশন বা প্রোগ্রাম ক্লোজ করার পর একবার হলেও ডেস্কটপ রিফ্রেশ করুন ডেস্কটপে রাইট মাউস ক্লিক করে , এতে সিস্টেম র‌্যাম থেকে অপ্রয়োজনীয়, অব্যবহৃত, পরিত্যক্ত ফাইল ঝরে যাবে ।



৩/ বড় সাইজের ইমেজ বা ছবি ওয়ালপেপার হিসেবে ইউজ করা থেকে বিরত থাকুন , র‌্যাম বেশি কম হলে ওয়ালপেপার ইউজ না করাই ভাল ।



৪/ খামোখা অজস্র শর্টকাট আইকন দিয়ে ডেস্কটপ ভরে ফেলবেন না , কারণ প্রতিটি শর্টকাট কমপক্ষে র‌্যামের ৫০০ বাইট দখল করে রাখে যা টোটাল সিস্টেম পারফরমেন্স কমিয়ে দিয়ে সিস্টেম স্লো করে দেয় । বেশি দরকারী হলে প্রয়োজনে ডেস্কটপে একটি ফোল্ডার বানিয়ে তাতে শর্টকাটগুলো পেস্ট করে রাখতে পারেন ।



৫/ রিসাইকেল বিন সবসময় খালি করে রাখুন । রিসাইকেল বিন খালি না করা পর্যন্ত আপনার হার্ডড্রাইভ থেকে ফাইলগুলো কিন্তু আসলে ডিলিট হয় না ।



৬/ টেম্পোরারি ইন্টারনেট ফাইলস যা সাধারণতঃ c:\windows ফোল্ডারে থাকে রেগুলার ডিলিট করবেন । অথবা স্টার্ট মেনু> একসেসরিজ থেকে 'ডিস্ক ক্লিন আপ' অপশন ব্যবহার করেও করতে পারেন ।



৭/ ফাইলগুলো ডিফ্র‌্যাগমেন্ট করে রাখুন অন্ততঃ প্রতি দু'মাসে একবার , এর ফলে আপনার হার্ডড্রাইভে অনেক খালি জায়গার সংস্থান হবে এবং ফাইলগুলো সুসংবদ্ধভাবে সজ্জিত হবে যার কারণে আপনার এ্যাপ্লিকেশনগুলো দ্রুততর হবে ।



৮/ সবসময় একাধিক পার্টিশন রাখুন হার্ডড্রাইভে , পিএসপি, ফটোশপ বা ৩ডি স্টুডিও ম্যাক্স এর মত বড় সফটও্য়্যারগুলো সেকেন্ড পার্টিশনে রাখুন , c:\ তে রাখবেন না , কারণ উইন্ডোজ আপনার হার্ডড্রাইভের এভেইলেবল পুরো জায়গাটাই ভার্চুয়াল মেমোরি হিসেবে ব্যবহার করে , যখন সিস্টেম র‌্যাম যথেষ্ট না হয় তখন এই জায়গাটাকে র‌্যাম হিসেবে ব্যবহার করে । কাজেই c:\ ড্রাইভ যতটা সম্ভব খালি রাখুন ।



৯/ যখনই নতুন সফটও্য়্যার ইনস্টল করবেন তখন খেয়াল করে সেটির সিস্টেম ট্রে শর্টকাট বাদ দিন , সিস্টেম ট্রের আইকনগুলো র‌্যাম ধরে রাখে যার ফলে পিসি স্লো হয়ে যায় , পরে টুলস বা প্রেফারেন্সেস মেনু থেকে বুটআপের সময় অনেক প্রোগ্রাম(উইন্ডোজের ছাড়া) স্টার্ট অপশন থাকে সেগুলোও বাদ দিন । ফলে বুটআপ দ্রুততর হবে ।



১০/ ধুলোবালি থেকে পিসিকে পরিষ্কার রাখুন ।ধূলোবালি আপনার CPU বা প্রসেসরের কুলিং ফ্যান জ্যাম করে দেয় ফলে এটি আর প্রসেসরকে যথার্থভাবে ঠান্ডা করতে পারে না , যার কারণে পর্যায়ক্রমে CPU গরম হতে থাকে এবং এটার প্রভাবে প্রসেসিং স্পিড স্লো হয়ে যায় । কাজেই CPU পরিষ্কার রাখুন ব্লোয়ার দিয়ে এবং সম্ভব হলে একাধিক কুলিং ফ্যান লাগান ।

টরেন্ট কি? কিভাবে ডাউনলোড করবেন।

টরেন্ট কি?

টরেন্ট মূলত ব্যবহার করা হয় ডাউনলোড করার কাজে। গতানুগতিক ডাউনলোড থেকে টরেন্ট একটু অন্যভাবে কাজ করে। কিন্তু টরেন্ট জনপ্রিয় এর কারন হল।

১. অন্য সাইট থেকে ডাউনলোডের জন্য পেজের পর পেজ ঘুরতে হয়, শেষে বলে টাকা লাগবে। টরেন্ট এ এটা হয় না।

২. রিজোম সাপোর্ট।

৩. keygen সহ গেম বা সফটয়ার।

৪. ভালো প্রিন্টের মুভি।

৫. ডাউনলোড দিয়ে বসে থাকতে হয় না। যখন পিসি নেটের সাথে কানেক্টেড থাকে তখন এটি ফাইল ডাউনলোড করতে থাকে।

৬. নেই বলে কিছু নেই। Including 18+



কিভাবে নামাবেন:

১. এখান থেকে Utorrent software টি নামিয়ে নিন। মনে রাখবেন এটি ছাড়া ডাউনলোড করতে পারবেন না।

২. সফটয়ার টি install করুন।

৩. এবার যেকোন টরেন্ট সাইট এ যান। টরেন্ট সাইট সুম্পর্কে আগে একট পোষ্ট দিয়েছি ওটা দেখেনঃ জনপ্রিয় টরেন্ট সাইট ও রিভিউ

৪. যেকোন ফাইল সিলেক্ট করেন।

৫. Download this torrent বা Download অপসন পাবেন। সেখানে কিল্ক করেন।

৬. utorrent এর মাধমে ফাইল টি খুলে ডাউনলোড দিন।

৭. ডাউনলোড শেষ হলে উপভোগ করুন।



সতর্কতাঃ

বলা হয়ে থাকে টরেন্টে পাওয়া কিছু ফাইলে ভাইরাস থাকে। তাই ডাউনলোড করার ক্ষেত্রে সতর্ক থাকা উচিত। পিসিতে ভালো কোনো এন্টিভাইরাস ইন্সটল করা থাকলে আর ভয়ের কিছু নেই।

oDesk Microsoft Excel Test answers

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

2) How does the AutoComplete feature in Excel help you save time?

Ans: It automatically completes abbreviated words

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

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

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

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

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

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

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

10) 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

11) Which of the following functions would return a value of 8?

Ans: b and c

12) 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

13) 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

14) 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

15) 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

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

17) 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

18) 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


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

Ans: MAX(B1:B3)

20) 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

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

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

Ans: TRUE

23) What does the NOW() function returns?

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

24) Which toolbar is shown in the figure?

Ans: Forms toolbar

25) When you clear the contents from a cell, the formatting of the cell is also lost.

Ans: FALSE

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