Game Camera Reviews

by ratonpramanik

Generally there region model presently fresh tools it is possible to utilize pertaining to greater searching expertise. it is possible to rummage about pertaining to the most effective game video cameras if you would like to reinforce ones hands per hour. this could help you get started track the wildlife within the woodlands. These kind of tools can give precious facts with regards to the wildlife on your area, in addition to the degree in the herd, the medical and grow older, and where ever these people at times spin. That enables the searcher determine and pick that “big buck” they need to be able to call for straight down. That also provides these people more time to prepare the next reach. are rarely getting inside woodlands while not “an eye”. Work with wireless game camera and benefit in the sport.

Several types of wireless game camera it is possible to utilize:

1. Uway NightXplorer NX80HD IR Photographic camera

That camera options a few. 0 Megapixels CMOS unit. It’ll make HIGH DEFINITION quality photos. Many searcher such as this as a result of it really is helpful each almost all the time. it is possible to alter its shape pace into take off total. they are also useful and may catch busy items. This sturdy contact could keep the typical in the images by 1-1. 3 milliseconds. Particular options of this camera incorporate thirty substantial production infrared LEDs, and it is possible to trigger the night-shot possibilities. you’ll also evaluation the video clip victimization the plug and engage in outside display. you’ll convert most of these photos into dark-colored flask therefore it is possible to have a look at these people just. Taking nevertheless photos is likewise no hassle; it options image burst selection and might take 1-9 photographs for each lead to.

only two. discoverer Black color Thumb light-emitting diode Trophy Cam w/color viewers

Bushnell will be 1 among the most effective route video cameras. That options some sort of 1-year battery lifestyle and 1-second lead to pace. It gives people the large impression regarding game movements featuring a Area Search within time-lapse technological innovation. For an obviously better looking at expertise, you’ll record audio tracks victimization the video clip manner. That also features a 32 GB Sd card therefore it is possible to record added photos and movies. That camera also includes a constitutional viewers, that options cruising possibilities. Generally there region model presently fresh products along with low-glow dark-colored light-emitting diode nightvision display. These people also much better the video clip image resolution nearly 1080p HIGH DEFINITION.

3. HCO Scoutguard SG550 materials

This HCO Scoutguard materials will be 1 among the most effective game video cameras. That options 5/3 megapixels CMOS unit and may make primary quality photographs. it is appliance light-emitting diode IR-Cut-Remove possibilities, that enables you to evaluation the healthiness of the industry. it is 1 between the primary cost-effective tools along with low strength usage, quite sturdy, and easy along with AA battery packs. These kind of battery packs may last pertaining to 70 nights. That is included with lockable and growing straps along with special nails and screws.

This is the perfect camera pertaining to searching as well as canine paying attention. you’ll also make use of this as a protection camera pertaining to homes as well as office buildings.

Some other products out there currently incorporate LTL fruit 5210A 940, Moultrie M-100, and Uway Nightrakker. it is possible to also look into some camera equipment pertaining to greater searching expertise.

These kind of region model just a few of the most effective game video cameras it is possible to utilize to reinforce ones hands per hour. investigation on-line as well as talk to a professional hunter pertaining to added ideas and recommendations.

13Jul2013

oDesk Internet Marketing Test Answer 2013

by ratonpramanik

oDesk Internet Marketing Test Answer 2013

Q1. What is A/B testing?

a. Testing two products to see which one sells more.

b. Using two version of an ad, measuring results to see which one is more effective.

c. Testing 2 products to see which one sells more.

d. Using 2 version of an ad to see which one has less bounce rate.

Q2. Why is it important to set daily maximum budgets for pay per click ad campaigns?

a. It helps with ad placements.

b. It is required.

c. It helps drive affiliate sale.

d. Costs of clicked links can add up quickly if not limited.

Q3. What is meant by “White hat”?

a. When marketers show up for work wearing white hats.

b. Dishonest techniques for gaining higher rankings.

c. Ethical and honest methods of increasing page rankings.

d. Software used to increase rankings.

Q4. How should a company allocate its marketing budget among the various methods of internet marketing?

a. Depends on the company and what is most effective for its business

b. Spread evenly among the methods chosen

c. Haphazardly

d. Spent most on email marketing

Q5. What is the purpose of sending a monthly newsletter?

a. It creates work for employees at the company

b. It builds branding, creates awareness and a connection with potential clients

c. It gives people a chance to opt out of ever talking to your company

d. Required by law.

Q6. Why are purchased email lists typically ineffective?

a. They are too expensive

b. They distribute an email to far more people than the company has its contacts

c. They make up fake emails to sell

d. They are not targeted at customers specific to your company and have high bounce rate.

Q7. What is an auto-responder?

a. A person who replies to all emails for the company

b. An automatic email message sent to someone who takes an action such as submitting a form on a company.

c. A method of direction communication with clients.

d. An email relay system.

Q8. What is meant by “White hat”?

a. When marketers show up for work wearing white hats.

b. Dishonest techniques for gaining higher rankings.

c. Ethical and honest methods of increasing page rankings.

d. Software used to increase rankings

Q9. How is the “open rate” important?

a. It tells the company how many people clicked on the links in the email.

b. It lets the company know how many people brought a product.

c. It is the number of people who received the email.

d. It is the number of people who actually opened the email sends to them, giving the company insight how effective email marketing campaign was.

Q10.What is meant by “viral marketing”?

a. Creating ads that users pay to watch

b. Creating ad campaigns which are expensive and well produced

c. Creating ad campaigns with a very narrow focus

d. Creating ad campaigns which are inexpensive, gain massive popularity and become widely distributed

Q11.What is affiliate marketing?

a. Same as guerilla marketing

b. Selling ad space on your site

c. When a 3rd party helps market your business, and in turn you pay them a commission based on sales as a result of their efforts

d. Pay per click marketing

Q12.Why would a company hire internet marketing specialists if marketing is relatively easy to do online?

a. It reduces taxable profits

b. To get a second opinion

c. Creates goodwill

d. Hired experts can drive the best results of campaigns and help guide the company in its marketing

Q12.What is meant by “web 2.0”?

a. The resurgence of internet companies with more interactive focus, such as blogging and social networking

b. Any website which has survived the dot.com bust

c. Sites made using new technology

d. Internet companies who focus on retail sales

Q13.What is the purpose of a traditional press release?

a. It acts as a direct marketing sales tool

b. It can be mailed out to potential clients

c. It announces company information to a widely dispersed group of people

d. It target markets to internet users

Q14.What is meant by “viral marketing”?

a. Creating ads that users pay to watch

b. Creating ad campaigns which are expensive and well produced

c. Creating ad campaigns with a very narrow focus

d. Creating ad campaigns which are inexpensive, gain massive popularity and become widely distributed

Q15.Why would a company hire internet marketing specialists if marketing is relatively easy to do online?

a. It reduces taxable profits

b. To get a second opinion

c. Creates goodwill

d. Hired experts can drive the best results of campaigns and help guide the company in its marketing

Q16.What is a secondary reason to actively maintain a company blog, besides giving potential customers something to read?

a. It keeps the marketing staff busy in down times

b. It impresses clients

c. A well maintained blog will help increase page rank with search engines

d. It makes the company seem larger than it is

Q17.How is the pricing model of a click determined?

a. Standardized rate for the ad

b. Google sets the price worldwide

c. Ads always cost more in later months

d. The more popular a search term, the more a customer will have to pay to use that term in his/her target keywords list

Q18.How can a company profit from a podcast directly?

a. Pay another company to host it

b. Charge for premium content

c. Set up an affiliate link

d. All podcasts are free, they can not be directly profitable

Q19.What is one advantage to using a purchased email list?

a. The firm selling them often makes up fake email addresss

b. Large quantity of email addresses and markets otherwise not reached

c. The bounce rate is very low

d. It is targeted at your potential customers

Q20.How important is content on a site when optimizing it?

a. Not important at all, does not factor in

b. Mildly important to keep customers happy

c. It is the only thing which creates a higher ranking in search engines

d. Very important, new content especially

Q21.Why would a company possibly want to spend more on PPC early on?

a. It costs less early on

b. To drive traffic to their site and increase awareness

c. To let the competition know they are serious

d. To sell more products

Q21.Why is reciprocal linking becoming an important way to reach potential clients?

a. Visitors to other sites of a similar nature to yours are likely to click on links to bring them to your site

b. It creates an income stream

c. It is the easiest way to create traffic

d. It builds goodwill

Q22. What is a trackback?

a. Same as a trademark

b. A method of notification that somebody links to document/html

c. When someone goes to your site because of your podcast

d. A count of how many downloads your podcast has

Q23.How is click-through rate measured in an email campaign?

a. The number of emails which did not bounce back

b. The number of people who click on a link in the email bringing the potential customer to your site

c. The number of people who purchased a product or service from the email

d. The number of people who replied to the email

Q24.Who regulates affiliate marketing?

a. No one currently

b. SEC

c. IRS

d. Internet Affiliate Board

Question: 01

Who was one of the original widely known affiliate marketers?

a.     Ebay
b.     AT&T
c.     WorldCom
d.     Amazon

Question: 02
How much would a company pay for the given example: Ad displays 20 times, 2 users click the ad, cost per click is 5 cents.

a.     90 cents
b.     10 cents
c.     20 cents
d.     1 cent

Question: 03
What is an important step early on when forming a web marketing strategy?

a.     Designing catchy ads
b.     Allocating a large budget to the project
c.     Identifying your customer base
d.     Hiring a consulting firm

Question: 04
What should a company do once it achieves its search engine ranking goals?

a.     Stop promoting the site
b.     Constantly monitor and improve their site in order to maintain their ranking
c.     Revise the site once in awhile
d.     Sell advertising on their site

Question: 06
Why has web marketing become a popular form of marketing?

a.     It is much cheaper than other forms and often more effective
b.     Television advertising is being offered less
c.     It is easier than traditional marketing
d.     It has been heavily advertised

Question: 07
How should a company allocate its marketing budget among the various methods of internet marketing?

a.     Depends on the company and what is most effective for its business
b.     Spread evenly among the methods chosen
c.     Haphazardly
d.     Spend most on email marketing

Question: 08
How can chat rooms bolster site traffic?

a.     The competition can come to the chat and try to steal customers
b.     It gives the company a way to distance themselves from customers
c.     By having people talk positively about your company and by answering questions people may have in a non threatening, anonymous method
d.     It gives a way for customers to log complaints

Question: 09
What is the formula for calculating cost per customer acquisition?

a.     Marketing spent on television divided by the number of new customers
b.     Sales divided by customers
c.     Total marketing budget divided by all customers ever
d.     Total marketing budget for a specific period divided by the number of new customers for that same period

Question: 10
How are keywords utilized by search engines?

a.     They are all that the search engine uses to rank pages
b.     The keywords are a brief description of what topics your site relates to
c.     They help the search engine decide how good your sites content is
d.     The keywords guarantee positioning

Question: 11
Why is it important to set daily maximum budgets for pay per clicks ad campaigns?

a.     It helps with ad placement
b.     It is required
c.     It helps drive affiliate sales
d.     Costs of clicked links can add up quickly if not limited

Question: 12
What is “cost per customer acquisition”?

a.     The amount a company pays a customer to try their product
b.     The average cost of marketing spent per new customer
c.     The cost of marketing staff
d.     The cost to beat competitors

Question: 13
Why is it important to fine tune the timing of the ad and keywords used?

a.     It costs less in later hours
b.     To be sure to spend more money on marketing
c.     Required by law
d.     To carefully target the customer base desired, not wasting impressions and clicks

Question: 14
What is a site index?

a.     A page which has a linkable outline of all of the pages on a website
b.     A site with only 1 page
c.     A site with special deals for purchasers
d.     A special ranking with search engines

Question: 15
What is one unfavorable trait sometimes seen in affiliate marketing?

a.     The cost is low
b.     It brings additional traffic to a site
c.     Affiliates will use unethical techniques to drive customers in hopes of earning a commission
d.     It is only paid for based on successful selling

Question: 16
What is brand strategy?

a.     Creating the image you want your company perceived as and marketing in a way that portrays that image to customers
b.     Strategy for reaching customers worldwide
c.     Creating a package that catches peoples eyes
d.     Creating an image that contradicts competitor’s assertations

Question: 17
What is a “landing page”?

a.     The page a potential customer sees when they click on your paid ad
b.     The main company website
c.     A page where the customer can buy the product
d.     Where the pay per click ads are created

Question: 18
Which of the following is valuable in increasing a page rank?

a.     Paying for placement
b.     Static content
c.     Quantity of links from other highly ranked pages to your site
d.     No contact information

Question: 19
What type of income statement items are marketing expenses?

a.     Variable Cost
b.     Fixed Cost
c.     Revenue
d.     Cost of Good Sold

Question: 20
What is search engine optimization?

a.     Paying for placement on a search engine results page
b.     Building a site which has the qualities that search engines look for, which will ultimately get the site a high rank in the listings
c.     Optimization of a site so it gets more affiliate revenue
d.     Selling memberships to the site

Question: 21
What are meta tags?

a.     The content of the site
b.     Embedded information about your website such as keywords
c.     Links to other sites
d.     Images on the site

Question: 22
Why have social networking sites become a popular method of internet marketing?

a.     They are free and easy to use
b.     They guarantee more traffic to your site
c.     Ease of use, large number of users, easy to target specific demographics
d.     They are a passing trend

Question: 23
Which of the following are podcasts least likely to target?

a.     Sales
b.     Branding
c.     Customer loyalty
d.     Content delivery

Question: 24
What is “bounce rate” in terms of email marketing?

a.     The percentage of emails sent to a list which are returned as undeliverable
b.     The percentage of repeat clients
c.     The percentage of people who receive an email and buy the product
d.     The percentage of people who click the links in an email

Question: 25
How can posting on other message boards help drive traffic to a company site?

a.     You can steal away clients from other companies directly
b.     You can tell lies about competitors
c.     You can trump up claims of what your company does
d.     By becoming an expert on a subject and giving people information which demonstrates your company’s knowledge and expertise

Question: 26
What are the four P’s of marketing?

a.     Placement, Production, Procurement, Procedures
b.     Product, Price, Placement, Promotion
c.     Position, Price, Production, Premature
d.     Product, Promotion, Procedures, Procurement

Question: 27
What is “cost per action”?

a.     Same as pay per click
b.     A payment agreement where a specific action creates a payable event for the affiliate, such as a click, a purchase, a number of page views
c.     A payment agreement where costs change depending on volume
d.     The product cost

Question: 28
How are Pay Per Click ad campaigns billed?

a.     Everytime an ad is displayed it costs the company money
b.     Set monthly fee regardless of impressions or clicks
c.     Discounted based on length of commitment
d.     The customer pays each time their ad is clicked on, usually billed monthly

Question: 29
How do firms typically budget once positive results are seen from their internet marketing campaign?

a.     Decrease the overall budget
b.     Spend more on the methods which are not producing results
c.     Increase the budget and focus on those activities which are working
d.     Stop marketing

Question: 30
What is the primary goal of web marketing?

a.     To give the target market an ad like they would see on TV
b.     To sell customers on the spot
c.     To earn affiliate income
d.     To drive potential customers to the company website

Question: 32
What is the best way to make internet marketing effective?

a.     Focus on one specific technique such as direct email
b.     Use a myriad of methods online
c.     Spend a lot of money on it
d.     Use email marketing first

Question: 33
How can a podcast be used to drive customers to a website?

a.     By only hosting the podcast on the website
b.     By giving information on the podcast which gives the listener the desire to learn more, and directing them to the website for that information
c.     By making the podcast a premium one which costs money
d.     By telling the listeners that they need your product

Question: 34
Why are purchased email lists typically ineffective?

a.     They are too expensive
b.     They distribute an email to far more people than the company has in its contacts
c.     They make up fake emails to sell
d.     They are not targeted at customers specific to your company and have high bounce rates

Question: 35
What is meant by “guerilla marketing”?

