sexta-feira, 1 de abril de 2011

FIVE Surefire Ways To Effectively Ask For The Job Interview In Your Next Cover Letter

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.

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

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"

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 :
  1. It does not allow expiry time to be set
  2. It can be used only once
  3. It does not url- ENCODE the value on its own
  4. 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.

  1. True
  2. False

Ans: B

Question 3

Which of the following is not a valid php connection status?
  1. Aborted
  2. Normal
  3. Open
  4. Timeout

Ans: C

Question 4

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

  1. Abstract classes are introduced in php 5
  2. A class with a single abstract method must be declared abstract
  3. Abstract class can contain abstract methods
  4. 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;
?>

  1. real
  2. double
  3. decimal
  4. Boolean

Ans: C

Question 7

What is the result of the following expression?

5+2*4+6
  1. 70
  2. 19
  3. 34
  4. 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:
  1. checkbox
  2. select
  3. file
  4. 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;
?>

  1. 100
  2. 200
  3. 500
  4. 0
  5. 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”?

  1. Filesize
  2. Size
  3. sizeofFile
  4. getSize

Ans: A

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

  1. these are not closed even after the execution of the script
  2. these are mainly used to increase the efficiency of the system
  3. These can’t be converted to non-persistent connections
  4. These are preferable not used in the scripts involving transactions

Ans: D

Question 15

Which one is correct?

  1. $s=fwrite(“a string here”);
  2. $s=fwrite($fp,”a string here”);
  3. $s=fwrite(“a string here ”,$fp);
  4. 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”;
?>
  1. 0.9
Not Equals
  1. 1
Equals
  1. 1
not Equals
  1. 1.1

Ans: C

Question 18

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

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

Ans: A

Question 19

Late php versions support remote file accessing for the functions:

  1. Include()
  2. Include_once()
  3. Require_once()
  4. 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 “???”?

  1. Parent:: getSal();
  2. Person::getSal();
  3. Parent::getsal;
  4. Person::getSal;

Ans: A

Odesk Css Test Solution Part 2

Question 21:
The default value for the overflow property is:

  1. Scroll
  2. Visible
  3. Hidden
  4. 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?
  1. @page {width:8.5in;Height:11in; margin:2cm}
  2. @page {width:8.5in x 11in; margin:2cm}
  3. @page {size:8.5in 11in; margin:2cm}
  4. @page {size:8.5in 11in; margin:2cm}


Question 23:

Which of the following is not a valid list property?
  1. List-style-type
  2. List-style-position
  3. List-style-image
  4. 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?

  1. When using css, positioning can be absolute, relative or dynamic
  2. The float Property for text/images can be left, right or center
  3. The values of visibility can be true or False
  4. 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?

  1. When font size is set to 46px. The height of the letter ‘x’ will be 100px
  2. 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:
  1. Family name
  2. Generic Family
  3. 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?

  1. The dimensions of the page area are the dimensions of the page box minus the margin area
  2. The dimensions of the page area are the dimensions of the page box plus the margin area
  3. The dimensions of the page area are the dimensions of the page box and margin area does not affect it.
  4. 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?

  1. Orphans
  2. Widows
  3. Bottom
  4. Overflow
  5. None of the above

Question 31

Which of the following is correct with regard to comments in a style sheet?

  1. Comments can appear outside the style definition only
  2. Comments start with//
  3. Comments end with */
  4. 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?

  1. Vertical-align: super
  2. Vertical-align: superscript
  3. 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?
  1. By using the class attribute in a td cell
  2. By using the id attribute in a td cell
  3. By using the class attribute in any html element which supports the class attribute
  4. 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?

  1. It uses a dot as the separator symbol
  2. It applies the style to only the first element defined with that selector
  3. It applies the style to only the last elements defined with that selector
  4. It applies the style to all the elements defined with that selector

Question 36

Which of the following values are correct for Font-style?

  1. Normal, wider, narrower
  2. Normal , italic, oblique
  3. Normal, bold, lighter
  4. 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?

  1. It uses a hash as the separator symbol
  2. It applies the style to only the first element defined with that style
  3. It applies the style to only the last element defined with that style
  4. It applies the style to all the elements defined with that style


Question 2:
Which of the following does not apply to external styles?

  1. Clean separation of design & content
  2. Minimal code duplication
  3. Highest priority
  4. 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?

  1. Image bar.gif will be tiled vertically in the background in the center of the page.
  2. Image bar.gif will be tiled horizontally in the background in the center of the page
  3. Image bar.gif will be displayed in the center of the page
  4. 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?

  1. Text-decoration :line-through
  2. Text-decoration :in-line
  3. Text-decoration :overline
  4. Text-decoration :underline
  5. 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?

  1. Green
  2. Blue
  3. Red
  4. 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?

  1. Cue
  2. Voice-family
  3. Load
  4. 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:

  1. Code{margin:1cm}
  2. Code{margin-top:1cm; margin-bottom:1cm}
  3. P{margin:1cm}
  4. 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?

  1. Outline
  2. Display
  3. Float
  4. 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?

  1. Text-mode
  2. Text-transform
  3. Text-decoration
  4. Text-shadow
  5. 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?

  1. This will display a red border with thin top and bottom
  2. This will display a red border with thick top and bottom
  3. This will display a red border with thick left and right
  4. This will not display any border

Question 12:
Which of the following are correct values of the overflow property?

  1. Visible
  2. Hidden
  3. Scroll
  4. Auto


Question 13:
Which of the following is correct?

  1. Blockquote{text-padding:2em 4em 5em}
  2. Blockquote{padding-x:2em 4em 5em}
  3. Blockquote{padding-y:2em 4em 5em}
  4. Blockquote{padding:2em 4em 5em}

Question 14:
Which element property is required to define internal styles?

  1. Class
  2. Style
  3. span
  4. link

Question 15
Which style property can be used to display only some part of an image?

  1. Snap
  2. Clip
  3. Scroll
  4. Visible

Question 16
Which of the following is not true for a style sheet?

  1. A style sheet defines how an html element will be displayed
  2. Internal and external style sheets can not be used together
  3. Multiple style definitions will cascade into one
  4. 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?

  1. All the text within a paragraph will be italicized
  2. All the italic text in the page will have red color
  3. All the page text under
    tag and tag will be red
  4. 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%?

  1. Image will have zero width and height so it will be hidden.
  2. Image will be positioned at the upper left corner.
  3. Image will be positioned at the lower right corner
  4. None of the above

Question 20
You want to increase the space between the lines in all you paragraphs. What will you use?

  1. P{width:1cm}
  2. P{height: 1cm}
  3. P{line-height:1cm}
  4. 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:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?

Ans:It is used to add a hyperlink

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

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

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

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

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