Use any one of these examples in your next cover letter to attract quality job
interviews like a magnet. For maximum effect, use my suggested Best Location
for each example.
1. I am excited about the possibility of a personal interview to further discuss
my qualifications with you. I am immediately available and can be
reached at 555-555-5555. I will follow up with a phone
call as well to make sure you have received my
application. Best Location: Use this example as the
final paragraph in your cover letter for best results.
2. I would love the opportunity to interview in person for
the position of (insert job opening title here). Thank you in advance for
your consideration. Best Location: Use this example as a headline at the
top of your letter using centered and bold text.
3. If possible, can we schedule an interview in the next two weeks? I have
researched (company name) and am excited about this opportunity. I
would love the chance to interview for this position and am available at
your earliest convenience. Best Location: This example is best utilized as
a final paragraph in your cover letter, as well.
4. If I may be so bold, I am asking you for the opportunity to interview for
(insert job opening title here). I would like the chance in person, to discuss
the specific reasons why I believe I am the applicant you are looking for.
Best Location: If you are bold enough this works best as an excellent
final paragraph.
5. If you will grant me an interview for (insert job opening title here), I feel
confident that when we meet and speak together you’ll see why I believe
I’m the right person for this job. I can be reached at 555-555-5555. Thank
you in advance. Best Location: This example is best when used as the
final paragraph in your cover letter.
test question and Answers like html css php seo ,Jacascript, cover letters,joomla wordpress
sexta-feira, 1 de abril de 2011
Search Engine Optimization Test Solution
Question
Which of the following can be termed as a good keyword selection and placement strategies?
a* Targeting synonyms of the main keyword (ans) A & D
b.Targeting the highest searched keywords only
c.Copying competitor keywords
d.Optimizing 5 or more keywords per page
Ans: D
Question
Which blackhat Seo techniques is characterized by a method to decieve search engine, by detecting the search engine bot and "feeding" it with a different HTML code than the HTML actually served to users?
a.Coaling
b.Foisting
c.Slighting
d.Cloaking
Ans: D
Why is it bad idea from SEO perspective to host free articles and write ups that are very common on the internet?
a.Because they will not lead to fresh traffic
b.Because you could be penalize by search engine for using duplicate contents (ans)
c.Because you will not get the benefits of proper keyword targeting
d.because people could turn up claiming copyright infirigement
Ans: B
What will happen if you type the word 'Certification-Networking' in the google search box?
a.Google will find the web pages about "certification" and also containing the word "networking"
b.Google will find ALL the web pages containing the word word "Certification" and "Networking"
c.*Google will find ALL the web pages in which the words "Certification" and "Networking" appear together. (ans)
d.Google will find the web pages about Certification that do not contain the word Networking
Ans: C
Which of the following factors does google take into account while accessing whether or not a website is an authority website?
a. The frequency with which the contents of the website is updated
b. the number of web pages containing relevant information on the main theme of the website
c.*The number of in-bound natural links related to the website's theme (or keywords)
d. None of the above
ans: C
What is keyword density?
a.The number of times the keyword is used / (divided by) the total word count on page - (minus) the total words in HTML on the page
b.The number of times the keyword is used x (multiply by) the total word count on page.
c.The number of times the keyword is used in the page description
d.The number of times the keyword is used in the page title
e*The number of times the keyword is used / (divided by) the total word count on the page. (ans)
Ans: E
Which of the following statement about FFA pages are true?
a.They are greatly beneficial to SEO
b.They are also called Link Farms
c.They are Paid Listings
d*They contain numerous inbound links
Ans: B
What is the illegal act of copying of a page by unauthorized parties in order to filter off traffic to another site called?
a.Traffic jacking
b.Visitors Jacking
c.View Jacking
d* Page Jacking
Ans: D
What is the most likely time period required for getting a google page ranking?
a.1 week
b. 3 weeks
c. 1 month
d.* More than 3 months
ans: D
question
Some words, when followed by a colon, have special meanings to yahoo. What is perfermed by the link:Operator?
a. it shows all the outbound links from the url
b. It shows how many pages of the site yahoo is pointing to
c. It shows all the pages that point to that url
d. It show url's with broken links
Ans: C
Which of the following can be termed as a good keyword selection and placement strategies?
a* Targeting synonyms of the main keyword (ans) A & D
b.Targeting the highest searched keywords only
c.Copying competitor keywords
d.Optimizing 5 or more keywords per page
Ans: D
Question
Which blackhat Seo techniques is characterized by a method to decieve search engine, by detecting the search engine bot and "feeding" it with a different HTML code than the HTML actually served to users?
a.Coaling
b.Foisting
c.Slighting
d.Cloaking
Ans: D
Why is it bad idea from SEO perspective to host free articles and write ups that are very common on the internet?
a.Because they will not lead to fresh traffic
b.Because you could be penalize by search engine for using duplicate contents (ans)
c.Because you will not get the benefits of proper keyword targeting
d.because people could turn up claiming copyright infirigement
Ans: B
What will happen if you type the word 'Certification-Networking' in the google search box?
a.Google will find the web pages about "certification" and also containing the word "networking"
b.Google will find ALL the web pages containing the word word "Certification" and "Networking"
c.*Google will find ALL the web pages in which the words "Certification" and "Networking" appear together. (ans)
d.Google will find the web pages about Certification that do not contain the word Networking
Ans: C
Which of the following factors does google take into account while accessing whether or not a website is an authority website?
a. The frequency with which the contents of the website is updated
b. the number of web pages containing relevant information on the main theme of the website
c.*The number of in-bound natural links related to the website's theme (or keywords)
d. None of the above
ans: C
What is keyword density?
a.The number of times the keyword is used / (divided by) the total word count on page - (minus) the total words in HTML on the page
b.The number of times the keyword is used x (multiply by) the total word count on page.
c.The number of times the keyword is used in the page description
d.The number of times the keyword is used in the page title
e*The number of times the keyword is used / (divided by) the total word count on the page. (ans)
Ans: E
Which of the following statement about FFA pages are true?
a.They are greatly beneficial to SEO
b.They are also called Link Farms
c.They are Paid Listings
d*They contain numerous inbound links
Ans: B
What is the illegal act of copying of a page by unauthorized parties in order to filter off traffic to another site called?
a.Traffic jacking
b.Visitors Jacking
c.View Jacking
d* Page Jacking
Ans: D
What is the most likely time period required for getting a google page ranking?
a.1 week
b. 3 weeks
c. 1 month
d.* More than 3 months
ans: D
question
Some words, when followed by a colon, have special meanings to yahoo. What is perfermed by the link:Operator?
a. it shows all the outbound links from the url
b. It shows how many pages of the site yahoo is pointing to
c. It shows all the pages that point to that url
d. It show url's with broken links
Ans: C
Odesk Wordpress Test Solutions
Question:
What is the function of Widgets in Wordpress?
· It is used to display the site in proper design
· It is used to create a sitemap of the sit e
· It is used to add additional components to the site
· It helps in easy and fast searching
Question:
You want to show the number of spam comments that have been caught by the akismet ? . Which of the following code is used to display the statistics in the wordpress.org version 2.5.1?
·
·
·
·
·
· Question
From Which section in the Wordpress admin can you add a calendar to your website /
· Themes sections
· Manage sections
· Plug-in sections
· Widgets section
· None of the above
Question
How can you hook a new function into the wordpress.org version 2.5.1?
· Add_action(“hook_name’,your_funtion’,[priority,][accepted-args]);
· Add_action(“your_funtion_name’,hook_name’[priority],[accepted_args];
· New functions can’t be hooked
· None of the above
Question
From which of the following blog sites does Wordpress provide the feature to import posts?
· Blogger
· Live journal
· Technorati
· Wordpress
Question
Under the admin manage section of the wordpresss.org version 2.5.1, you can ___?
· Manage user roles
· Manage topic categories and tags
· Manage theme templates
· Manage published and unpublished post
Question
What is the purpose of the meta Widget in Wordpress?
· To show meta –tag information about the website
· To show the log in and logout menus
· To show the admin page link
· To handle Rss Feeds
Questions
Which type of media files can be uploaded to wordpress.com
· .Wma
· .jpg
· .odt
· .doc
Question
In which file do you specify the database name in the wordpress.org version 2.5.1?
· Wp-config-sample.php
· Wp-config.php
· Wp-index.php
· Wp-index-sample.php
· Wp-setting.php
Question
In wordpress.com you can add third party plugins to your blogs.
· True
· False
Questions
In wordpess akismet falls under the category of ___?
· Themes
· Widgets
· Plugins
· Permalinks
· None of the above
Question
In wordpeess.org 2.5.1 the sidebar is under to display __
· Widgets
· Plugins
· User profiles
· None of the above
Answers will be on the blog shortly
Cover letter Sample
Dear Hiring Manager ,
Good Day
I’m interested in the position of "job name here " you recently posted. I have been a working as (your position ) for (no of year) years, and am very familiar with Wordpress and joomla. During my "no of year" years as "position" in "your company ", I managed a couple of websites . You can see some of my own writing in my portfolio
http://example.com
http://example.com
http://example.com
http://example.com
“You had mentioned that you were looking for someone with a background in "background of job". I studied it in college, where I majored in Computer Science .
“Moving forward, I can dedicate "no of availabe hour" hours/week to your company, and my daily hours are negotiable. I’m very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further.”
my skype id : "Your skype Id"
Regards,
"Your Name"
Good Day
I’m interested in the position of "job name here " you recently posted. I have been a working as (your position ) for (no of year) years, and am very familiar with Wordpress and joomla. During my "no of year" years as "position" in "your company ", I managed a couple of websites . You can see some of my own writing in my portfolio
http://example.com
http://example.com
http://example.com
http://example.com
“You had mentioned that you were looking for someone with a background in "background of job". I studied it in college, where I majored in Computer Science .
“Moving forward, I can dedicate "no of availabe hour" hours/week to your company, and my daily hours are negotiable. I’m very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further.”
my skype id : "Your skype Id"
Regards,
"Your Name"
Joomla Odesk Test Solutions
The index.php file is a combination of HTML and PHP code.
Odesk test answer: True
What is the default super administrator account for Joomla called?
Odesk test answer: Administrator
Which of the following PHP directives are important to Joomla execution to define an alternate compression library if the standard library is not available?
Odesk test answer: extension_dir
Which of the following files is archive and contains the actual CB component that you must install into Joomla while downloading CB?
Odesk test answer: com_comprofiler
Which option will you choose to set the site metadata for the installed website?
Odesk test answer: Global Configuration
What will happen if we set the SSL enabled option to On?
Odesk test answer: This option will make the link from the menu begin with an https://
The core editor events apply to plug-ins that provide editor functionality such as TinyMCE or XStandard Lite.
Odesk test answer: True
Which PHP file does the index.php file load to provide the menu bar to the administrator interface?
Odesk test answer: Toolbar.php
Which of the given database systems is supported by Joomla?
Odesk test answer: Mysql
Which of the following is the default editor of Joomla?
Odesk test answer: TinyMCE
Joomla provides an abstracted method called getEscaped() that returns the escaped string regardless of the target database.
Odesk test answer: False
From which package are the classes (i.e JSite, JAdministrator and JInstallation) which make up the Joomla CMS application extended?
Odesk test answer: Installer
What is not true about JoomlaXplorer?
Odesk test answer: None of the above
Which of the following is a system event?
Odesk test answer: OnDisplay
Which Joomla file provides the central logic of the template, including any module and component display?
Odesk test answer: Index.php
When will you use SMTP authentication mail settings?
Odesk test answer: When you want to use an internal mail server
What do you understand by the type of error?
Odesk test answer: It means that STRICT_ALL_TABLES is enabled
Which path variable holds the path of the currently executing application?
Odesk test answer: All of the above
Which user events occur with plug-ins that are installed for the front end of the system?
Odesk test answer: Both a and b
Which type of positioning elements define a concrete area such as a p, td, div or table in a CSS file?
Odesk test answer: Block elements
Which of the following files does the "/includes" directory not contain?
Odesk test answer: None of the above
Which option will you select to install or to add the module to your website?
Odesk test answer: C
Why does Joomla use templateDetails.xml files?
Odesk test answer: All of the above
Which of the following events is activated after content rendering is complete for content type plug-ins?
Odesk test answer: OnAfterDisplayContent
All the Joomla settings are contained within a PHP class called JConfig.
Odesk test answer: True
In which PHP file is the central configuration data for Joomla contained?
Odesk test answer: configuration.php
What is not true about the MD5 hash value?
Odesk test answer: Each password in Joomla is stored as a MD5 hash value
There are two root classes for the Joomla framework: JFactory and JVersion.
Odesk test answer: True
Which option will you select to find unpublished articles?
Odesk test answer: Article manager
What do you understand from the following code?
Odesk test answer: SQL statement is executed against the Joomla database to find empty data fields
Which SEO settings will you activate to make Joomla article URL shown in picture A appear as shown in picture B?
Odesk test answer: B
In which option are errors, warnings and references logged?
Odesk test answer: None of the above
Which type of files can media manager not upload?
Odesk test answer: None of the above
Which among the following switches display the current version of PHP?
Odesk test answer: -v
The Joomap extension uses the style-sheets from the currently selected default template to display the sitemap in the site style.
Odesk test answer: True
Which type of server technology is used by Joomla?
Odesk test answer: All of the above
Which of the following is not true about the FrontPage Manager?
Odesk test answer: You cannot select your content for the FrontPage from all the contents
What happens if the Text Separator Field is left empty while using the breadcrumbs module in the module manager?
Odesk test answer: None of the above
Which of the following support libraries must you include when you are doing a manual compile of PHP to use with Joomla?
Odesk test answer: All of the above
What is the role of the template metadata file in the system?
Odesk test answer: It contains the basic authorship information
odesk Php Test Solution part 1
Question 1
The setrawcookie() method of setting cookie is different from php standard method of cookie setting as :
- It does not allow expiry time to be set
- It can be used only once
- It does not url- ENCODE the value on its own
- It does not allow domain setting
Ans: C
Question 2
IF visibility is not defined for a method /member then it is treated as public static.
- True
- False
Ans: B
Question 3
Which of the following is not a valid php connection status?
- Aborted
- Normal
- Open
- Timeout
Ans: C
Question 4
Which of the following statements is not true with regard to abstract classes in php5?
- Abstract classes are introduced in php 5
- A class with a single abstract method must be declared abstract
- Abstract class can contain abstract methods
- Abstract method must have method definition and can have optional empty braces following it
Ans : C
Question 5
What will be the result of following operation?
Print 4<<5;
a. 3
b. 128
c. 120
d. 6
Ans: B
Question 6
Which of the following type cast in not correct?
$fig=23;
$varbl=(real)$fig;
$varb2=(double)$fig;
$varb3=(decimal)$fig;
$varb4=(bool)$fig;
?>
- real
- double
- decimal
- Boolean
Ans: C
Question 7
What is the result of the following expression?
5+2*4+6
- 70
- 19
- 34
- 21
Ans: B
Question 8
The classes are defined as follows
Abstract class BaseCls(
Protected abstract function getName();
}
Class childCls extends BaseCls{
}
Which of the following implementations of getName() in invalid in childCls?
a. Protected function getName(){}
b. Function getName(){}
c. Private function getName(){}
d. Public function getName(){}
Ans: D
Question 9
Multiple select/load is possible with:
- checkbox
- select
- file
- all of the above
Ans : A
Question 10
State whether true or false
Paamayim nekudotayim operator allows access only to the static members of a class?
a. True
b. False
Ans: A
Question 11
What is the output of the following code?
$a=500;
$b=200;
echo $a % 2 * $b;
?>
- 100
- 200
- 500
- 0
- Syntax error
Ans: D
Question 12
You need to heck the size of a file in php function .
$size=X(filename);
which function will suitable replace “X”?
- Filesize
- Size
- sizeofFile
- getSize
Ans: A
Question 14
Which of the following is not true for a persistent connection?
- these are not closed even after the execution of the script
- these are mainly used to increase the efficiency of the system
- These can’t be converted to non-persistent connections
- These are preferable not used in the scripts involving transactions
Ans: D
Question 15
Which one is correct?
- $s=fwrite(“a string here”);
- $s=fwrite($fp,”a string here”);
- $s=fwrite(“a string here ”,$fp);
- none of the above
Ans B
Question 16
Which of the following in not a correct way of printing text in php 5
a.
echo “plain text”
?>
b.
c.
d. <#
echo “plain text”
#>
Ans: C
Question 17
Which will be the output of the following code?
$a=0.0;
For($i=0;$i<10;$i++)
$a+=0.1;
print “$a\n”;
if ($a==1.0)
print “equals”;
else
print “not equals”;
?>
- 0.9
Not Equals
- 1
Equals
- 1
not Equals
- 1.1
Ans: C
Question 18
Which of the following attribute is needed for file upload via form?
- Enctype=”multipart/form-date”
- Enctype=”singlepart/date”
- Enctype=”file”
- Enctype=”form-data/file”
Ans: A
Question 19
Late php versions support remote file accessing for the functions:
- Include()
- Include_once()
- Require_once()
- All of the above
Ans : D
Question 20
Given below is a small php script:
class person {
function getSal()
{
……
……
}
}
class emp extends person {
fucniton getSal()
{
???
}
}
?>
the getSal() of emp has to behave exacltyle as getSal() of person . Which of the following lines of code would you use to replace the “???”?
- Parent:: getSal();
- Person::getSal();
- Parent::getsal;
- Person::getSal;
Ans: A
Odesk Css Test Solution Part 2
Question 21:
The default value for the overflow property is:
- Scroll
- Visible
- Hidden
- Auto
Question 22:
Which of the following will set the page size to 8.5 inches x 11 inches with 2cm margin al all sides?
- @page {width:8.5in;Height:11in; margin:2cm}
- @page {width:8.5in x 11in; margin:2cm}
- @page {size:8.5in 11in; margin:2cm}
- @page {size:8.5in 11in; margin:2cm}
Question 23:
Which of the following is not a valid list property?
- List-style-type
- List-style-position
- List-style-image
- List-style-align
Question 24:
Which of the following is not a pseudo class?
a. Link
b. Active
c. Lang
d. Ins
Question 25:
Which of the following Statement is correct?
- When using css, positioning can be absolute, relative or dynamic
- The float Property for text/images can be left, right or center
- The values of visibility can be true or False
- The display Property sets how an element is displayed
Question 26:
The Font “Times New Roman” has an aspect value of 0.46 .What do you understand from this?
- When font size is set to 46px. The height of the letter ‘x’ will be 100px
- When font size is set to 100px. The height of the letter ‘x’ will be 46px
Question 27:
The font-family property is used to specify a:
- Family name
- Generic Family
- Family name and /or generic Family
Question 28:
Paged media differ from continuous media in that the content of the document is divided into one or more pages. When you set the dimensions, which of the following will be applied?
- The dimensions of the page area are the dimensions of the page box minus the margin area
- The dimensions of the page area are the dimensions of the page box plus the margin area
- The dimensions of the page area are the dimensions of the page box and margin area does not affect it.
- None of the above
Question 29:
Which of the following is not a correct keyword value for the display property?
a. Expended
b. Inline-table
c. Table-row
d. Table-column-group
Question 30
Which of the following properties specifies the minimum number of lines of a paragraph that must be left at the bottom of a page?
- Orphans
- Widows
- Bottom
- Overflow
- None of the above
Question 31
Which of the following is correct with regard to comments in a style sheet?
- Comments can appear outside the style definition only
- Comments start with//
- Comments end with */
- Comments are not permitted in a style sheet
Question 32
Which of the following border styles is not correct?
a. Border-style: ridge
b. Border-style : outset
c. Border-style : dotted
d. Border – style : matted
Question 33
How will you display text as a superscript?
- Vertical-align: super
- Vertical-align: superscript
- Vertical-align : top
Question 34
The following is a style definition:
#styl2
{
Color: red;
}
How will you refer to this style in you web pages?
- By using the class attribute in a td cell
- By using the id attribute in a td cell
- By using the class attribute in any html element which supports the class attribute
- By using the id attribute in any html element which supports the id attribute.
Question 35
Which of the following is true for an ID selector?
- It uses a dot as the separator symbol
- It applies the style to only the first element defined with that selector
- It applies the style to only the last elements defined with that selector
- It applies the style to all the elements defined with that selector
Question 36
Which of the following values are correct for Font-style?
- Normal, wider, narrower
- Normal , italic, oblique
- Normal, bold, lighter
- Small , medium , large
Question 37:
How will you link a style sheet names “ssa.css” in your web page?
odesk Css test solution Part 1
Question 1:
Which of the following is true for a class selector?
- It uses a hash as the separator symbol
- It applies the style to only the first element defined with that style
- It applies the style to only the last element defined with that style
- It applies the style to all the elements defined with that style
Question 2:
Which of the following does not apply to external styles?
- Clean separation of design & content
- Minimal code duplication
- Highest priority
- Reduces page download time
Question 3:
Read the following Code:
BODY {
Background: white url(“bar.gif”);
Background-repeat: repeat-y;
Background-position: center;
}
What will be the output of this code?
- Image bar.gif will be tiled vertically in the background in the center of the page.
- Image bar.gif will be tiled horizontally in the background in the center of the page
- Image bar.gif will be displayed in the center of the page
- Image bar.gif will be stretched in the center of the page
Question 4:
Which of the following is not a valid text-decoration option?
- Text-decoration :line-through
- Text-decoration :in-line
- Text-decoration :overline
- Text-decoration :underline
- Text-decoration :none
Question 5:
You defined some links as follows:
A:link{color:green}
A:visited{color:blue}
A:hover{color:red)
A:active{color:black}
What will be the color, when the mouse goes over a link?
- Green
- Blue
- Red
- Black
Question 6:
The following is a style definition:
Td#aln
{text-align:center;
color:blue}
How will you refer to this style in your web page?
- A. by using the class attribute in a td cell
- B. by using the id Attribute in a td cell
- C. by using the class attribute in any html element which supports the class attribute
- D. by using the id attribute in any html element which support the id attribute
Question 7:
Which of the following is not a valid property of an aural style sheet?
- Cue
- Voice-family
- Load
- Speak
Question 8:
Your website displays some articles on java programming. The articles contain blocks of java code as well. If you want to leave ‘1 cm’ space above and below the code blocks, you would use:
- Code{margin:1cm}
- Code{margin-top:1cm; margin-bottom:1cm}
- P{margin:1cm}
- P{margin-top:1cm; margin-bottom:1cm}
Question 9:
Text text text text
A Text text
Sentence text text
Inside text text
A text ext
Text text text
Text text
Text text text text
You have and article of 100 lines. If for instance, you want to describe the theme with a few lines inside the text highlighted separately as show in the image which of the following property will you use?
- Outline
- Display
- Float
- Merge
Question 10:
You are fetching customer names from a database. The names in the database are mostly in lowercase. What is the name of the text property which will facilitate capitalization of these names?
- Text-mode
- Text-transform
- Text-decoration
- Text-shadow
- Text-case
Question: 11;
Here is one of the styles defined in your webpage:
.redborder
{
border-color:#ff0000;
border-width:thin thick
}
What type of border will be displayed if one of the paragraphs defined in the webpage uses this style?
- This will display a red border with thin top and bottom
- This will display a red border with thick top and bottom
- This will display a red border with thick left and right
- This will not display any border
Question 12:
Which of the following are correct values of the overflow property?
- Visible
- Hidden
- Scroll
- Auto
Question 13:
Which of the following is correct?
- Blockquote{text-padding:2em 4em 5em}
- Blockquote{padding-x:2em 4em 5em}
- Blockquote{padding-y:2em 4em 5em}
- Blockquote{padding:2em 4em 5em}
Question 14:
Which element property is required to define internal styles?
- Class
- Style
- span
- link
Question 15
Which style property can be used to display only some part of an image?
- Snap
- Clip
- Scroll
- Visible
Question 16
Which of the following is not true for a style sheet?
- A style sheet defines how an html element will be displayed
- Internal and external style sheets can not be used together
- Multiple style definitions will cascade into one
- The same style sheet can be used by many html pages
Question 17
Which of the following font properties deals with aspect value?
a. Font-weight
b. Font-variant
c. Font-size-adjust
d. Font-size
Question 18:
Consider this style definition:
P i{color:red}
What do you understand about the contextual selector used above?
- All the text within a paragraph will be italicized
- All the italic text in the page will have red color
- All the page text under
tag and tag will be red - All the italic text with in a paragraph will be red
Question 19
Background-position sets the position of the background image what happens if its value is 0% 0%?
- Image will have zero width and height so it will be hidden.
- Image will be positioned at the upper left corner.
- Image will be positioned at the lower right corner
- None of the above
Question 20
You want to increase the space between the lines in all you paragraphs. What will you use?
- P{width:1cm}
- P{height: 1cm}
- P{line-height:1cm}
- P{line-width:1cm}
Microsoft Excel 2000 Odesk Test
Q1: 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
Q2:The figure shows the AutoFit Selection menu option. What function does it perform?
Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell
Q:How does the AutoComplete feature in Excel help you save time?
Ans:It automatically completes abbreviated words
Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans:Apply the Text Format to empty cells, and then type the numbers
Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans:A_B
Q:How can you select all the blank cells in your worksheet?
Ans:This must be done manually as it is not automated through any built-in feature
Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?
Ans:#N/A
Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Ans:TRUE
Q:What does the NOW() function returns?
Ans:Returns the serial number of the current date and time
Ans:Forms toolbar
Q:When you clear the contents from a cell, the formatting of the cell is also lost.
Ans:FALSE
Ans:It copies the formatting properties from one cell to another
Q2:The figure shows the AutoFit Selection menu option. What function does it perform?
Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell
Q:How does the AutoComplete feature in Excel help you save time?
Ans:It automatically completes abbreviated words
Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?
Ans:It is used to add a hyperlink
Ans:It is used to add a hyperlink
Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans:Apply the Text Format to empty cells, and then type the numbers
Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans:A_B
Q:How can you select all the blank cells in your worksheet?
Ans:This must be done manually as it is not automated through any built-in feature
Q:What is the quickest way to select all the columns on a worksheet?
Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet
Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes
Q:Which of the following functions would return a value of 8?
Ans:b and c
Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans:3 new rows will be inserted after row 9
Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?
Ans:It inserts a Diagram or Organization Chart in the worksheet
Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans:TRUE
Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans:Select the cells, open the Window menu and click on Hide
Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans:DATEVALUE
Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?
Ans:It adds up the values in the selected cells
Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans:#N/A
Q:Which of the following function you will use to find the highest number in a series of numbers?
Ans:MAX(B1:B3)
Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans:Date
Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet
Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes
Q:Which of the following functions would return a value of 8?
Ans:b and c
Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans:3 new rows will be inserted after row 9
Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?
Ans:It inserts a Diagram or Organization Chart in the worksheet
Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans:TRUE
Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans:Select the cells, open the Window menu and click on Hide
Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans:DATEVALUE
Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Y'?
Ans:It adds up the values in the selected cells
Q:Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Ans:#N/A
Q:Which of the following function you will use to find the highest number in a series of numbers?
Ans:MAX(B1:B3)
Q:You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
Ans:Date
Q: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
Ans:b
Q:What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given below?
Ans:#N/A
Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Ans:TRUE
Q:What does the NOW() function returns?
Ans:Returns the serial number of the current date and time
Q: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
Ans:Hold down the CTRL key during startup
Q:Which toolbar is shown in the figure?
Ans:Forms toolbar
Q:When you clear the contents from a cell, the formatting of the cell is also lost.
Ans:FALSE
Subscrever:
Comentários (Atom)