a.     Using resources such as time, energy and imagination rather than money to market
b.     Using advertising spots which utilize gorillas to capture the audience
c.     Having a large scale marketing budget
d.     Using television ads instead of web ads

Question: 36
What is a “call to action”?

a.     Hoping the customer buys your product
b.     Recruiting new employees
c.     Creating a new ad campaign
d.     Using verbs to encourage people to take an action

Question: 37
Why is affiliate marketing a favorable form of marketing?

a.     It is inexpensive
b.     Nothing is paid unless there is a sale resulting from the affiliate’s efforts
c.     It guarantees increased sales
d.     It is complex so not many people utilize it

Question: 38
What is the purpose of having a special landing page for a PPC ad?

a.     It costs less if done that way
b.     It gives the potential to have mixed messages on the site
c.     Statistics can be gathered on the page, as well as special offers can be shown to the ad clicker
d.     Customers expect it

Question: 39
How can supplemental materials be delivered to the podcast listener?

a.     Embedded into the audio file
b.     Files can be made available for download along with the link to the podcast
c.     The listener has to go to a special site only during the podcast
d.     The listener must pay for any additional materials

Question: 40
What is a “value proposition”?

a.     The pricing of the product
b.     The same as a business plan
c.     A statement as to how the company will make more money
d.     A statement as to how the company adds value for customers

**This Website is For Sell for very low rate **

This website is for sell.
Interested person/company (Only real buyer plz) please contact ‘mehedi.auc@gmail.com’
Thanks

Why would a firm employ guerrilla web marketing?

Ans: it gives the firm more control over its marketing budget

Why is affiliate marketing a fovorable form of marketing

Ans: it gurantees increased sales

What is meant by “niche marketing”?

Ans: Targeting a very specific demographic

How can a poducast be used to brive customers to a website

Ans: by telling the listeners that they need your product

What is cost per coustomer acquisition

Ans: the amount a company pays a customer to try their product

How can supplemental materials be delivered to the poducast listener
Ans: the istener must pay for any additional materials

How important is content on a site when optimizing it

Ans: it is the only thing which creates a higher ranking in search engines

Which of the following would not be effective in headline writing

Ans: using small words which take up space and do not add value

What should a company do once it achieves its search engine ranking goals

Ans: sell advertising on their site

Why would a company possibly want so spend more on PPC early on

Ans: to drive traffic to their site and increase awarensess

What is meant by “white hat”

Ans: When marketers show up for work wearing white hats

Why are purchased email lists typically ineffective

Ans: they make up fake email to sell

Why has web marketing become a popular form of marketing

Ans:it has been heavily advertised

What is one unfavourable trait sometimes seen in affiliate marketing

Ans: it brings additional traffic to a site

If marketing is relatively easy to do online

Ans: Hired experts can drive the best results of campaigns and help guide the company in its marketing

What is a secondary reason to actively maintain a company blog. Besides giving potential customers something to read

Ans: it impresses clients

What is the purpose of a traditional press release

Ans: it target markets to internet users

What is the purpose of sending a monthly newsletter

Ans: it gives people a chance to opt out of ever talking to your company again

What is meant by guerrilla marketing

Ans: Using resources such as time, energy and imagination rather than money to market

What is an auto-responder

Ans: a method of direction communication with clients

Why is it important to fine tune the timing of the ad and keywords used

Ans: to carefully target the customer base desired, not wasting impressions and clicks

What is the “active voice” style of writing ads?

Ans: Using “you” and not “I” or “we” – directing wording towards the customer

What is double opt in process?

Ans: someone must ask to be on your email list. And then verity by clicking a link they want to be on it

How do listeners decide what is a worthwhile podcast to continually listen to

Ans: having several hosts and a myriad of topics

Why is the subject line of any email campaign important?

Ans: it is all the receiver sees besides the email address until they open the email

How is “open rat” important

Ans: it lets the company know how many people bought a product

Why are affiliates not the same as having a sales force?

Ans:The affiliate only drives traffic, they do not necessarily convert them to sales

How is the pricing model of a click determined

Ans: google sets the price worldwide

What is the formula for calculating cost per customer acquisition

Ans: total marketing budget for a specific period divided by the number of new customers for that same period

How much would a company pay for the given example: ad displays 20 times. 2 users click the ad. Cost per click is 5 cents

Ans: 10 cents

What is “cost per action ”

Ans: a payment agreement where a specific action creates a payable event for the affiliate. Such as a click a purchase. Number of page views

What is an “impression”?

Ans: When your ad is displayed on a page online, not necessarily clicked on

Which of the following is valuable in increasing a page rank

Ans: quantity of links from other highly ranked pages to your site

What is meant by”web 2.0”

Ans: internet companies who focus on retail sales

What is affiliate marketing

Ans: when a 3rd party helps market your business. And in turn your pay them a commission based on sales as aresult of their efforts

Which of the following are podcasts least likely to target

Ans: sales

Question:

Why would a firm employ guerilla web marketing?

a. It is guaranteed to work

b. It allows greater flexibility

c. It gives the firm more control over its marketing budget.

d. It is unconventional and can often leave a lasting impression on potential customers

Answer: It gives the firm more control over its marketing budget.

Question:

Why is affiliate marketing a favorable from of marketing?

a. It is inexpensive.

b. Nothing is paid unless there is a sale resulting from the affiliate’s efforts.

c. It guarantees increased sales

d. It is complex so not many people utilize it

Answer: It guarantees increased sales

Question:

What is meant by “niche marketing”?

a. Targeting a broad based group of people

b. Targeting a very specific demographic

c. Advertising on the television

d. Advertising only online

Answer: Targeting a broad based group of people

Question:

How can a podcast be used to drive customers to a website?

a. By only hosting the podcast on the website

b. By giving information on the podcast which gives the listener the desire to learn more, and directing them to the website for information

c. By making the podcast a premium one which costs money

d. By telling the listeners that they need your product

Answer: By telling the listeners that they need your product.

Question:

What is “cost per customer acquisition”?

a. The amount a company pays a customer to try their product

b. The average cost of marketing spent per new customer

c. The cost of marketing staff

d. The cost to beat competitors

Answer: The amount a company pays a customer to try their product

Question:

How can supplemental materials be delivered to the podcast listener?

a. Embedded into the audio file

b. Files can be made available for download along with the link to the podcast

c. The listener has to go to a special site only during the podcast

d. The listener must pay for any additional materials

Answer: The listener has to go to a special site only during the podcast

Question:

What is a “value proposition”?

a. The pricing of the product

b. The same as a business plan

c. A statement as to how the company will make more money

d. A statement as to how the company adds value for customers

Answer: The pricing of the product

Question:

How important is content on a site when optimizing it?

a. Not important at all does not factor in

b. Mildly important to keep customers happy

c. It is the only thing which creates a higher ranking in search engines

d. Very important new content especially

Answer: It is the only thing which creates a higher ranking in search engines

Question:

Which of the following would not be effective in headline writing?

a. Using words that draw attention

b. Using words that people may search for

c. Using small words which take up space and do not add value

d. Using words such as “new, exciting, special offer”

Answer: Using small words which take up space and do not add value

Question:

What should a company do once it achieves its search engine ranking goals?

a. Stop promoting site

b. Constantly monitor and improve their site in order to maintain their ranking

c. Revise the site once in awhile

d. Sell advertising on their site

Answer: Sell advertising on their site

Question:

Why would a company possibly want to spend more on PPC early on?

a. It costs less early on

b. To drive traffic to their site and increase awareness

c. To let the competition know they are serious

d. To sell more products

Answer: To drive traffic to their site and increase awareness

Question:

What is meant by “white hat”?

a. When markets show up for work wearing white hats

b. Dishonest techniques for gaining higher ranking

c. Ethical and honest methods of increasing page ranking

d. Soft ware use to increase ranking

Answer: When markets show up for work wearing white hats

Question:

Why are purchased email lists typically ineffective?

a. They are too expensive

b. They distribute an email to far more people than the company has in its contacts

c. They make up fake emails to sell

d. They are not targeted at customers specific to your company and have high bounce rates

Answer: They make up fake emails to sell

Question:

Why has web marketing become a popular form of marketing?

a. It is much cheaper than other forms and often more effective

b. Television advertising is being offered less

c. It is easier than traditional marketing

d. It has been heavily advertised

Answer: It has been heavily advertised

Question:

What is one unfavorable trait sometimes seen in affiliate marketing?

a. The cost is low

b. It brings additional traffic to a site

c. Affiliate will use unethical techniques to drive customers in hopes of earning a commission

d. It is only paid for based on successful selling

Answer: It brings additional traffic to a site

Question:

Why would a company hire internet marketing specialists if marketing is relatively easy to do online?

a. It reduces taxable profits

b. To get a second opinion

c. Creates goodwill

d. Hired experts can drive the best results of campaigns and help guide the company in its marketing

Answer: Hired expert can drive the best results of campaigns and help guide the company in its marketing

Question:

Which 3 industries are the largest users of affiliate marketing?

a. Prescription drugs, electronics, child products

b. Gambling, adult, retail

c. Retail outlets, bakeries, beverage

d. Computer equipment, auto manufacturers , construction

Answer: Computer equipment, auto manufacturers, construction

Question:

What is A/B testing?

a. Testing 2 products to see which is safer

b. Using 2 versions of an ad measuring results to see which one is more effective

c. Testing 2 products to see which one sells more

d. Using 2 versions of an ad to see which one has less bounce rate

Answer: Using 2 versions of an ad measuring results to see which one is more effective

Question:

What are the four P’s of marketing?

a. Placement, production, procurement, procedures

b. Product, price, place, promotion

c. Position, price, production, premature

d. Product, promotion, procedures, procurement

Answer: Product, promotion, procedures, procurement

Question:

What is a secondary reason to actively maintain a company blog, besides giving potential customers something to read?

a. It keeps the marketing staff busy in down times

b. It impresses clients

c. A well maintained blog will help increase page rank with search engines

d. It makes the company seem larger than it is

Answer: It impresses clients

Question:

What is the purpose of a traditional press release?

a. Is acts as a direct marketing sales tool

b. It can be mailed out to potential clients

c. It announces company information to a widely dispersed group of people

d. It target markets to internet users

Answer: It target markets to internet users

Question:

What is the purpose of sending a monthly newsletter?

a. It creates work for employees at the company

b. It builds branding creates awareness and connection with potential clients

c. It gives people a chance to opt out of ever talking to your company again

d. Required by law

Answer: It gives people a chance to opt out of ever talking to your company agin

Question:

What is meant by “guerilla marketing”?

a. Using resources such as time, energy and imagination rather than money to market

b. Using advertising spots which utilize gorillas to capture the audience

c. Having a large scale marketing budget

d. Using television ads instead of web ads

Answer: Using resources such as time, energy and imagination rather than money to market

Question:

What is an auto-responder?

a. A person who replaces to all emails for the company

b. An automatic email message sent to someone who takes an action such as submitting a form on a company website

c. A method of direction communication with clients

d. An email relay system

Answer: A method of direction communication with clients

Question:

Why is it important to fine tune the timing of the ad and keywords used?

a. It costs less in later hours

b. To be sure to spend more money on marketing

c. Required by law

d. To carefully target the customer base desired, not wasting impressions and clicks

Answer: To carefully target the customer base desired, not wasting impressions and clicks

Question:

What is the “active voice” style of writing ads?

a. Using “you” and not “I” or “we”- directing wording towards the customer

b. Writing in the first person

c. Writing in the third person

d. Speaking omnisciently

Answer: Writing in the third person

Question:

What is a double opt in process?

a. Someone must email the firm twice to get on a list

b. Someone must ask to be on your email list, and then verify by clicking a link they want to be on it

c. Someone must email the firm twice to get off an email list

d. Someone has to send an email confirming an online purchase

Answer: someone must ask to be on your email list, and then verify by clicking a link they want to be on it

Question:

How do listeners decide what is a worthwhile podcast to continually listen to?

a. High quality audio and high quality content

b. If it’s funny

c. Broad based podcasts with no general direction

d. Having several hosts and a myriad of topics

Answer: Having several hosts and a myriad of topics

Question:

Why is the subject line of any email campaign important?

a. It gives the person an opportunity to delete the email before reading it

b. It is all the receiver sees besides the email address until they open the email

c. It let the receiver know they are about to be sold something

Answer: It is all the receiver sees besides the email address until open the email

Question:

How is the “open rate” important?

a. It tells the company how many people clicked on the links in the email

b. It lets the company know how many people bought a product

c. It is the number of people who received the mail

d. It is the number of people who actually opened the email sent to them, giving the company insight in to how effective the email marketing campaign was

Answer: it lets the company know how many people bought a product

Question:

Why are affiliates not the same as having a sales force?

a. The affiliates are virtual

b. The affiliates can be based anywhere in the world

c. The affiliate only drives traffic, they do not necessarily convert them to sales

d. The affiliates have limited availability

Answer: The affiliates have limited availability

Question:

How is the pricing model of a click determined?

a. Standardized rate for the ad

b. Google sets the price worldwide

c. Ads always cost more in later months

d. The more popular a search term the more a customer will have to pay to use that term in his/her target keywords list

Answer: Google sets the price worldwide

Question:

What is the formula for calculating cost per customer acquisition?

a. Marketing spent on television divided by the number of new customers

b. Sales divided by customers

c. Total marketing budget divided by all customers ever

d. Total marketing budget for a specific period divided by the number of new customers for that same period

Answer: Total marketing budget for a specific period divided by the number of new customers for that same period

Question:

How much a company pay for the given example: Ad displays 20 times, 2 users click the ad, cost per click is 5 cents.

a. 90 cents

b. 10 cents

c. 20 cents

d. 1 cents

Answer: 10 cents

Question:

What is “cost per action”?

a. Same as pay per click

b. A payment agreement where a specific action creates a payable event for the affiliate such as a click a purchase a number of page views

c. A payment agreement where costs change depending on volume

d. The product cost

Answer: Same as pay per click

Question:

What is an “impression”?

a. When a person buys a product from a site

b. When your ad is displayed on a page online, not necessarily clicked on

c. When an ad is clicked on when an ad on

d. When an ad makes an impression on a client

Answer: When your ad is displayed on a page online, not necessarily clicked on

Question:

Which of the following is valuable in increasing a page rank?

a. Paying for placement

b. Static content

c. Quantity of links from other highly ranked pages to your site

d. No contact information

Answer: Quantity of links from other highly ranked pages to your site

Question:

What is meant by “web 2.0”?

a. The resurgence of internet companies with more interactive focus, such as blogging and social networking

b. Any website which has survived the dot com bust

c. Sites made using new technology

d. Internet companies who focus on retail sales

Answer: Internet companies who focus on retail sales

Question:

What is affiliate marketing?

a. Same as guerilla marketing

b. Selling ad space on your site

c. When a 3rd party helps market your business, and in turn your pay them a commission based on sales as a result of their efforts

d. Pay per click marketing

Answer: When a 3rd party helps market your business, and in turn your pay them a commission based on sales as a result of their efforts

Question:

Which of the following are podcasts least likely to target?

a. Sales

b. Branding

c. Customer loyalty

d. Customer delivery

Answer: Sales

1. Why would a company possibly want so spend more on PPC early on

Ans: to drive traffic to their site and increase awarensess

2. Why is affiliate marketing a fovorable form of marketing

Ans: it gurantees increased sales

3. What is meant by “niche marketing”

Ans: targeting a broad based group of people

4. How can a poducast be used to brive customers to a website

Ans: by telling the listeners that they need your product

5. What is cost per coustomer acquisition

Ans: the amount a company pays a customer to try their product

6. How can supplemental materials be delivered to the poducast listener

Ans: the istener must pay for any additional materials

7. What is a value proposition

Ans: the pricing of the product

8. How important is content on a site when optimizing it

Ans: it is the only thing which creates a higher ranking in search engines

9. Which of the following would not be effective in headline writing

Ans: using small words which take up space and do not add value

10. What should a company do once it achieves its search engine ranking goals

Ans: sell advertising on their site

11. Way would a firm employ guerrilla web marketing

Ans: it gives the firm more control over its marketing budet

12. What is meant by “whit hat”

Ans: When marketers show up for work wearing white hats

13. Why are purchased email lists typically ineffective

Ans: they make up fake email to sell

14. Why has web marketing become a popular form of marketing

Ans:it has been heavily advertised

15. What is one unfavourable trait sometimes seen in affiliate marketing

Ans: it brings additional traffic to a site

16. If marketing is relatively easy to do online

Ans: Hired experts can drive the best results of campaigns and help guide the company in its marketing

17. What is a secondary reason to actively maintain a company blog. Besides giving potential customers something to read

Ans: it impresses clients

18. What is the purpose of a traditional press release

Ans: it target markets to internet users

19. What is the purpose of sending a monthly newsletter

Ans: it gives people a chance to opt out of ever talking to your company again

20. What is meant by guerrilla marketing

Ans: Using resources such as time, energy and imagination rather than money to market

21. What is an auto-responder

Ans: a method of direction communication with clients

22. Why si it important to fine tune the timing of the ad and keywords used

Ans: to carefully target the customer base desired, not wasting impressions and clicks

23. What is the “active voice” style of writing ads

Ans: writing in the third person

24. What is double opt in process

Ans: someone must ask to be on your email list. And then verity by clicking a link they want to be on it

25. How do listeners decide what is a worthwhile podcast to continually listen to

Ans: having several hosts and a myriad of topics

26. Why is the subject line of any email compaingn important

Ans: it is all the receiver sees besides the email address until they open the email

27. How is “open rat” important

Ans: it lets the company know how many people bought a product

28. Why are affiliates not the same as having a sales force

Ans: The affiliates have limited availability

29. How is the pricing model of a click determined

Ans: google sets the price worldwide

30. What is the formula for calculating cost per customer acquisition

Ans: total marketing budget for aspecific period divided by the number of new customers for that same period

31. How much woulad a company pay for the given example: ad displays 20 times. 2 users click the ad. Cost per click is 5 cents

Ans: 10 cents

32. What is “cost per action ”

Ans: a payment agreement where a specific action creates a payable event for the affiliate. Such as a click a purchase. Number of page views

33. What is an “impression”

Ans: when an ad is cliced on

34. Which of the following is valuable in increasing a page rank

Ans: quantity of links from other highly ranked pages to your site

35. What is meant by”web 2.0”

Ans: internet companies who focus on retail sales

36. What is affiliate marketing

Ans: when a 3rd party helps market your business. And in turn your pay them a commission based on sales as aresult of their efforts

37. Which of the following are podcasts least likely to target

Ans: sales

odesk internet marketing Question: Way would a firm employ guerrilla web marketing ?
odesk internet marketing Question Ans: it gives the firm more control over its marketing budget.
odesk internet marketing Question: Why is affiliate marketing a fovorable form of marketing?
odesk internet marketing Question Ans: it gurantees increased sales
odesk internet marketing Question: What is meant by “niche marketing”?
odesk internet marketing Question Ans: targeting a broad based group of people
odesk internet marketing Question: How can a poducast be used to brive customers to a website?
odesk internet marketing Question Ans: by telling the listeners that they need your product
odesk internet marketing Question: What is cost per customer acquisition?
odesk internet marketing Question Ans: the amount a company pays a customer to try their product
odesk internet marketing Question: How can supplemental materials be delivered to the poducast listener?
odesk internet marketing Question Ans: the istener must pay for any additional materials
odesk internet marketing Question: What is a value proposition?
odesk internet marketing Question Ans: the pricing of the product
odesk internet marketing Question: How important is content on a site when optimizing it?
odesk internet marketing Question Ans: it is the only thing which creates a higher ranking in search engines
odesk internet marketing Question: Which of the following would not be effective in headline writing?
odesk internet marketing Question Ans: using small words which take up space and do not add value
odesk internet marketing Question: What should a company do once it achieves its search engine ranking goals?
odesk internet marketing Question Ans: sell advertising on their site
odesk internet marketing Question: Why would a company possibly want so spend more on PPC early on?
odesk internet marketing Question Ans: to drive traffic to their site and increase awareness
odesk internet marketing Question: What is meant by “whit hat”?
odesk internet marketing Question Ans: When marketers show up for work wearing white hats
odesk internet marketing Question: Why are purchased email lists typically ineffective?
odesk internet marketing Question Ans: they make up fake email to sell
odesk internet marketing Question: Why has web marketing become a popular form of marketing?
odesk internet marketing Question Ans:it has been heavily advertised
odesk internet marketing Question: What is one unfavourable trait sometimes seen in affiliate marketing?
odesk internet marketing Question Ans: it brings additional traffic to a site
odesk internet marketing Question: If marketing is relatively easy to do online?
odesk internet marketing Question Ans: Hired experts can drive the best results of campaigns and help guide the company in its marketing
odesk internet marketing Question: What is a secondary reason to actively maintain a company blog. Besides giving potential customers something to read?
odesk internet marketing Question Ans: it impresses clients
odesk internet marketing Question: What is the purpose of a traditional press release?
odesk internet marketing Question Ans: it target markets to internet users
odesk internet marketing Question: What is the purpose of sending a monthly newsletter?
odesk internet marketing Question Ans: it gives people a chance to opt out of ever talking to your company again
odesk internet marketing Question: What is meant by guerrilla marketing
odesk internet marketing Question Ans: Using resources such as time, energy and imagination rather than money to market
odesk internet marketing Question: What is an auto-responder?
odesk internet marketing Question Ans: a method of direction communication with clients
odesk internet marketing Question: Why si it important to fine tune the timing of the ad and keywords used?
odesk internet marketing Question Ans: to carefully target the customer base desired, not wasting impressions and clicks
odesk internet marketing Question: What is the “active voice” style of writing ads?
odesk internet marketing Question Ans: writing in the third person?
odesk internet marketing Question: What is double opt in process?
odesk internet marketing Question Ans: someone must ask to be on your email list. And then verity by clicking a link they want to be on it
odesk internet marketing Question: How do listeners decide what is a worthwhile podcast to continually listen to?
odesk internet marketing Question Ans: having several hosts and a myriad of topics
odesk internet marketing Question: Why is the subject line of any email comparing important?
odesk internet marketing Question Ans: it is all the receiver sees besides the email address until they open the email
odesk internet marketing Question: How is “open rat” important?
odesk internet marketing Question Ans: it lets the company know how many people bought a product
odesk internet marketing Question: Why are affiliates not the same as having a sales force?
odesk internet marketing Question Ans: The affiliates have limited availability
odesk internet marketing Question: How is the pricing model of a click determined ?
odesk internet marketing Question Ans: google sets the price worldwide
odesk internet marketing Question: What is the formula for calculating cost per customer acquisition?
odesk internet marketing Question Ans: total marketing budget for aspecific period divided by the number of new customers for that same period?
odesk internet marketing Question: How much woulad a company pays for the given odesk ?

internet marketing Question example: ad displays 20 times. 2 users click the ad. Cost per click is 5 cents
Ans: 10 cents
odesk internet marketing Question: What is “cost per action”?
odesk internet marketing Question Ans: a payment agreement where a specific action creates a payable event for the affiliate. Such as a click a purchase. Number of page views
odesk internet marketing Question: What is an “impression”?
odesk internet marketing Question Ans: when an ad is cliced on
odesk internet marketing Question: Which of the following is valuable in increasing a page rank?
odesk internet marketing Question Ans: quantity of links from other highly ranked pages to your site
odesk internet marketing Question: What is meant by”web 2.0”?
odesk internet marketing Question Ans: internet companies who focus on retail sales
odesk internet marketing Question: What is affiliate marketing ?
odesk internet marketing Question Ans: when a 3rd party helps market your business. And in turn your pay them a commission

odesk internet marketing Question: Based on sales as aresult of their efforts?
which of the following are podcasts least likely to target.
odesk internet marketing Question Ans: sales

Question:

Why would a firm employ guerilla web marketing?

a. It is guaranteed to work

b. It allows greater flexibility

c. It gives the firm more control over its marketing budget.

d. It is unconventional and can often leave a lasting impression on potential customers

Answer: It gives the firm more control over its marketing budget.

Question:

Why is affiliate marketing a favorable from of marketing?

a. It is inexpensive.

b. Nothing is paid unless there is a sale resulting from the affiliate’s efforts.

c. It guarantees increased sales

d. It is complex so not many people utilize it

Answer: It guarantees increased sales

Question:

What is meant by “niche marketing”?

a. Targeting a broad based group of people

b. Targeting a very specific demographic

c. Advertising on the television

d. Advertising only online

Answer: Targeting a broad based group of people

Question:

How can a podcast be used to drive customers to a website?

a. By only hosting the podcast on the website

b. By giving information on the podcast which gives the listener the desire to learn more, and directing them to the website for information

c. By making the podcast a premium one which costs money

d. By telling the listeners that they need your product

Answer: By telling the listeners that they need your product.

Question:

What is “cost per customer acquisition”?

a. The amount a company pays a customer to try their product

b. The average cost of marketing spent per new customer

c. The cost of marketing staff

d. The cost to beat competitors

Answer: The amount a company pays a customer to try their product

Question:

How can supplemental materials be delivered to the podcast listener?

a. Embedded into the audio file

b. Files can be made available for download along with the link to the podcast

c. The listener has to go to a special site only during the podcast

d. The listener must pay for any additional materials

Answer: The listener has to go to a special site only during the podcast

Question:

What is a “value proposition”?

a. The pricing of the product

b. The same as a business plan

c. A statement as to how the company will make more money

d. A statement as to how the company adds value for customers

Answer: The pricing of the product

Question:

How important is content on a site when optimizing it?

a. Not important at all does not factor in

b. Mildly important to keep customers happy

c. It is the only thing which creates a higher ranking in search engines

d. Very important new content especially

Answer: It is the only thing which creates a higher ranking in search engines

Question:

Which of the following would not be effective in headline writing?

a. Using words that draw attention

b. Using words that people may search for

c. Using small words which take up space and do not add value

d. Using words such as “new, exciting, special offer”

Answer: Using small words which take up space and do not add value

Question:

What should a company do once it achieves its search engine ranking goals?

a. Stop promoting site

b. Constantly monitor and improve their site in order to maintain their ranking

c. Revise the site once in awhile

d. Sell advertising on their site

Answer: Sell advertising on their site

Question:

Why would a company possibly want to spend more on PPC early on?

a. It costs less early on

b. To drive traffic to their site and increase awareness

c. To let the competition know they are serious

d. To sell more products

Answer: To drive traffic to their site and increase awareness

Question:

What is meant by “white hat”?

a. When markets show up for work wearing white hats

b. Dishonest techniques for gaining higher ranking

c. Ethical and honest methods of increasing page ranking

d. Soft ware use to increase ranking

Answer: When markets show up for work wearing white hats

Question:

Why are purchased email lists typically ineffective?

a. They are too expensive

b. They distribute an email to far more people than the company has in its contacts

c. They make up fake emails to sell

d. They are not targeted at customers specific to your company and have high bounce rates

Answer: They make up fake emails to sell

Question:

Why has web marketing become a popular form of marketing?

a. It is much cheaper than other forms and often more effective

b. Television advertising is being offered less

c. It is easier than traditional marketing

d. It has been heavily advertised

Answer: It has been heavily advertised

Question:

What is one unfavorable trait sometimes seen in affiliate marketing?

a. The cost is low

b. It brings additional traffic to a site

c. Affiliate will use unethical techniques to drive customers in hopes of earning a commission

d. It is only paid for based on successful selling

Answer: It brings additional traffic to a site

Question:

Why would a company hire internet marketing specialists if marketing is relatively easy to do online?

a. It reduces taxable profits

b. To get a second opinion

c. Creates goodwill

d. Hired experts can drive the best results of campaigns and help guide the company in its marketing

Answer: Hired expert can drive the best results of campaigns and help guide the company in its marketing

Question:

Which 3 industries are the largest users of affiliate marketing?

a. Prescription drugs, electronics, child products

b. Gambling, adult, retail

c. Retail outlets, bakeries, beverage

d. Computer equipment, auto manufacturers , construction

Answer: Computer equipment, auto manufacturers, construction

Question:

What is A/B testing?

a. Testing 2 products to see which is safer

b. Using 2 versions of an ad measuring results to see which one is more effective

c. Testing 2 products to see which one sells more

d. Using 2 versions of an ad to see which one has less bounce rate

Answer: Using 2 versions of an ad measuring results to see which one is more effective

Question:

What are the four P’s of marketing?

a. Placement, production, procurement, procedures

b. Product, price, place, promotion

c. Position, price, production, premature

d. Product, promotion, procedures, procurement

Answer: Product, promotion, procedures, procurement

Question:

What is a secondary reason to actively maintain a company blog, besides giving potential customers something to read?

a. It keeps the marketing staff busy in down times

b. It impresses clients

c. A well maintained blog will help increase page rank with search engines

d. It makes the company seem larger than it is

Answer: It impresses clients

Question:

What is the purpose of a traditional press release?

a. Is acts as a direct marketing sales tool

b. It can be mailed out to potential clients

c. It announces company information to a widely dispersed group of people

d. It target markets to internet users

Answer: It target markets to internet users

Question:

What is the purpose of sending a monthly newsletter?

a. It creates work for employees at the company

b. It builds branding creates awareness and connection with potential clients

c. It gives people a chance to opt out of ever talking to your company again

d. Required by law

Answer: It gives people a chance to opt out of ever talking to your company agin

Question:

What is meant by “guerilla marketing”?

a. Using resources such as time, energy and imagination rather than money to market

b. Using advertising spots which utilize gorillas to capture the audience

c. Having a large scale marketing budget

d. Using television ads instead of web ads

Answer: Using resources such as time, energy and imagination rather than money to market

Question:

What is an auto-responder?

a. A person who replaces to all emails for the company

b. An automatic email message sent to someone who takes an action such as submitting a form on a company website

c. A method of direction communication with clients

d. An email relay system

Answer: A method of direction communication with clients

Question:

Why is it important to fine tune the timing of the ad and keywords used?

a. It costs less in later hours

b. To be sure to spend more money on marketing

c. Required by law

d. To carefully target the customer base desired, not wasting impressions and clicks

Answer: To carefully target the customer base desired, not wasting impressions and clicks

Question:

What is the “active voice” style of writing ads?

a. Using “you” and not “I” or “we”- directing wording towards the customer

b. Writing in the first person

c. Writing in the third person

d. Speaking omnisciently

Answer: Writing in the third person

Question:

What is a double opt in process?

a. Someone must email the firm twice to get on a list

b. Someone must ask to be on your email list, and then verify by clicking a link they want to be on it

c. Someone must email the firm twice to get off an email list

d. Someone has to send an email confirming an online purchase

Answer: someone must ask to be on your email list, and then verify by clicking a link they want to be on it

Question:

How do listeners decide what is a worthwhile podcast to continually listen to?

a. High quality audio and high quality content

b. If it’s funny

c. Broad based podcasts with no general direction

d. Having several hosts and a myriad of topics

Answer: Having several hosts and a myriad of topics

Question:

Why is the subject line of any email campaign important?

a. It gives the person an opportunity to delete the email before reading it

b. It is all the receiver sees besides the email address until they open the email

c. It let the receiver know they are about to be sold something

Answer: It is all the receiver sees besides the email address until open the email

Question:

How is the “open rate” important?

a. It tells the company how many people clicked on the links in the email

b. It lets the company know how many people bought a product

c. It is the number of people who received the mail

d. It is the number of people who actually opened the email sent to them, giving the company insight in to how effective the email marketing campaign was

Answer: it lets the company know how many people bought a product

Question:

Why are affiliates not the same as having a sales force?

a. The affiliates are virtual

b. The affiliates can be based anywhere in the world

c. The affiliate only drives traffic, they do not necessarily convert them to sales

d. The affiliates have limited availability

Answer: The affiliates have limited availability

Question:

How is the pricing model of a click determined?

a. Standardized rate for the ad

b. Google sets the price worldwide

c. Ads always cost more in later months

d. The more popular a search term the more a customer will have to pay to use that term in his/her target keywords list

Answer: Google sets the price worldwide

Question:

What is the formula for calculating cost per customer acquisition?

a. Marketing spent on television divided by the number of new customers

b. Sales divided by customers

c. Total marketing budget divided by all customers ever

d. Total marketing budget for a specific period divided by the number of new customers for that same period

Answer: Total marketing budget for a specific period divided by the number of new customers for that same period

Question:

How much a company pay for the given example: Ad displays 20 times, 2 users click the ad, cost per click is 5 cents.

a. 90 cents

b. 10 cents

c. 20 cents

d. 1 cents

Answer: 10 cents

Question:

What is “cost per action”?

a. Same as pay per click

b. A payment agreement where a specific action creates a payable event for the affiliate such as a click a purchase a number of page views

c. A payment agreement where costs change depending on volume

d. The product cost

Answer: Same as pay per click

Question:

What is an “impression”?

a. When a person buys a product from a site

b. When your ad is displayed on a page online, not necessarily clicked on

c. When an ad is clicked on when an ad on

d. When an ad makes an impression on a client

Answer: When your ad is displayed on a page online, not necessarily clicked on

Question:

Which of the following is valuable in increasing a page rank?

a. Paying for placement

b. Static content

c. Quantity of links from other highly ranked pages to your site

d. No contact information

Answer: Quantity of links from other highly ranked pages to your site

Question:

What is meant by “web 2.0”?

a. The resurgence of internet companies with more interactive focus, such as blogging and social networking

b. Any website which has survived the dot com bust

c. Sites made using new technology

d. Internet companies who focus on retail sales

Answer: Internet companies who focus on retail sales

Question:

What is affiliate marketing?

a. Same as guerilla marketing

b. Selling ad space on your site

c. When a 3^rd party helps market your business, and in turn your pay them a commission based on sales as a result of their efforts

d. Pay per click marketing

Answer: When a 3^rd party helps market your business, and in turn your pay them a commission based on sales as a result of their efforts

Question:

Which of the following are podcasts least likely to target?

a. Sales

b. Branding

c. Customer loyalty

d. Customer delivery

Answer: Sales

12Jul2013

odesk conctructor tips

by ratonpramanik

Contractor Manual

Welcome to oDesk

We’re so happy you’re here. This Contractor Manual will help

you get started, find work, and build a successful oDesk career.

So give it a read and get ready to love the way you work!

What does oDesk do?

oDesk connects talented contractors with businesses around the globe, giving skilled workers

access

to jobs that are personally, professionally, and financially rewarding. We are the world’s largest online

workplace, ranked #1 by annual contractor earnings, with over 100,000 jobs posted monthly.

Why should I work on oDesk?

If you’ve got the skills, we’ve got the opportunities! You’ll find the tools, resources, and connections

you

need to build a long-lasting professional career. Payments are reliable and secure, and every hourly

contract is covered by

the oDesk Guarantee that an hour worked is an hour paid.

Great work is rewarded

Build your professional reputation on oDesk by working hard and getting great client reviews.

Positive feedback leads to more work. And more work leads to more money. In fact, we’ve

found that oDesk contractors on average increase their pay rate by 190% over three years.

Our technology builds trust

When you work with people around the world, having the tools to build mutual trust is key. So,

we created the oDesk Team App to let you log your time and get paid quickly and reliably.

Work without risk

There are no upfront costs when joining oDesk. You can create a professional profile, apply to

jobs, and interview without paying a penny.

So, how does oDesk make money?

It’s pretty simple. Once you’re hired, oDesk charges clients 10% of what they pay on your contract.

For

example, if your contract rate is set at $20/hour, your client will pay $22.20/hour. oDesk keeps $2.20 paid

by your client, so we only make money when you make money!

Contractor Manual

What is online work?

Practically any work that doesn’t require a physical presence can be done online. Writing? Yes!

Fixing

a sink? Not so much. Successful online contractors have built careers as developers, designers,

marketers, accountants, personal assistants, and more.

How is online work different from traditional work?

From setting your own hours to using your favorite café as an office, online work offers a level of

freedom and flexibility you don’t usually find in the traditional workplace. All you need is a computer,

a reliable Internet connection, strong skills, and the willingness to work.

You’ll also have a new boss—yourself! And while oDesk can supply the opportunity and tools, what you

do with them is up to you. This is why the most successful contractors are disciplined, entrepreneurial,

and determined to build their own career.

Who will I be working with?

You could work with a wide range of clients, from small businesses to large multinational compa

nies.

Some jobs offer 30 hours in a single week; others may need you for five hours a week for three months.

Either way, expect to work with clients of all shapes and sizes.

AN HOUR WORKED

IS AN HOUR PAID

The oDesk Guarantee

Contractor Manual

Are you ready? Are you excited? Yes? Then let’s go!

Here’s what you’ll need to get to work:

A fast, reliable Internet connection and an up-to-date Internet browser

A work-only email account and a free Skype account

A workspace that is quiet and distraction-free

A basic understanding of the English language

A ready-to-work attitude, a strong set of skills, and an entrepreneurial spirit

You’re just three steps away from joining the growing ranks

of online professionals…

If you haven’t signed up already, now’s the time. It’s free and easy and the first step to

an oDesk career.

Create your profile

Impress prospective clients and land your first job with a well-done contractor profile.

It’s like a personal resume, business card, and marketing brochure all rolled up in one.

So, take some time and do it right.

Set up your payment option

Get ready to get paid! We recommend setting up two funds transfer methods so that you can

paid easily. The method you choose will depend on your location. ACH for U.S. contractors and

Local Currency Wire to countries where it is available are popular because they are generally faster

and less expensive.

Let’s Get Started!

Contractor Manual

What Makes a Great Profile?

Successful profiles are complete, accurate, and paint a compelling

picture of your skills and accomplishments. Here’s how to make a

great first impression.

Introduce yourself

A complete, professional-looking profile starts with your

full name, title, and photo. Write a title that accurately

reflects the type of jobs you’re looking for. Your picture

should be of yourself—stock photos, celebrity pics, or

logos are not allowed.

Tell the world why you’re right

for the job

The overview is your opportunity to let a client know

what you can do for them. Include past successes

(number of years worked in a field, education level,

significant projects) and highlight your skills. Put the

most important information first—only the first few lines

from your overview will appear in search results

Set your rate

Your rate should reflect your experience and work

capabilities. Not sure how much to ask for? Look at the

going rate for those with similar skill sets, experience, or

geography.

Take a few oDesk skills tests

Skills tests are a great way to prove your value to

potential clients, especially for new contractors without

an oDesk work history. All our tests are free, so be sure

to take the U.S. English Basic Skills Test and a few

others that showcase your specific skills.

Post a portfolio

If you have images or links to work you’ve accomplished,

post them! (But be sure to get permission from your client

first.) Describe what you were responsible for, what went

into your decisions, and any success metrics. Don’t have

a portfolio? Upload letters of recommendation from

previous jobs.

Check for errors

The contractor with a well-written, professional profile

will always be a client’s first choice. Keep the tone

positive, avoid using ALL CAPS or text shortcuts, and

double-check that everything is grammatically correct

and spelled properly.

SHOW US YOUR SMILE

In some countries, a serious portrait indicates professionalism.

However, many oDesk clients are based in Western countries

where someone who smiles is considered more trustworthy

and pleasant. So increase your chances of getting hired and

show us your smile!

Contractor Manual

Ready…Set…Search!

Search is the best place to start looking for your first job. Look

for projects requiring your skills, then narrow down by category,

subcategory, hourly or fixed-price, and workload.

What to look for in a job post

When you find an interesting project, ask yourself these questions:

Do I have the right skills?

Only apply to the jobs you’re qualified for. Performing poorly and getting negative feedback

can damage your professional reputation. If you’re not 100% qualified, keep looking. The right

job is out there!

Can I prove I have the skills being sought?

When potential clients view your profile and cover letter, they look for the experience,

tests, and other proof that you can do the job. If your profile doesn’t demonstrate the skills

requested in the job post, search for a project more suitable to your proven experience.

Do I have the time?

If the post provides information on timing and deadlines, be sure you can commit to the

timeline before you apply.

Is the offered rate acceptable?

The rates offered by oDesk clients vary widely. If the rate is too low for the skills you offer at

this point in your career, move on.

Will I work well with this client?

Job descriptions say a lot about a client. Generally, the more detailed the description, the

more thought the client has put into the work and the greater their understanding of what it

takes to get the job done.

Contractor Manual

Fixed-price contracts are not covered

by the oDesk Guarantee and payment

is at the client’s discretion. These jobs

are generally smaller and are paid on

completion, with terms agreed upon

before work begins.

FIXED-PRICE

Hourly contracts are often preferred by

contractors. All time is logged through

the Team App and is covered by the

oDesk Guarantee.

HOURLY

REAL-LIFE CONTRACTOR TIP!

“For your first few jobs, I recommend working with clients who have oDesk experience. They

understand how to manage an online project, how the Team App works, and how to budget for your

hours. This helps you showcase your skills, get acquainted with the platform, and improve your

chances for positive feedback.”

Sayeed Islam,

IT Consultant

FIXED-PRICE VS. HOURLY CONTRACTS

Clients can choose between one of two contract types. Here’s how they compare.

Contractor Manual

Find the right job

and hit the

“Apply” button.

Enter your offered rate,

cover letter, attachments

(if any), and send.

The client will review

applications and contact

candidates for interviews.

The client may propose a paid “test

job” to get a better idea of your skills.

This is a great way to find out how

well you’ll work together

—just be sure

to agree upon a rate and number of

weekly hours before you begin.

Accept the offer and start working!

This is our recommended process for those new to oDesk. Once you complete a few jobs and become

more familiar with working online, you may skip a few steps. For example, some clients may hire you on

the spot, without an interview. We encourage you to work on oDesk in whatever way is best for you!

Applying & Interviewing

Now that you’re ready to work, the path to finding the right job is simple.

Here’s how the process works:

Contractor Manual

Setting your rate

You can set your hourly rate when you apply to a

job. Just change the default rate in the application

before you hit “send.”

To estimate your charge for fixed-price jobs, you’ll have to figure out how long it will take to finish.

Here’s one way to do it:

We recommend this process even when the client has specified a price for the job. That way, you can

judge whether the amount of money will be worth the amount of work.

REAL-LIFE CONTRACTOR TIP!

“The first mistake a newcomer usually makes is to drastically lower their rate in hopes of landing a

job. I suggest offering a ‘test hire’ option to your client instead. Get them to hire you for an hour or

two so they can sample your skills firsthand. The small test project will land you feedback, while

assuring the client of your quality and building trust.”

Ayesha Kamal,

Creative Writer and Social Media Expert

Break the job into phases. For instance,

building a website may include five phases:

planning, design, building, review, and testing.

Break each phase into the steps involved

so that you can communicate this to your

potential client.

For each phase, calculate your charge by

estimating the time it will take to complete,

including revisions.

Add up the estimated cost of all phases, plus a

little extra to account for unexpected issues.

Contractor Manual

Seven Steps to an Excellent

Cover Letter

So, you created an awesome profile and found the perfect job…now

how do you convince the client you’re the best for the job? By writing

a fantastic cover letter every time, for every job application.

Your cover letter is how you introduce yourself, highlight your skills and experience, and tell the client

exactly why they should hire you. It’s your big chance to show that you’ve read the job description,

understand the project, and are qualified for the job.

Here’s how to write a cover letter that impresses clients and leads to interviews:

Make a professional impression

Begin with a warm, professional greeting. “Hello

Mr. Smith” or “Hi John” are both polite and

appropriate. A simple “hello” sets a professional

tone when you don’t have the name of the person

doing the hiring.

Be specific

Keep your cover letter short and sweet. Tell the

client why you’re writing and why you’re qualified.

Stand out from the crowd with specific examples

of your experience and how they relate to the job.

Relate back to the job post

Call out the skills you have that are specific to the

job post. This makes it clear you have read the job

description and are ready for the job.

Ask clarifying questions

Asking a thoughtful and appropriate question

about the job shows that you understand how

to do the work and demonstrates the value you

bring to the job.

Follow directions!

Some clients might ask you to answer a specific

question or include a keyword in your cover letter.

This helps them filter out generic, “copy and paste”

cover letters. Look for these directions and follow

them. It shows that you’re paying close attention to

their job post.

Close the deal

Let them know your availability to discuss further.

It’s a polite way to “ask for the job” and reinforce

your enthusiasm.

Reread, edit, and consider

Take another look at the job description. Did you

address all of the criteria and answer the client’s

questions? Have you added relevant links to

samples of your work? Do a final grammar and

spelling check before you hit “send.”

Contractor Manual

The

mistake new contractors make is not taking

the time to write

a relevant, error-free

cover letter! Here’s how to do it right:

Hello,

I found your Sales Training Deck job post and I’m very interested in

your project. As a certified Microsoft professional with experience

developing compelling presentations, I think you’ll find I have the skills

you’re looking for.

Please take a look at my portfolio to get an idea of the kind of

presen

tations I have developed. Typically, I can edit and design a

20-page presentation like yours within three hours. I’m wrapping up

a project now and will have availability beginning tomorrow.

I do have a few questions about the requirements and would be open

to an interview. I will be online for the next 2 hours if you would like to

discuss. Otherwise, please let me know what times work for you.

Thank you for your consideration,

Joe Contractor

Presentation Specialist

showcase

certifications

refer to

your portfolio

discuss

availability

demonstrate

added value

Once you’ve applied, you may receive a notification that the client would like to set up an interview, or maybe

even hire you immediately. Occasionally, you may not hear anything back. Clients are not required to respond

to applications, so keep your options open by applying to other jobs.

REAL-LIFE CONTRACTOR TIP!

“Getting clients to read your cover letter is the test of your ability to brand and market yourself.

Without unique and relevant content to make you stand out, your letter will get tossed aside like

all the others.”

Stef Gonzaga,

Freelance Copywriter and Professional Blogger

CAN THE SPAM

Please don’t send the same “cut and paste” cover letter to every job post. It hurts your chances of

getting hired and can result in a suspension from oDesk. It’s okay to adapt an old cover letter, but

you must rewrite it to make it specific to the project you’re applying for.

Contractor Manual

If the client requests an interview, reply quickly with your availability and find a time that works for you

both. If your potential client is many time zones away, you may need to interview at a time that is early

or late for you. Interviews can be text-based through the oDesk Message Center, over Skype, or over

the phone, so agree on a method that works best for both of you. Make sure you understand how the

interview will be conducted (for example, voice vs. text on Skype) so you can prepare!

Get set for success

Just as for any meeting, you should be prompt, polite, prepared, and professional.

Here’s how to make your

interview a success:

Ace the Interview

Congrats! You made it to the interview. Now it’s time to get

prepared, just as you would for any face-to-face interview. You’re

this close to getting the job, so set yourself up for success.

Be flexible

Time zones and communication preferences

can be tricky; be willing to adapt to the time and

interview method the client prefers.

Do your homework

Research your client so you can have a smart

conversation about their business, and write

down a few project-specific questions.

Find a quiet space

If you’re on the phone or Skype, background noise

or interruptions can make you seem unprofessional.

Double-check your portfolio

If you have a piece especially relevant to the

project, be sure to include it in your portfolio and

share it with the client.

Be prepared—mentally and technically

Give yourself ample time before the interview to

review your materials and think about what you’d

like to say. Make notes of past work examples to

discuss. Test your computer’s microphone and

speakers early so you can fix them before the

interview if necessary.

Before the interview:

Contractor Manual

Be professional

Talk about your accomplishments and ask

questions about the job in a way that is respectful

and polite.

Be honest

If you don’t know the answer to a question

(or don’t like the answer you have to give), be

honest. Misleading a client will lead to a bad

experience for everyone.

Suggest a test project

If you think it will help, consider suggesting a small

paid test job that lasts only an hour or two. This

shows confidence and sends a good message to

the client.

End on a positive note

Ask if there is a deadline for hiring so you’ll know

when the client will make a decision. And always

thank them for the interview!

During the interview:

Provide additional info

If you promised to provide additional information or

a link to an extra portfolio piece during the interview,

do so promptly and include a thank-you note.

Always follow up

Send a short and friendly thank-you note. You

may also add a line or two to reinforce a point

made in your interview.

After the interview:

SPEAKING ENGLISH

Be up front about your English skills. Our clients are used to working with people around the globe,

so don’t be afraid to politely ask them to speak a little slower or repeat their question during an

interview. That said, English is the official language of oDesk, and our most successful contractors

tend to be those who communicate well.

APPLICATION QUOTAS

Our job application quota limits the number of applications you can submit at a time. So be sure

you only apply to jobs you’re qualified for. Increase your quota by:

• Taking and passing the oDesk Readiness Test

•

Taking and passing four or more free skills tests

•

Verifying your identity

•

Getting good feedback for a completed job

Contractor Manual

Waiting is the hardest part

Waiting to find out if you got a job is never easy, but it’s important to give the client time to finalize

their decision. You can get an idea of their progress by checking the job post to see how many

candidates have been interviewed and if the job is still open.

If you don’t receive a response, you can withdraw your application and find other jobs. Before

withdrawing your application, we recommend sending a brief note letting the client know that you

are moving on to other opportunities, but would love to work with them in the future.

You got the job? Yay!

RED FLAGS!

If a client asks you to start work without creating a contract on oDesk, beware! You won’t be protected

by the oDesk Guarantee, and if the client doesn’t pay you for your work, you’re out of luck.

Just as important, if you work outside of oDesk, you won’t receive any client feedback for your profile.

Your feedback score plays a huge part in landing jobs and growing your professional reputation—good

feedback is often the key to getting hired. So, if a client asks you to work outside of oDesk, please

contact Customer Support.

Well done! If your pay rate hasn’t been discussed,

you’ll have to do so now. Make sure that you’re

comfortable with the agreed-upon rate.

When you’re ready, hit the “accept” button and do a happy “I got the job” dance! You’ve earned it.

Now, get ready to work.

Contractor Manual

Making it work

Working alone can be difficult. There are a million distractions and no supervision, so it’s easy to

procrastinate. But a little discipline goes a long way

—use these tips to stay on track.

Create a workspace

Find a dedicated “office space” with minimum distractions. If there are kids in the house,

let them know that you are working and should not be disturbed unless it is important.

Establish your workspace and teach them to let you work uninterrupted.

Set regular work hours

Having the freedom to set your own schedule is fantastic, but creating an established

workday makes it easier to get work done and lets your client know when you’re available.

But it doesn’t have to be the traditional 9-to-5. Maybe it’s four hours in the morning and then

a second shift in the evening—whatever works best for you on a consistent basis.

Disengage your gadgets

If you’re at home, turn off the TV and power down your smartphone. The fewer distractions,

the better!

Start the project right

Before you start working, set up a kickoff meeting or write a message to your client. Make a list of

what you need, including passwords and permissions to any databases or websites, access to any

Google Docs or Basecamp tools, and contact info for team members you’ll be working with.

Establish a client communication plan that details how often you’ll need to report on progress. You

can communicate with your client through the oDesk Message Center, email, or chat, but choose one

method and stick with it to avoid confusion.

Get the Job Done

Here’s where the real fun begins! This section will help you

understand what it takes to work well and build a career on oDesk.

Contractor Manual

Using the Team App

TRACKING YOUR OFFLINE TIME

Does your job require work that can’t be tracked via a screenshot? No problem. This is called

manual time, and it can be used to log time for phone calls, sketching, offline research, and

other non-digital components of the project. Because manual time isn’t protected by the oDesk

Guarantee, clear it with your client first and be extra communicative to avoid disputes.

WEEK 1

WEEK 2

Client Review

Workweek

WEEK 3

Security Hold

Pay Day

If you’re starting an hourly contract, you’ll have to

download the Team App to enter hours and get paid

for your time.

The Work Diary feature of the Team App tracks your time

and takes work-in-progress snapshots at random times in

10-minute intervals. These snapshots reassure your client

that work is being done and allow us to guarantee you’ll be

paid, even if a dispute arises. (You can always delete the

ones you don’t want shared and billed to your client!)

Your client may set a maximum number of hours

you can log in one week. Know your limit and tell

your client when you’re getting close to reaching it.

This allows them to decide whether to increase the

limit or wait until next week to continue.

When the workweek is over, you and your client

have a chance to review your timelogs before

they are finalized and payment is processed. The

workweek ends every Sunday and your earnings

become available 10 days later.

Contractor Manual

To avoid disputes and have the safest work experience

possible

follow these rules of thumb:

If it looks too good to be true, it probably is. Use your best judgment when applying to jobs

and don’t be afraid to ask questions if you have any concerns.

If you don’t know it, don’t click it. Only download files onto your computer or click links from

identified trusted sources.

Avoid any client who requests free work in exchange for feedback, and never pay for the

chance to work!

Research your potential client to decide if you want to work with them. Verify legitimacy by

looking at their:

• Jobs posted

• Number of hires

• Current team size

• Verified payment method

• Feedback received

• Budget or hourly rate paid for past jobs

• Total amount paid or hours billed to date

If a job post looks suspicious, please report it to our Customer Support team. Keeping your online

workplace safe is our top priority, and we work around the clock to remove inappropriate content.

Trust & Safety

The oDesk Guarantee

Mutual trust, honesty, and respect keep the oDesk workplace professional and secure.

And every hourly contract is covered by the oDesk Guarantee that an hour worked is an hour paid.

Contractor Manual

Project Management 101

Managing your own projects is a big part of working online. This may mean juggling multiple jobs and

deadlines, all while communicating with your client and doing great work. Help yourself out by:

Being your own best manager

Take responsibility for doing excellent work and delivering on time, every time.

Setting expectations

Establish realistic deadlines and give your client regular progress updates.

Resolving issues quickly

No project is perfect, so be proactive and honest when problems arise.

Using a project management tool

Or simply use a spreadsheet to track what needs to be done. Create a project road map

to help tackle each phase of the project, one by one.

PREPARE FOR EMERGENCIES

Things go wrong. Power goes out. The weather goes bonkers. Prepare yourself for emergencies by:

• Backing up your data frequently, especially if you live in a place where power outages

are common.

• Having a secondary way of working despite power or tech failures.

• Writing down your clients’ contact info so that you can get in touch even when

you’re offline.

Contractor Manual

Dos and Don’ts of

Written Communication

Following up

You’re responsible for keeping your projects on track, so if you sent something to a client and

haven’t heard back, follow up with a friendly note to make sure your work was received. And don’t

wait too long. Your original email may have been swallowed by a spam filter.

be professional and polite. A safe bet is to behave just little bit more

formally than your client.

DON’T

use

ALL CAPS

unless you truly need to emphasize a point. All

capitals can be interpreted as shouting.

DON’T

use too many emoticons. They can come off as unprofessional.

DON’T

use slang like “I dunno” or “gotta,” and definitely steer clear of “TTYL”

and other text shortcuts.

be careful with your jokes. Humor can translate poorly in written form

and across cultural gaps.

DON’T

bring up religion, politics, or personal issues in your professional

communications.

be concise. It’s your job to save your client time while communicating

thoroughly. After you write an email, give it a quick reread to see whether you

can convey the same information in fewer words.

A NOTE ABOUT CHAT

IM and voice chats are great tools to touch base and get quick answers to questions. Let clients

know your availability and keep an eye out for their chats. Get in touch before initiating a call so

you don’t catch a client by surprise, even if their IM status shows “online/available.”

Contractor Manual

When a job is finished

Once you deliver the final product, send an email to thank your client and let them know you’re available

if they have questions or concerns.

If your contract remains open, your client may still be reviewing your work. But because you receive

feedback only after the job is closed, feel free to ask them to close the job once the work is reviewed.

Get ready for more work

Update your portfolio once a job is done, adding an image or link to the final product if your client has

given you permission to do so. Learned something new? Add it to your overview and skills list. And if

you strengthened a skill, retake the skills test or mention that skill more prominently.

You’re Done! Now What?

Congratulations on a job well done. Now that you have experience, it will be easier to land another job

and increase your hourly rate.

DO GREAT WORK, GET GREAT FEEDBACK, GROW YOUR CAREER

Once you complete a job, your client will rate your work from 1 to 5 stars and leave a note

about their experience. Delivering quality work and being a pleasure to work with are the most

important things you can do to get positive feedback.

Contractor Manual

Seven habits of

Successful

Contractors

Communicate early,

communicate often

Be proactive—don’t make your client

come to you.

When in doubt, ask

This will help clear up confusion, save

time, and keep the job going smoothly.

Set clear expectations

Provide honest and realistic project updates

and quickly alert your client when you

encounter a problem.

Respond quickly

Clients get concerned when they don’t

hear from a contractor.

Hit deadlines

Deliver your work on time, every time. If

you think you’ll miss a deadline, let your

client know so they can plan accordingly.

Be a pleasure to work with

Listen to your client’s concerns and respond

with a smile. A positive attitude is key to

building your professional reputation.

Under-promise, over-deliver

Never promise more than you can deliver

and always give a little extra to every job.

That’s the secret to happy clients and a

successful career!

Print this out and

pin it up where you work.

28Jun2013

ms office 2010

by ratonpramanik

01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?

Ans: It allows you to scroll through two or more workbooks simultaneously

02. Which of the following functions would return a value of 8?

Ans: round(8.4999,0)

03. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?

B1:27

B2:22

B3:28

B4:21

Ans: 0

04. How can you select all the blank cells in your worksheet?

Ans: Choose blank in the Edit->Go to->special Menu option

The question is based upon the figure shown

05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?

Ans: Its adds up the values in the selected cells

06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?

Ans: Use the wrap txt option in the Format->Cells>Alignment Menu

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

Ans: #N/A

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

Ans: = A1&”_”&B1

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

Ans: EOMONTH

10. Which of the following shortcuts can be used to insert a new line in the same cell?

Ans: Alt+Enter

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

Ans: MAX(B1:B3)

12. State Whether True or false.

Ans: True

13. This question is based upon the figure bellow

What does the purple triangle at the bottom right corner of the cell signify?

Ans: Smart Tag

14. You have created a worksheet which consists a confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

Ans: Select the cells, open the Window menu and click on Hide

15. This question is based upon the figure shown bellow

The figure shows an Excel worksheet. What does the read triangle in C2 signify?

Ans: There is a comment associated with the cell

16. You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans: 3 new rows will be inserted after row 9

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

Ans:

Which of the following statements regarding the QUARTILE function is not true?

Ans: The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.

19. You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans: Date

20. This question is based upon the figure shown below

What will be the value in the cell C2 as shown in the figure when we use formula = A2+B2?

Ans: 120

21. What is the quickest way to select all the columns on a worksheet?

Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

22. What does the NOW() function returns?

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

23. A smart tag will be removed from a cell when……………….

Ans: The data in the cell is changed or deleted

24. You would like to restrict the values that can be entered into a cell so that only whole numbers between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?

Ans: The setting tab under the menu Data->Validation

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

Ans:

26. You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?

Ans: Hold down the CTRL key during startup

27. How does the AutoComplete feature in Excel help you save time?

Ans: It automatically completes abbreviated words

28. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Z?

Ans: It copies the formatting properties from one cell to another

29.The figure shows the AutoFit Selection menu option. What function does it perform?

Ans: : It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

30. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter A

Ans: It is used to add a hyperlink

31. Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

Ans: Apply the Text Format to empty cells, and then type the numbers

32. What is the quickest way to select all the columns on a worksheet?

Ans: Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

33. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?

Ans: A_B

34. How can you select all the blank cells in your worksheet?

Ans: This must be done manually as it is not automated through any built-in feature

35. The figure shows an Excel worksheet. If you want to F the row showing the months (row 1) and the column showing the products (column A), what should you do?

Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

36. Which of the following functions would return a value of 8?

Ans: b and c

37. You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?

Ans: 3 new rows will be inserted after row 9

38. The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter X ?

Ans: It inserts a Diagram or Organization Chart in the worksheet

39.When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.

Ans: TRUE

40. You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

Ans: Select the cells, open the Window menu and click on Hide

41. Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?

Ans: DATEVALUE

42. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y?

Ans: It adds up the values in the selected cells

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

Ans: #N/A

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

Ans: MAX(B1:B3)

45. You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:

Ans: Date]

46. What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?

Ans: #N/A

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

Ans: TRUE

48. What does the NOW() function returns?

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

49. Which toolbar is shown in the figure?

Ans: Forms toolbar

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

Ans: FALSE

51. You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

Ans: b

52. figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter ‘Z’?

Ans: It copies the formatting properties from one cell to another

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

Ans: *

54. You can select the current row by pressing

Ans: Shift + Spacebar

55. Donelp you do this?

Ans: Select the cells, open the Window menu and click on Hide

56. The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y

Ans: It adds up the values in the selected cells

57. You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Print What->Selection. What will happen?

Ans: The selected area will be printed

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

Ans: Left aligned

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

Ans: False

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

Ans: True

61. A relative cell reference changes when a formula is copied or moved to other locations.
Ans: True
62. If cell entries are changed, the formula will automatically recalculate the values and insert the result in the cell containing the formula.

Ans: True

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

Ans: False

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

Ans: Enter

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

Ans: A3:G3

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

Ans: workbook

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

Ans: Fill

68. Which of these operators are in the correct order of operations?

Ans: ^,*,-

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

Ans: True

70. By default, data in a cell is centered

Ans: False

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

Ans: True

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

Ans: True

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

Ans: False

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

Ans: True

75. To delete a specific cell as well as the text within it, make the cell active and then

Ans: click Edit and then Delete

76. Which of the following is an absolute cell reference

Ans: $B3

77. To select nonadjacent cells, columns, or rows, you must

Ans: hold down the Ctrl key while clicking column, row header, or specific cells

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

Ans: arrow pointer

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

Ans: True

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

Ans: False

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

Ans:True

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

Ans: False

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

Ans: False

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

Ans: True

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

Ans: Header/Footer

86. If a function is included in an argument within a function, it is called a

Ans: Nested Function

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

Ans: Header/Footer

88. A new workbook initially contains this many sheets

Ans: Three

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

Ans: True

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

Ans: False

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

Ans: False

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

Ans: True

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

Ans: True

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

Ans: False

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

Ans: Patterns

96. This chart is the default chart

Ans: Column Chart

97.Which of the following displays the contents of the active cell?

Ans: Formula bar

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

Ans: True

99. You can copy cell formats from one cell to another by using the

Ans: Format Painter

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

Ans: True

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?
Ans: 0

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

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

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

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

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

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

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

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

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

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

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

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

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

The figure shows an Excel worksheet. If you want to F the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

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

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

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

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

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

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

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

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

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

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

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

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

This chart is the default chart
Ans: Column Chart

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

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

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

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

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

You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Print What->Selection. What will happen?
Ans: The selected area will be printed

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

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

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

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

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

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

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

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

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

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

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

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

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

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

A new workbook initially contains this many sheets
Ans: Three

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

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

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

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

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

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

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

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

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

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

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

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

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

State Whether True or false.
Ans: True

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

You have created a worksheet which consists a confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans: Select the cells, open the Window menu and click on Hide

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

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

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

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

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

Which of the following are considered bad manners while greeting a business visitor to your office

Ans: e) all of the above
Ques: which of the following file formats relate to a graphic file or scanned image file?

Ans: e) a and d
Ques: What are the dimensions of an A4 size sheet of paper

Ans: d) 210 mm x 297 mm
Ques: Traditionally, approximately how many pages should a business CV or resume have?
Ans: a) 1-3, preferably 2
Ques: Which of the following are commonly used computer web browser
Ans: c) Chrome, Explorer, Firefox,
Ques: When reply to an e-mail, who do you place in the cc: and who in the bcc : line?
Ans: c) A person you wish to openly inform goes in the cc: line,
and the person you wish to read the e-mail, but without knowledge
of either the recipient or the person in the cc: line, goes in the bcc: line.
Ques: What is very important to remember to do when entering an office business meeting at any level, especially when clients are there?

Ans: e) a and c
Ques: There are 20 new PC’s in the account department. Should there be an apostrophe in PC’s?
Ans: a) No

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

Ques: When a client visits the office and arrives early what do office etiquette require you to do to handle the situation?
Ans: d) All of the above.
Ques: What does the CTRL+V shortcut accomplish in Word 2000?
Ans: b) it pastes the text that

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

Ques: What is flexi-time?
Ans: b) The flexible use of personal office hours, such as working an hour earlier one day, in order to leave an hour earlier another day
Ques: What does the glass ceiling refer to in a business context?

Ans: c) The upper level of senior management or company execution positions
which is traditionally hard to break through, for example, for women and/or minorities.
Ques: What is the best way to handle an angry colleague or client with a complaint?
Ans: a) listen to their concerns, and calmly but firmly explain what you are able to do ,
offering other solutions and oppositions without getting angry in turn.
Ques: What are the traditional office hours in the Western world, now much more flexible, though still adhered to in most office?
Ans: a) 9 a.m. – 5 p.m.
Ques: What common injury can result from too much concentration typing over too little amount of time?

Ans: d) Repetitive strain injury
Ques: What does administration generally handle in an office environment?

Ans: c) The efficient day-to-day running of the office, with regards to company files , communication, management of jobs such as overseeing hiring and firing and human resources, etc.
Ques: What is the benefit of e-mailing documents rather than always providing hard copies to individuals?

Ans: d) b and c
Ques: What is the difference between Microsoft Access and Microsoft Excel?

Ans: b) Access is mainly for database and Excel is for spreadsheets
Ques: What is the person in charge of administering an office commonly called?

Ans: d) CEO
Ques: Which of the following activities could possibly infect your computer with virus?

Ans: a) Installing pirate software from a CD

State whether true or false:

A Macro project can be digitally signed.

True
False

Answers is: True
Question 2:

How would you select an entire PivotTable report?

On the Home tab, in the Editing group, select the ‘Entire PivotTable’ option
On the Options tab, in the Actions group, click on Select, and then click ‘Entire PivotTable'”
On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option
None of the above

Answers is: None of the above

Question 3:

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

It signifies that the cell contains a formula
It signifies that the cell contains a comment
It signifies that the cell contains a macro
All of the above

Answers is: It signifies that the cell contains a macro

Question 4:

How will you reverse the direction of a SmartArt graphic?

Right-click on the SmartArt graphic, select Reverse
Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
All of the above

Answers is: Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
Question 5:

State whether true or false:

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

True
False

Answers is: False

Question 6:

Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?

Answers is: B
Question 7:

Which tab should be used to display or hide axes?

Data tab
Layout tab
Insert tab
View tab

Answers is: Insert tab
Question 8:

Which keyboard shortcut should be used to enter the current time?

CTRL+SHIFT+”
CTRL+SHIFT+:
CTRL+;
None of the above

Answers is: CTRL+SHIFT+:
Question 9:

Which among the following settings is the default macro setting?

Disable all macros without notification
Disable all macros except digitally signed macros
Disable all macros with notification
Enable all macros

Answers is: Enable all macros
Question 10:

Which of the following is not true regarding column width?

If the column width is set to 0, the column is hidden
A column width between 0 to 255 can be specified
The default column width is 8.43 characters
All of the above are true

Answers is: A column width between 0 to 255 can be specified
Question 11:

Which of the following is not a valid file extension in which an Excel file can be saved?

XLSB
XLSM
PXL
All of the above are valid

Answers is: All of the above are valid
Question 12:

State whether true or false:
A Macro project can be digitally signed.

True
False

Answers is: False
Question 13:

What does the screen tip displaying “Showing All” mean?

It means that a Filter has been applied
It means that Filtering has been enabled but not applied
It means Excel does not support such a Filter
None of the above

Answers is: It means that Filtering has been enabled but not applied
Question 14:

How would you assign a Macro to a graphic?

On the Developer tab, in the Controls group, select Macro name
On the View tab, click on Macros and then click ‘Assign Macro’ on the shortcut menu. In the Macro name box, click on the macro that you want to assign
On a worksheet, right-click on the graphic, then click ‘Assign Macro'” on the shortcut menu. In the Macro name box, click on the macro that you want to assign
All of the above

Answers is: On the View tab, click on Macros and then click ‘Assign Macro’ on the shortcut menu. In the Macro name box, click on the macro that you want to assign

Question 15:

What is the purpose of using the Keep text flat option, as shown in the picture???

It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
It prevents the text from blurring
It moves the WordArt or text backward
Both b and c

Answers is: It prevents the text from blurring
Question 16:

Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

By selection
By corresponding field
By value field
By number field

Answers is: By value field

Question 17:

Which of the following is not true regarding naming a cell?

Names are case sensitive
A name can contain up to 255 characters
Names can contain uppercase and lowercase letters
Some keyboard characters can cause unexpected results if used in cell names

Answers is: Some keyboard characters can cause unexpected results if used in cell names

Question 18:

Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?

It selects all the cells in the worksheet
It selects a large range of cells in the worksheet
It selects non-adjacent cells in the worksheet
It selects an entire row in the worksheet

Answers is: It selects a large range of cells in the worksheet

Question 19:

Which of the following charts have no axes?

Doughnut charts
Pie charts
Both a and b
None of the above

Answers is: Both a and b

Question 20:

How should blank cells be inserted on a Worksheet?

Select the cell or the range of cells. Then on the Home tab, in the Cells group, click ‘Insert Cells’
Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
Both a and b
None of the above

Answers is: Select the cell or the range of cells. Then on the Home tab, in the Cells group, click ‘Insert Cells’
Question 21:

As shown in the image, the checkbox ‘Create links to source data’ has been selected. Which of the following statements is correct regarding this?

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

Answers is: None of the above

Question 22:

Which of the given methods would you follow to add an alternative text to a picture?

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

Answers is: Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
Question 23:

Where can the ‘Show All Comments’ command be found?

On the Page Layout tab
On the View tab
On the Review tab
All of the above

Answers is: On the Review tab

Question 24:

How will you find cells with data validation?

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

Answers is: On the View tab, in the Windows group, click Data Validation
Question 25:

Which chart displays axes but cannot display axis titles?

Radar chart
Doughnut chart
Pie chart
All of the above

Answers is: Pie chart

Question 26:

State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.

True
False

Answers is: True
Question 27:

Which file format is typically used to remove printer corruption?

XLS format
HTML format
SYLK format
All of the above

Answers is: SYLK format
Question 28:

Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

HLOOKUP
VLOOKUP
TRANSPOSE
None of the above

Answers is: None of the above

Question 29:

Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?

Consolidate by position
Consolidate by category
Consolidate by formula
None of the above

Answers is: Consolidate by position
Question 30:

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

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

Answers is: It will display Fuller Andrew
Question 31:

When would the data validation command be unavailable on the data tab?

When an Excel table is linked to a SharePoint site
When data in a cell is entered
When the workbook is shared or protected
All of the above

Answers is: When the workbook is shared or protected

Question 32:

State whether true or false:
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

True
False

Answers is: False

Question 33:

State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

True
False

Answers is: False

Question 34:

What is the option on the Document Inspector that finds the content type information?

Comments and Annotations
Headers and Footers
Document Properties and Personal Information
Hidden Rows and Columns

Answers is: Hidden Rows and Columns
Question 35:

Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?

Answers is: C
Question 36:

State whether true or false:
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.

True
False

Answers is: True
Question 37:

Which of the following options would you choose to clear a PivotChart report?

On the Analyze tab, in the Data group, click on Clear, and then click ‘Clear All’
On the Options tab, in the Actions group, click on Clear, and then click??’Clear All’
Both a and b
None of the above

Answers is: None of the above
Question 38:

Which keyboard shortcut should be used to minimize or restore the ribbon?

CTRL+F3
CTRL+F2
CTRL+F1
None of the above

Answers is: CTRL+F2

Question 39:

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

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

Answers is: It occurs when a negative time is used
Question 40:

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

A
B
C
None of the above

Answers is: B

Question: Question:If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.

02. Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl

03. Question:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answer: c. Make the field hidden.

04. Question: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.

05. Question: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Answer: b. Square

06. Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
Answer: b. Tables with maximum number of rows and columns was added to the document.

07. Question: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.

08. Question: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.

09. Question: With which chart type(s) is the “Depth Gridlines” option available?
Answer: b. Line chart

10. Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI

11. Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Answer: c. XLS

12. Question: What view must be used when inserting a subdocument?
Answer: b. Web Layout

13. Question: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
Answer: c. By using the Recolor option under Format Picture.

14. Question: Which of the following in NOT a type of Section Break?
Answer: d. Continuous

15. Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
Answer: c. Orientation

16. Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
Answer: b. Insert Flowchart

17. Question: When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
Answer: b. False

18. Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
Answer: a. “Allow row to break across pages” is unchecked.

19. Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Answer: a. Open Type fonts

01. Q: If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.

02. Q: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl

03. Q: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answer: c. Make the field hidden.

04. Q: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.

05. Q: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Answer: b. Square

06. Q: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
Answer: b. Tables with maximum number of rows and columns was added to the document.

07. Q: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.

08. Q: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.

09. Q: With which chart type(s) is the “Depth Gridlines” option available?
Answer: b. Line chart

10. Q: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI

11. Q: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Answer: c. XLS

12. Q: What view must be used when inserting a subdocument?
Answer: b. Web Layout

13. Q: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
Answer: c. By using the Recolor option under Format Picture.

14. Q: Which of the following in NOT a type of Section Break?
Answer: d. Continuous

15. Q: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
Answer: c. Orientation

16. Q: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
Answer: b. Insert Flowchart

17. Q: When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
Answer: b. False

18. Q: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
Answer: a. “Allow row to break across pages” is unchecked.

19. Q: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Answer: a. Open Type fonts

20.Q:If you want to create a citation and fill in the source information later, you should:

Ans: a. insert a caption.
21.Q:To select vertical blocks of text, you would hold down which key while dragging the mouse?
Ans: b. Ctrl

22.Q:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?

Ans: c. Make the field hidden.

23.Q:Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?

Ans: c. Change chart type to a line chart and type all the values into an Excel file.

24.Q:You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?

Ans: b. Square

25.Q: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?

Ans: b. Tables with maximum number of rows and columns was added to the document.

26.Q:A particular chart layout can be applied to a chart only if:

Ans: c. it is a 2D chart.
27.Q:Choose the INCORRECT statement:

Ans: a. Only high-risk documents from an uncertain location are opened in Read-Only view.

28.Q:Microsoft Word 2010 has enabled ligatures for which of the following fonts?

a. Open Type fonts

29.Q:With which chart type(s) is the “Depth Gridlines” option available?

Ans:b. Line chart

30.Q:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?

Ans:c. MDI

31.Q:I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

Ans:c. XLS
32.Q:What view must be used when inserting a subdocument?

Ans: b. Web Layout

33.Q:Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?

Ans:c. By using the Recolor option under Format Picture.

.
34.Q: Which of the following in NOT a type of Section Break?

Ans: d. Continuous
35.Q: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.

Ans: c. Orientation

36.Q: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?

Ans: b. Insert Flowchart

37.Q:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.

Ans: b. False
38. Q: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?

Ans: a. “Allow row to break across pages” is unchecked.

39.Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.

40.Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

41.Question: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
c. Make the field hidden.

42.Question: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.

43.Question: You want to add an image as the first character in your paragraph. Which type nf text wrapping treats your graphic as if it were a character?
b. Square

44.Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?

b. Tables with maximum number of rows and columns was added to

45.Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

46.Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

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

48.Question: With which chart type(s) is the “Depth Gridlines” option available?
b. Line chart

49.Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI

50.Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
c. XLS

51.Question: What view must be used when inserting a subdocument?
b. Web Layout

52.Question: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
c. By using the Recolor option under Format Picture.

53.Question: Which of the following in NOT a type of Section Break?
d. Continuous

54.Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
c. Orientation

55.Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
b. Insert Flowchart

56.Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
b. False

57.Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
a. “Allow row to break across pages” is unchecked.

58.Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.

58.Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl

59.Question: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
c. Make the field hidden.

60.Question: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company’s turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.

61.Question: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
b. Square

62.Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document’s appearance changed from Image A to Image B. Which of the following options could be the cause?
b. Tables with maximum number of rows and columns was added to the document.

63.Question: A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.

64.Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.

65.Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?

Ans: a

66.Question: With which chart type(s) is the “Depth Gridlines” option available?

Ans: b

67.Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?

Ans: c

68.Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?

Ans: c

69.Question: What view must be used when inserting a subdocument?

Ans: b

70.Question: Josh is creating a collage for his college project. He has an image – Image A – which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?

Ans: c

71.Question: Which of the following in NOT a type of Section Break?

Ans: d

72.Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.

Ans: c

73.Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?

Ans: b

74.Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.

Ans: b

75.Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?

Ans: a

Question:

Refer to the given image. Which line style option should be used to specify the style used for the end of the line?

a. A

b. B

c. C

d. D

Question:

Which keyboard shortcut should be used to enter the current time?

a. CTRL+SHIFT+”

b. CTRL+SHIFT+:

c. CTRL+; Current date

d. None of the above

Current date Select a cell and press CTRL+; Current time Select a cell and press CTRL+SHIFT+;

Current date and time Select a cell and press CTRL+; then SPACE then CTRL+SHIFT+;

Question:

What does the screen tip displaying “Showing All” mean?

a. It means that a Filter has been applied

b. It means that Filtering has been enabled but not applied

c. It means Excel does not support such a Filter

d. None of the above

Question:

State whether true or false:

When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

a. True

b. False

Question:

Which of the following charts have no axes?

a. Doughnut charts

b. Pie charts

c. Both a and b

d. None of the above

Question:

How would you locate the last cell on a worksheet?

a. Click anywhere in the worksheet, and then press CTRL+HOME

b. Click anywhere in the worksheet, and then press CTRL+INSERT

c. Click anywhere in the worksheet, and then press CTRL+END

d. None of the above

Question:

What is the purpose of using the Keep text flat option, as shown in the picture?

a. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated

b. It prevents the text from blurring

c. It moves the WordArt or text backward

d. Both b and c

Question:

How will you reverse the direction of a SmartArt graphic?

a. Right-click on the SmartArt graphic, select Reverse

b. Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse

c. Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left

d. All of the above

Question:

Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?

a. A

b. B

c. C

d. D

Question:

Which part of the formula displays references in the given picture?

a. A

b. B references

c. C

d. D

Question:

Which of the following wildcard characters can be used as comparison criteria for Text Filters?

a. ?

b. *

c. ~

d. All of the above

wildcard characters can be used as comparison ? (question mark) * (asterisk) ~ (tilde) followed by ?, *, or ~

Question:

How can a chart be modified?

a. By modifying a legend

b. By modifying the display of chart axes

c. By modifying titles and data labels

d. All of the above

Question:

Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?

a. CTRL+ALT+F10

b. CTRL+SHIFT+ALT+F9

c. SHIFT+F9

d. None of the above

Question:

State whether true or false:

A Macro project can be digitally signed.

a. True

b. False

Question:

How would you select an entire PivotTable report?

a. On the Home tab, in the Editing group, select the ‘Entire PivotTable’ option

b. On the Options tab, in the Actions group, click on Select, and then click ‘Entire PivotTable'”

c. On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option

d. None of the above

Question:

When ‘a’ or ‘p’ is not typed after the time in Worksheet cells, what does Excel enter the default time as?

a. It displays the prompt box and asks the user to type ‘a’ or ‘p’

b. It displays an error message

c. It enters the time as PM

d. It enters the time as AM

e. None of the above

Question:

How would you assign a Macro to a graphic?

a. On the Developer tab, in the Controls group, select Macro name

b. On the View tab, click on Macros and then click ‘Assign Macro’ on the shortcut menu. In the Macro name box, click on the macro that you want to assign

c. On a worksheet, right-click on the graphic, then click ‘Assign Macro'” on the shortcut menu. In the Macro name box, click on the macro that you want to assign

d. All of the above

Item No: 18 of 40 Time Remaining: 0:34:31

Question:

Which of the following is not a valid file extension in which an Excel file can be saved?

a. XLSB

b. XLSM

c. PXL

d. All of the above are valid

Question:

Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?

a. A

b. B

c. C

d. D

Question:

Which of the following options is not available on the Status bar?

a. Cell mode

b. Selection mode

c. End mode

d. Start mode

Question:

Which of the following is not true regarding naming a cell?

a. Names are case sensitive

b. A name can contain up to 255 characters

c. Names can contain uppercase and lowercase letters

d. Some keyboard characters can cause unexpected results if used in cell names

Question:

What is the option on the Document Inspector that finds the content type information?

a. Comments and Annotations

b. Headers and Footers

c. Document Properties and Personal Information

d. Hidden Rows and Columns

Question:

Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?

a. By selection

b. By corresponding field

c. By value field

d. By number field

Question:

State whether true or false:

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

a. True

b. False

Question:

Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

a. HLOOKUP

b. VLOOKUP

c. TRANSPOSE

d. None of the above

Question:

Which of the following methods would you follow to remove subtotals?

a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All

b. On the Data tab, in the Data Tools, select Remove Subtotals

c. Both a and b

d. None of the above

Question:

Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?

a. It selects all the cells in the worksheet

b. It selects a large range of cells in the worksheet

c. It selects non-adjacent cells in the worksheet

d. It selects an entire row in the worksheet

Question:

Which of the following is not true about an offline cube file?

a. It stores data in the form of an OLAP cube

b. The file format for an offline cube file is .CUE

c. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable

Question:

Which of the following options would you choose to clear a PivotChart report?

a. On the Analyze tab, in the Data group, click on Clear, and then click ‘Clear All’

b. On the Options tab, in the Actions group, click on Clear, and then click’ Clear All’

c. Both a and b

d. None of the above

Question:

State whether true or false:

Case-sensitive sorting of text in Excel2007 can be performed.

a. True

b. False

Question:

State whether true or false:

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

a. True

b. False

Question:

Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

a. Scoping by selection

b. Scoping by corresponding field

c. Scoping by value field

d. All of the above

Question:

State whether true or false:

If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

a. True

b. False

Question:

State whether true or false:

When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.

a. True

b. False

Question:

Which of the following is not true regarding column width?

a. If the column width is set to 0, the column is hidden

b. A column width between 0 to 255 can be specified

c. The default column width is 8.43 characters

d. All of the above are true

Question:

Where can the ‘Show All Comments’ command be found?

a. On the Page Layout tab

b. On the View tab

c. On the Review tab

d. All of the above

Question:

When does the triangle appear in the top-left corner of the cell, as shown in the picture?

a. When the cell contains hidden information

b. When the cell contains the Time function

c. When there is an error in the formula

d. None of the above

Question:

How should blank cells be inserted on a Worksheet?

a. Select the cell or the range of cells. Then on the Home tab, in the Cells group, click ‘Insert Cells’

b. Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu

c. Both a and b

d. None of the above

Question:

Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.

a. A

b. B

c. C

d. D

Question:

When would the data validation command be unavailable on the data tab?

a. When an Excel table is linked to a SharePoint site

b. When data in a cell is entered

c. When the workbook is shared or protected

d. All of the above

27Jun2013

English Spelling tet answer(us version)

by ratonpramanik

Question:Choose the correct spelling of the word from the options below.
a. Leiutenant
b. Luietenant
c. Lieutanent
d. Lieutenant (answer)

Question: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 (answer)
c. specifycally
d. specificly

Question: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 (answer)

Question:Identify the misspelt word in the list below.
a. Rhythmical
b. Reminiscence
c. Rheumatism
d. Resevoir (answer)

Question:Complete the following sentence by choosing the correct spelling of the missing word.
After my grandfather was diagnosed with chronic_________, he moved to Spain.
a. Neumonia
b. Penumonia
c. Pneumonia (answer)
d. Pnuemonia

Question: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 (answer)
d. kindegarden

Question:Choose the correct spelling of the word from the options below.
a. Bureaucrasy
b. Buroucracy
c. Bureaucracy (answer)
d. Beuraucracy

Question:Complete the following sentence by choosing the correct spelling of the missing word.
Their relationship was plagued by __________ problems.
a. perpetual (answer)
b. perpechual
c. purpetual
d. perptual

Question: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 sausages.
a. barbecue (answer)
b. barbequeue
c. barbycue
d. barbcue

Question:Choose the correct spelling of the word from the options below.
a. Hienous
b. Henous
c. Heinus
d. Heinous (answer)

Question:Identify the misspelt word in the list below.
a. Quixotic
b. Quite
c. Questionaire (answer)
d. Quarantine

Question:Identify the misspelt word in the list below.
a. Dexterity
b. Desicate (answer)
c. Dyeing
d. Desecrate

Question:Identify the misspelt word in the list below.
a. Councelor (answer)
b. Condescend
c. Camouflage
d. Criticise

Question:Identify the misspelt word in the list below.
a. Fluorescent
b. Fullfill (answer)
c. Facsimile
d. Fictitious

Question:Complete the following sentence by choosing the correct spelling of the missing word.
_________animals feed almost exclusively on meat.
a. Carnivorus
b. Carnivorous (answer)
c. Carnivoures
d. Carnivoreus

Question:Identify the misspelt word in the list below.
a. Weird (answer)
b. Wired
c. Whined
d. Wilful

Question:Choose the correct spelling of the word from the options below.
a. Definitly
b. Definately
c. Defenitely
d. Definitely (answer)

Question:Choose the correct spelling of the word from the options below.
a. Forfiet
b. Forfeit (answer)
c. Forefeit
d. Fourfit

Question:Choose the correct spelling of the word from the options below.
a. Neccesary
b. Necessary (answer)
c. Neccessary
d. Necesary

Question:Choose the correct spelling of the word from the options below.
a. Priveledge
b. Privilage
c. Privilege (answer)
d. Privelege

Question: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 (answer)
b. existance
c. existense
d. existanse

Question: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 (answer)
b. diminuative
c. deminutive
d. diminutive

Question:Choose the correct spelling of the word from the options below.
a. Manoeuvre (answer)
b. Manouver
c. Maneuver
d. Manuver

Question:Choose the correct spelling of the word from the options below.
a. Unanimus
b. Unanemous
c. Unanimess
d. Unanimous (answer)

Question:Choose the correct spelling of the word from the options below.
a. Excesive
b. Exccesive
c. Excessive (answer)
d. Exceesive

Question:Choose the correct spelling of the word from the options below.
a. Restaureter
b. Restauranter
c. Restaurateur (answer)
d. Restourateur

Question:Identify the misspelt word in the list below.
a. Mischeivous (answer)
b. Misanthrope
c. Mussel
d. Malicious

Question:Identify the misspelt word in the list below.
a. Sophomore
b. Supersede
c. Susceptable (answer)
d. Spontaneous

Question:Identify the misspelt word in the list below.
a. Haemorrhage
b. Harass
c. Hankerchief (answer)
d. Hypocrisy

Question:Choose the correct spelling of the word from the options below.
a. Temperamental (answer)
b. Tempermental
c. Temperamentle
d. Temparamental

Question: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 (answer)
b. plagiarizm
c. plagerism
d. plagirism

Question:Choose the correct spelling of the word from the options below.
a. Ligitimate
b. Legitimate (answer)
c. Legetimate
d. Legitemate

Question:Identify the misspelt word in the list below.
a. Yacht
b. Youthful
c. Yeilding (answer)
d. Yesterday

Question:Choose the correct spelling of the word from the options below.
a. Persue
b. Parsue
c. Persou
d. Pursue (answer)

Question: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 (answer)
b. amnasty
c. anmesty
d. emnesty

Question:Choose the correct spelling of the word from the options below.
a. Gauge (answer)
b. Gaje
c. Guage
d. Gaige

Question:Identify the misspelt word in the list below.
a. Develop
b. Desciple (answer)
c. Dilemma
d. Discipline

Question:Choose the correct spelling of the word from the options below.
a. Adress
b. Addrress
c. Addres
d. Address (answer)

Question:Complete the following sentence by choosing the correct spelling of the missing word.
No one knew what devious experiments the scientist conducted in his ______________ .
a. labretory
b. laboratary
c. laboratory (answer)
d. labratory

Question:Choose the correct spelling of the word from the options below.
a. Embarassment
b. Embrassement
c. Embarrasment
d. Embarrassment (answer)

Question:Choose the correct spelling of the word from the options below.
a. Definitly
b. Definately
c. Defenitely
d. Definitely (answer)
Question:Choose the correct spelling of the word from the options below.
a. Gauge (answer)
b. Gaje
c. Guage
d. Gaige

Question:Identify the misspelt word in the list below.
a. Councelor (answer)
b. Condescend
c. Camouflage
d. Criticise

Question:Identify the misspelt word in the list below.
a. Parallel
b. Prevalent
c. Prejudice
d. Perserverance (answer)

Question:Complete the following sentence by choosing the correct spelling of the missing word.
Sally’s nervous __________ left her standing at the altar.
a. fiance
b. finance (answer)
c. feance
d. fience

Question: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 (answer)
c. liasone
d. leason

Question:Choose the correct spelling of the word from the options below.
a. Adress
b. Addrress
c. Addres
d. Address (answer)

Question:Complete the following sentence by choosing the correct spelling of the missing word.
Hazel Dormouse is a _________ creature.
a. nocternal
b. nocturnal (answer)
c. noctarnal
d. nacturnal

Question:Choose the correct spelling of the word from the options below.
a. Forfiet
b. Forfeit (answer)
c. Forefeit
d. Fourfit

Question: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 (answer)
d. sacrilgious

Question:Choose the correct spelling of the word from the options below.
a. Vengeance (answer)
b. Vengance
c. Vengents
d. Vengence

Question:Choose the correct spelling of the word from the options below.
a. Priveledge
b. Privilage
c. Privilege (answer)
d. Privelege

Question:Identify the misspelt word in the list below.
a. Rhythmical
b. Reminiscence
c. Rheumatism
d. Resevoir (answer)

Question: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 (answer)
c. vicoius
d. vicius

Question:Identify the misspelt word in the list below.
a. Sophomore
b. Supersede
c. Susceptable (answer)
d. Spontaneous

Question:Choose the correct spelling of the word from the options below.
a. Synonymous (answer)
b. Synonymus
c. Synonimous
d. Sinonymus

Question:Choose the correct spelling of the word from the options below.
a. Idiosyncracy
b. Idiosincrasy
c. Idiosyncrasy (answer)
d. Ideosyncracy

Question:Identify the misspelt word in the list below.
a. Pageant
b. Poignant
c. Plummage (answer)
d. Priggish

Question:Choose the correct spelling of the word from the options below.
a. Manoeuvre (answer)
b. Manouver
c. Maneuver
d. Manuver
Question:

Choose the correct spelling of the word from the options below.
a. Bureaucrasy
b. Buroucracy
c. Bureaucracy (answer)
d. Beuraucracy

Question:Choose the correct spelling of the word from the options below.
a. Pronounciation
b. Pronuciation
c. Pronuncitation
d. Pronunciation (answer)

Question:Choose the correct spelling of the word from the options below.
a. Excesive
b. Exccesive
c. Excessive (answer)
d. Exceesive

Question: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 whilst you’re away.
a. itenreray
b. itinerary (answer)
c. iteneray
d. itinirary

Question:Choose the correct spelling of the word from the options below.
a. Vacuum (answer)
b. Vaccuum
c. Vacumm
d. Vaccum

Question:Choose the correct spelling of the word from the options below.
a. Temperamental (answer)
b. Tempermental
c. Temperamentle
d. Temparamental

Question:Choose the correct spelling of the word from the options below.
a. Goverment
b. Governmant
c. Government (answer)
d. Govermant

Question:Complete the following sentence by choosing the correct spelling of the missing word.
The purpose of your report should be to ___________ the most relevant facts, not to obscure them.
a. illumenate
b. iluminate
c. illuminate (answer)
d. elluminate

Question:Identify the misspelt word in the list below.
a. Fluorescent
b. Fullfill (answer)
c. Facsimile
d. Fictitious

Question: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 (answer)
d. congratilated

Question:Choose the correct spelling of the word from the options below.
a. Ligitimate
b. Legitimate (answer)
c. Legetimate
d. Legitemate

Question: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 (answer)
c. lose
d. louse

Question:Choose the correct spelling of the word from the options below.
a. Conscentiuos
b. Consentious
c. Conscientous
d. Conscientious (answer)

Question:Choose the correct spelling of the word from the options below.
a. Neccesary
b. Necessary (answer)
c. Neccessary
d. Necesary

Question:Identify the misspelt word in the list below.
a. Develop
b. Desciple (answer)
c. Dilemma
d. Discipline

Question:Identify the misspelt word in the list below.
a. Accomodate (answer)
b. Analyse
c. Acknowledgement
d. Asterisk

Identify the misspelled word in the list below.

Parallel
Prevalent
Prejudice
Perserverance

Answer is: Perserverance

Question 2:

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

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

Fiancé
Finance
Feancé
Fience

Answer is: Finance

Question 3:

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

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

Architecture
Arkhitecture
Arcitecture
Arckitecture

Answer is: Architecture

Question 4:

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

Priveledge
Privilage
Privilege
Privelege

Answer is: Privilege

Question 5:

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.

Loose
Looze
Lose
Louse

Answer is: Lose

Question 6:

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

Ligitimate
Legitimate
Legetimate
Legitemate

Answer is: Legitimate

Question 7:

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

Peter always makes such a _____________ of himself!

Nuisance
Nuisents
Newsanse
Nuisince

Answer is: Nuisance

Question 8:

Identify the misspelled word in the list below.

Hemorrhage
Harass
Hankerchief
Hypocrisy

Answer is: Hankerchief

Question 9:

Identify the misspelled word in the list below.

Yacht
Youthful
Yeilding
Yesterday

Answer is: Yeilding

Question 10:

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

Embarassment
Embrassement
Embarrasment
Embarrassment

Answer is: Embarassment

Question 11:

Identify the misspelled word in the list below.

Occasion
Occurrence
Orangutan
Opponant

Answer is: Opponant

Question 12:

Identify the misspelled word in the list below.

Quixotic
Quite
Questionaire
Quarantine

Answer is: Questionaire

Question 13:

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

Adress
Addrress
Addres
Address

Answer is: Address

Question 14:

Identify the misspelled word in the list below.

Sophomore
Supersede
Susceptable
Spontaneous

Answer is: Susceptable

Question 15:

Identify the misspelled word in the list below.

Rhythmical
Reminiscence
Rheumatism
Resevoir

Answer is: Resevoir

Question 16:

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

Goverment
Governmant
Government
Govermant

Answer is: Government

Question 17:

Identify the misspelled word in the list below.

Cachet
Connoisseur
Charateristic
Catastrophe

Answer is: Charateristic

Question 18:

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

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

Illumenate
Iluminate
Illuminate
Elluminate

Answer is: Illuminate

Question 19:

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

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

Vicous
Vicious
Vicoius
Vicius

Answer is: Vicious

Question 20:

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

Neccesary
Necessary
Neccessary
Necesary

Answer is: Necessary

Question 21:

Identify the misspelled word in the list below.

Fluorescent
Fullfil
Facsimile
Fictitious

Answer is: Fullfil

Question 22:

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

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

Reincanation
Reincarenation
Reincarnation
Reincantation

Answer is: Reincarnation

Question 23:

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

Heinous
Henous
Heinus

Answer is: Heinous

Question 24:

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

The church members accused the cult of _______________ practices.

Sacreligious
Sacrelegious
Sacrilegious
Sacrilgious

Answer is: Sacrilegious

Question 25:

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.

Amnesty
Amnasty
Anmesty
Emnesty

Answer is: Amnesty

Question 26:

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.

Accquired
Ecquired
Acquired
Akquired

Answer is: Acquired

Question 27:

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

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

Dissapointing
Dissappointing
Disapointing
Disappointing

Answer is: Disappointing

Question 28:

Identify the misspelled word in the list below.

Managable
Millennium
Minuscule
Miscellaneous

Answer is: Managable

Question 29:

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

Excesive
Exccesive
Excessive
Exceesive

Answer is: Excessive

Question 30:

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.

Kindergarden
Kindegarten
Kindergarten
Kindegarden

Answer is: Kindergarten

Question 31:

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

Pronounciation
Pronuciation
Pronuncitation
Pronunciation

Answer is: Pronunciation

Question 32:

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

Leiutenant
Luietenant
Lieutanent
Lieutenant

Answer is: Lieutenant

Question 33:

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

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

Twelvth
Twelfth
Twelfeth
Twelth

Answer is: Twelfth

Question 34:

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

Their relationship was plagued by __________ problems.

Perpetual
Perpechual
Purpetual
Perptual

Answer is: Perpetual

Question 35:

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

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

Plagiarism
Plagiarizm
Plagerism
Plagirism

Answer is: Plagiarism

Question 36:

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

Efficency
Efficentsy
Efficiensy
Efficiency

Answer is: Efficiency

Question 37:

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

Temperamental
Tempermental
Temperamentle
Temparamental

Answer is: Temperamental

Question 38:

Identify the misspelled word in the list below.

Dexterity
Desicate
Dyeing
Desecrate

Answer is: Desicate

Question 39:

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

Sam _________ a successful political campaign.

Orchestraited
Orchestrated
Orchestreated
Orcestrated

Answer is: Orchestrated

Question 40:

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

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

Diminutive
Diminuative
Deminutive
Dimminutive

Answer is: Diminutive

Question 41:

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

Idiosyncracy
Idiosincrasy
Idiosyncrasy
Ideosyncracy

Answer is: Ideosyncracy

Question 42:

Identify the misspelled word in the list below.

Wierd
Wired
Whined
Willful

Answer is: Wierd

Question 43:

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

Bureaucrasy
Buroucracy
Bureaucracy
Beuraucracy

Answer is: Bureaucracy

Question 44:

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

No one knew what devious experiments the scientist conducted in his ______________ .

Labretory
Laboratary
Laboratory
Labratory

Answer is: Laboratory

Question 45:

Identify the misspelled word in the list below.

Mischeivous
Misanthrope
Mussel
Malicious

Answer is: Mischeivous

Question 46:

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

Unanimus
Unanemous
Unanimess
Unanimous

Answer is: Unanimous

Question 47:

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

After my grandfather was diagnosed with chronic_________, he moved to Arizona.

Neumonia
Penumonia
Pneumonia
Pnuemonia

Answer is: Pneumonia

Question 48:

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

Synonymous
Synonymus
Synonimous
Sinonymus

Answer is: Synonymous

Question 49:

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

Referense
Refrence
Reference
Referance

Answer is: Reference

Question 50:

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.

Specificaly
Specifically
Specifycally
Specificly

Answer is: Specifically

Question 51:

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

Restaureter
Restaurater
Restaurateur
Restourateur

Answer is: Restaurateur

Question 52:

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

Manoeuvar
Manouver
Maneuver
Manuver

Answer is: Maneuver

Question 53:

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

Vengeance
Vengance
Vengents
Vengence

Answer is: Vengeance

Question 54:

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

Vacuum
Vaccuum
Vacumm
Vaccum

Answer is: Vacuum

Question 55:

Identify the misspelled word in the list below.

Councelor
Condescend
Camouflage
Criticize

Answer is: Councelor

Question 56:

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

Gauge
Gaje
Guage
Gaige

Answer is: Gauge

Question 57:

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.

Barbecue
Barbequeue
Barbycue
Barbcue

Answer is: Barbecue

Question 58:

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

Hazel Dormouse is a _________ creature.

Nocternal
Nocturnal
Noctarnal
Nocturnal

Answer is: Nocturnal

Question 59:

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

Reminiscience
Reminiscence
Reminescence
Reminisense

Answer is: Reminiscence

Question 60:

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

Pshycology
Psycology
Psyhcology
Psychology

Answer is: Psychology

Question: 01

Identify the misspelled word in the list below.

a. Accomodate

b. Analyze

c. Acknowledgment

d. Asterisk

Question: 02

Identify the misspelled word in the list below.

a. Yacht

b. Youthful

c. Yeilding

d. Yesterday

Question: 03

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

Question: 04

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

a. Vacuum

b. Vaccuum

c. Vacumm

d. Vaccum

Question: 05

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

a. Manoeuvar

b. Manouver

c. Maneuver

d. Manuver

Question: 06

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

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

a. fiancé

b. finance

c. feancé

d. fience

Question: 07

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

Question: 08

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

Question: 09

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

Question: 10

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

_________animals feed almost exclusively on meat.

a. Carnivorus

b. Carnivorous

c. Carnivoures

d. Carnivoreus

Question: 11

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

a. Gauge

b. Gaje

c. Guage

d. Gaige

Question: 12

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

Question: 13

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

a. Efficency

b. Efficentsy

c. Efficiensy

d. Efficiency

Question: 14

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

a. Heinous

b. Henous

c. Heinus

Question: 15

Identify the misspelled word in the list below.

a. Stationery

b. Statutory

c. Sincerely

d. Sanctuery

Question: 16

Identify the misspelled word in the list below.

a. Parallel

b. Prevalent

c. Prejudice

d. Perserverance

Question: 17

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

a. Leiutenant

b. Luietenant

c. Lieutanent

d. Lieutenant

Question: 18

Identify the misspelled word in the list below.

a. Pageant

b. Poignant

c. Plummage

d. Priggish

Question: 19

Identify the misspelled word in the list below.

a. Quixotic

b. Quite

c. Questionaire

d. Quarantine

Question: 20

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

a. Adress

b. Addrress

c. Addres

d. Address

Question: 21

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

a. Reminiscience

b. Reminiscence

c. Reminescence

d. Reminisense

Question: 22

Identify the misspelled word in the list below.

a. Rhythmical

b. Reminiscence

c. Rheumatism

d. Resevoir

Question: 23

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

Question: 24

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

Question: 25

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

a. Temperamental

b. Tempermental

c. Temperamentle

d. Temparamental

Question: 26

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

Question: 27

Identify the misspelled word in the list below.

a. Cachet

b. Connoisseur

c. Charateristic

d. Catastrophe

Question: 28

Identify the misspelled word in the list below.

a. Wierd

b. Wired

c. Whined

d. Willful

Question: 29

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

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

a. twelvth

b. twelfth

c. twelfeth

d. twelth

Question: 30

Identify the misspelled word in the list below.

a. Enhancement

b. Elicit

c. Enegma

d. Ecstasy

Question: 31

Identify the misspelled word in the list below.

a. Sophomore

b. Supersede

c. Susceptable

d. Spontaneou

Question: 32

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

Question: 33

Identify the misspelled word in the list below.

a. Dexterity

b. Desicate

c. Dyeing

d. Desecrate

Question: 34

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

Question: 35

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

Question: 36

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

Question: 37

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

Question: 38

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

a. Forfiet

b. Forfeit

c. Forefeit

d. Fourfit

Question: 39

Identify the misspelled word in the list below.

a. Fluorescent

b. Fullfil

c. Facsimile

d. Fictitious

Question: 40

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

Question 1:
Identify the misspelled word in the list below.

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

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

Sally’s nervous __________ left her standing at the altar.
a.     fiancé
b.     finance
c.     feancé
d.     fience
Answer: b. finance

Question 3:
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
Answer: a. architecture

Question 4:
Choose the correct spelling of the word from the options below.
a.     Priveledge
b.     Privilage
c.     Privilege
d.     Privelege
Answer: c. Privilege

Question 5:
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
Answer: c. lose

Question 6:
Choose the correct spelling of the word from the options below.
a.     Ligitimate
b.     Legitimate
c.     Legetimate
d.     Legitemate
Answer: b. Legitimate

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

Question 8:
Identify the misspelled word in the list below.
a.     Hemorrhage
b.     Harass
c.     Hankerchief
d.     Hypocrisy
Answer: c. Hankerchief

Question 9:
Identify the misspelled word in the list below.
a.     Yacht
b.     Youthful
c.     Yeilding
d.     Yesterday
Answer: c Yeilding

Question 10:
Choose the correct spelling of the word from the options below.
a.     Embarassment
b.     Embrassement
c.     Embarrasment
d.     Embarrassment
Answer: a. Embarassment
Question 11:
Identify the misspelled word in the list below.
a.     Occasion
b.     Occurrence
c.     Orangutan
d.     Opponant
Answer: d. Opponant

Question 12:
Identify the misspelled word in the list below.
a.     Quixotic
b.     Quite
c.     Questionaire
d.     Quarantine
Answer: c. Questionaire

Question 13:
Choose the correct spelling of the word from the options below.
a.     Adress
b.     Addrress
c.     Addres
d.     Address
Answer: d. Address

Question 14:
Identify the misspelled word in the list below.
a.     Sophomore
b.     Supersede
c.     Susceptable
d.     Spontaneous
Answer: c. Susceptable

Question 15:
Identify the misspelled word in the list below.
a.     Rhythmical
b.     Reminiscence
c.     Rheumatism
d.     Resevoir
Answer: d. Resevoir

Question 16:
Choose the correct spelling of the word from the options below.
a.     Goverment
b.     Governmant
c.     Government
d.     Govermant
Answer: c. Government

Question 17:
Identify the misspelled word in the list below.
a.     Cachet
b.     Connoisseur
c.     Charateristic
d.     Catastrophe
Answer: c. Charateristic

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

The purpose of your report should be to ___________ the most relevant facts, not to obscure them.
a.     illumenate
b.     iluminate
c.     illuminate
d.     elluminate
Answer: c. illuminate

Question 19:
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
Answer: b. vicious

Question 20:
Choose the correct spelling of the word from the options below.
a.     Neccesary
b.     Necessary
c.     Neccessary
d.     Necesary
Answer: b. Necessary

Question 21:
Identify the misspelled word in the list below.
a.     Fluorescent
b.     Fullfil
c.     Facsimile
d.     Fictitious
Answer: b. Fullfil

Question 22:
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
Answer: c. reincarnation

Question 23:
Choose the correct spelling of the word from the options below.
a.     Heinous
b.     Henous
c.     Heinus
Answer: a. Heinous

Question 24:
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
Answer: c. sacrilegious

Question 25:
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
Answer: a. amnesty

Question 26:
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
Answer: c. acquired

Question 27:
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
Answer: d. disappointing

Question 28:
Identify the misspelled word in the list below.
a.     Managable
b.     Millennium
c.     Minuscule
d.     Miscellaneous
Answer: a. Managable

Question 29:
Choose the correct spelling of the word from the options below.
a.     Excesive
b.     Exccesive
c.     Excessive
d.     Exceesive
Answer: c. Excessive

Question 30:
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
Answer: c. kindergarten

Question 31:
Choose the correct spelling of the word from the options below.
a.     Pronounciation
b.     Pronuciation
c.     Pronuncitation
d.     Pronunciation
Answer: d. Pronunciation

Question 32:
Choose the correct spelling of the word from the options below.
a.     Leiutenant
b.     Luietenant
c.     Lieutanent
d.     Lieutenant
Answer: d. Lieutenant

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

On the ____________ day of Christmas, Lucy was annoyed to find her yard full of noisy drummers drumming.
a.     twelvth
b.     twelfth
c.     twelfeth
d.     twelth
Answer: b. twelfth

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

Their relationship was plagued by __________ problems.
a.     perpetual
b.     perpechual
c.     purpetual
d.     perptual
Answer: a. perpetual

Question 35:
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
Answer: a. plagiarism

Question 36:
Choose the correct spelling of the word from the options below.
a.     Efficency
b.     Efficentsy
c.     Efficiensy
d.     Efficiency
Answer: d. Efficiency

Question 37:
Choose the correct spelling of the word from the options below.
a.     Temperamental
b.     Tempermental
c.     Temperamentle
d.     Temparamental
Answer: a. Temperamental
Question 38:
Identify the misspelled word in the list below.
a.     Dexterity
b.     Desicate
c.     Dyeing
d.     Desecrate
Answer: b. Desicate

Question 39:
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
Answer: b. orchestrated

Question 40:
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
Answer: a. diminutive

Question 41:
Choose the correct spelling of the word from the options below.
a.     Idiosyncracy
b.     Idiosincrasy
c.     Idiosyncrasy
d.     Ideosyncracy
Answer: c. Ideosyncracy

Question 42:
Identify the misspelled word in the list below.
a.         Wierd
b.         Wired
c.         Whined
d.         Willful
Answer: a. Wierd

Question 43:
Choose the correct spelling of the word from the options below.
a.         Bureaucrasy
b.         Buroucracy
c.         Bureaucracy
d.         Beuraucracy
Answer: c. Bureaucracy

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

No one knew what devious experiments the scientist conducted in his ______________ .
a.         labretory
b.         laboratary
c.         laboratory
d.         labratory
Answer: c. laboratory

Question 45:
Identify the misspelled word in the list below.
a.         Mischeivous
b.         Misanthrope
c.         Mussel
d.         Malicious
Answer: a. Mischeivous

Question 46:
Choose the correct spelling of the word from the options below.
a.         Unanimus
b.         Unanemous
c.         Unanimess
d.         Unanimous
Answer: d. Unanimous

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

After my grandfather was diagnosed with chronic_________, he moved to Arizona.
a.         Neumonia
b.         Penumonia
c.         Pneumonia
d.         Pnuemonia
Answer: c. Pneumonia

Question 48:
Choose the correct spelling of the word from the options below.
a.         Synonymous
b.         Synonymus
c.         Synonimous
d.         Sinonymus

Answer: a. Synonymous
Question 49:
Choose the correct spelling of the word from the options below.
a.         Referense
b.         Refrence
c.         Reference
d.         Referance
Answer: c. Reference

Question 50:
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
Answer: b. specifically

Question 51:
Choose the correct spelling of the word from the options below.
a.         Restaureter
b.         Restaurater
c.         Restaurateur
d.         Restourateur
Answer: c. Restaurateur

Question 52:
Choose the correct spelling of the word from the options below.
a.         Manoeuvar
b.         Manouver
c.         Maneuver
d.         Manuver
Answer: c. Maneuver

Question 53:
Choose the correct spelling of the word from the options below.
a.         Vengeance
b.         Vengance
c.         Vengents
d.         Vengence
Answer: a. Vengeance

Question 54:
Choose the correct spelling of the word from the options below.
a.         Vacuum
b.         Vaccuum
c.         Vacumm
d.         Vaccum
Answer: a. Vacuum

Question 55:
Identify the misspelled word in the list below.
a.         Councelor
b.         Condescend
c.         Camouflage
d.         Criticize
Answer: a. Councelor

Question 56:
Choose the correct spelling of the word from the options below.
a.         Gauge
b.         Gaje
c.         Guage
d.         Gaige
Answer: a. Gauge

Question 57:
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
Answer: a. barbecue

Question 58:
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.         nocturnal
Answer: b. nocturnal

Question 59:
Choose the correct spelling of the word from the options below.
a.         Reminiscience
b.         Reminiscence
c.         Reminescence
d.         Reminisense
Answer: b. Reminiscence

Question 60:
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
Answer: d. psychology