Odesk Test Photoshop cs3 answer by bdbookfair

Thanks for visit bd bookfair. Odesk Test Photoshop cs3 answer is below

Ø Changing units on the Info Palette automatically changes the units on Rulers.
Ans: TRUE

Ø Which of the following Filters cannot be applied to a Smart Object?
Ans: Pattern Maker

Ø With which of the given options does the Signal Strength Meter appear?
Ans: It appears when you choose 'merge to hdr command'

Ø Channels can not be added to which of the following image modes?
Ans: Bitmap

Ø Which among the following Modes does not support layers?
Ans: All of the above

Ø Which of the following is not true about Filters?
Ans: None of the above

Ø Which of the following is not true about the Curves dialog box?
Ans: The Curves dialog box lets you adjust up to 14 different points throughout an image's tonal range

Ø Which of the following Slices is created with the Slice Tool?
Ans: User slices

Ø Which of the following features is supported by the EPS file format?
Ans: It supports the Grayscale and Bitmap color modes

Ø Which among the following blending modes is available only for the Apply Image and Calculationscommands?
Ans: Both a and b

Ø What is the use of the Make Work Path command in the Paths palette ?
Ans: It can alter the shape of a selection

Ø Which type of information is not displayed by the Info Palette?
Ans: It does not display the opacity of the current layer

Ø Which among the following is not a right option for selecting a web-safe color from the Color Palette?
Ans: Choose Current Color from the Color Palette Menu

Ø Which keyboard shortcut (windows) will you choose to close a Path?
Ans: None of the above
Ø Anti-aliasing option is available for which of the given Tools?
Ans: All of the above
Ø Which of the following options displays the Spot Channels in the Channels palette?
Ans: B

Ø What happens when Use Legacy is selected as shown in the given picture?
Ans: It is used to apply proportionate (nonlinear) adjustments to image pixels

Ø Which option will you select to open the Levels dialog box?
Ans: Choose Image > Adjustments > Levels

Ø Which type of images are resolution-dependent?
Ans: Vector images

Ø Which Liquify Tool is used to reconstruct a part of a distorted image?
Ans: A

Ø In which Format will you save your file to preserve the Alpha channels?
Ans: All of the above

Ø Which of the following is not a kind of text type?
Ans: Line type

Ø Which option will you select to convert Types to Shapes?
Ans: Both b and c

Ø The mask created by the Replace Color command is permanent.
Ans: FALSE

Ø Which of the following Layer properties can be animated?
Ans: All of the above

Ø Which View will you choose to display a Histogram with no controls or statistics?
Ans: All of the above

Ø Which of the given options displays left indent in the Paragraph palette?
Ans: B

Ø Which keyboard shortcut (windows) will you choose to group Layers?
Ans: Control + G

Ø The Rotate Canvas command does not work on which of the following
Ans: All of the above

Ø Which of the Saving commands is available for an image that is managed by a Version Cue Workspace?
Ans: Check In

Ø When will the Dynamic shortcuts appear in the Character Palette Menu as shown in the picture?
Ans: All of the above
Ø Hanging Punctuation controls the alignment of the punctuation marks for a specific paragraph.
Ans: TRUE

Ø Which option will you choose to select all layers of a similar type?
Ans: All of the above

Ø Which of the following is not a Color Adjustment command?
Ans: Adjustment command

Ø By default, Masks applied to Smart objects are linked to Smart object layers. .
Ans: FALSE

Ø A working space is an intermediate color space used to define and edit color in Adobe applications.
Ans: FALSE

Ø Which option will you select to remove the existing profile from the document in the given image?
Ans: C

Ø You cannot change the order of the Vector masks or working paths in the Paths palette.
Ans: FALSE

Ø The Color Replacement Tool does not work in which of the following Image modes?
Ans: All of the above

Ø In which of the following Modes can you draw while working with the Shape or Pen tools?
Ans: All of the above

Ø The Out Of Gamut option works only on RGB and Lab images
Ans: TRUE

Ø Which among the following QuickTime Video formats is supported by Photoshop extended?
Ans: MOV

Read More

Odesk PHP 5 test answers by bdbookfair

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named Odesk PHP 5 test for
Web designer and Developers to get more job .ok let's  start

Question: What is true regarding this code?
Ans: setcookie will return true
Question: Which of the following is not a correct way of printing text in php5?
Ans: echo "Plain text";

Question: Which of the following is not the correct way of starting a session?
Ans: session_initiate()
                                                                                                                     
Question: Which of the following functions do you need to implement HTTP Basic Authentication?
Ans: None of the above

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

Question: Which of the following statements is correct with regard to final and abstract?
Ans: a. An abstract class cannot have final methods

Question: Which composite data types are supported by php?
Ans: Array

Question: The default value of register_globals in PHP is:
Ans: Off

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

Question: Choose the correct statement:
Ans:  include() includes and evaluates a specific file
require_once() includes and evaluates a specific file only if it has not been included before

Question: If the session_cache_expire() is not set, then by default the session cache will expire after:
Ans: 3 hrs

Question: What will be the output of the following script?
$count=50;
function Argument()
{
$count++;
echo $count;
}
Argument();
?>
Ans: It will print 1

Question: State whether True or False

Paamayim Nekudotayim operator allows access only to the static members of a class?
Ans: True
Question: Which of the following statements is true with regard to comparisons in PHP5?
Ans: With (===) operator, object variables are identical if and only if they refer to the same instance of the same class.
Question: Which of the following built-in function assist in checking if actually the function exists or not?
Ans: function_exists
Question: What will be the output of the following code?
$a = 0.0;
for ($i = 0; $i < a ="="">
Ans: 1

Question: What will be the output of the following code?
$i=4;
$j=30;
$k=0;
$k=$j++/$i++;
echo $i . " " . $j . " " . $k . " ";
Ans: 5 31 7.5

Question: Which of the following is a not a correct way of commenting in php?
Ans: /#PHP Comment

Question: Following is a php code block:
$m=9;
$n=99;
$z=8;
$z=$n++/$m++ + --$z;
echo $z;
what will be the output?
Ans: 18
Question: Which of the following is the correct way of specifying default value?
Ans: function GetDiscount($Type = "Special") { . . . }

Question: With reference to the following php script:
print 'Text Line1'
print 'Text Line2'
?>
What will be the output on running the script?
Ans: Error message will be printed

Question: What will be the ouput of the following code?
for ($i = 0; $i < i ="="">
0134
Question: Late PHP versions support remote file accessing for the functions:
Ans: include_once()
          require_once()
both of them
Question: You have designed a user login form as follows:
User Name:  
Password:  
How can you access the username entered by the user in the 'Validate.php' webpage?
a. $var= $_POST['username'];
b. $var= $_REQUEST['username'];
c. import_request_variables('p', 'p_');
$var= $p_username;
Ans:  Both of them

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

Question: Which of the following is not true for a persistent connection?
Ans: These can't be converted to non-persistent connections

Question: Which of the following are invalid data types in PHP?
Ans: char
Question: The Manager and Office classes are as follows:
class Manager{
function printName() {
echo "Manager";
}
}
class Office{
function getManager() {
return new Manager();
}
}
$ofc = new Office();
???
?>
Which of the following should replace '???' to obtain the value of printName() function?
Ans: $ofc->getManager()->printName();

Question: The classes are defined as follows:abstract class BaseCls{
protected abstract function getName();
}
class ChildCls extends BaseCls{
}
Which of the following implementations of getName() is invalid in ChildCls?
Ans: public function getName(){}

Question: Which of the following variable declarations within a class is invalid in PHP5?
Ans: var $term =3;

Question: What will be the output of following code?
$arr = "a";
$arr[0]="b";
echo $arr;
echo $arr[0];
Ans: bb

Question: For the following code:
the output will be:
Ans: 171

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

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

Question: What will be the output of following code?
$var1="a";
$$var1="b";
echo "$var1 $a";
Ans: a b

Question:What is the output of the following code?
$a = 500;
$b = 200;
echo $a % 2
* $b;
?>
Ans: 0

Question: What will be the ouput of the following code?
if (-1)
print "true";
else
print "false";
?>
Ans: true
Question: What will be the output of the following code?
echo 12 . 6;
Ans: 126
Question: Consider the following sample code:
$x = 0xFFFE;
$y = 2;
$z = $x && $y;
What will be the value of $z?
Ans: 1
                                                                  power by www.bdbookfair.tk

Read More

oDesk HTML 4.01 Test Answer by bdbookfair

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named oDesk HTML 4.01  Test answers .ok let's  start,

Question no. 1 Which of the following statements is correct for a blockquote?
a. It make the text a bit bigger for emphasizing.
b. It defines the start of a long quote.
c. It makes the text slightly bolder.
Ans: b. It defines the start of a long quote.

Question no. 2 Which of the following is incorrect about the relation between HTML and XHTML?
a. XHTML is a stricter and cleaner version of HTML.
b. XHTML is almost identical to HTML 4.01.
c. XHTML and HTML both are used to generate dynamic content.
d. XHTML brings together the elements of HTML and the syntax of XML.
Ans: b. XHTML is almost identical to HTML 4.01.

Question no. 3 Choose the incorrect statement(s):
a. An HTML attribute is additional information included inside a tag.
b. HTML is case sensitive.
c. All the HTML4.01 tags must be paired.
d. Your browser may appear to correctly use newly deprecated code for the present, but its support for deprecated code could be
halted at any time after the browser is updated.
Ans: b. HTML is case sensitive.

Question no. 4 Which of the following tags can be used in place of a button tag?
a. legend
b. ol
c. input
d. dl
Ans: c. input

Question no. 5
Which of the following is not a valid input type of the form tag?
a. checkbox
b. image
c. hidden
d. button
e. All are valid
Ans: e. All are valid

Question no. 6 It is not necessary to give the coordinates for an image or object defined within an area tag, if the value of its shape attribute is:
a. circle
b. poly
c. default
d. rect
Ans: c. default

Question no. 7 Which of the following is/are a valid value for the type attribute of the input tag?
a. text
b. icon
c. reset
d. password
Ans: a. text , c. reset , d. password

Question no. 8 Which of the following is not correct for an action attribute for a form tag?
a.The action attribute can be defined at runtime.
b. If the value for action is null (action=""), then the form submits user data to itself.
c. If the URL is not provided to the action attribute, the form will not submit user data anywhere.
d. None of the above
Ans: d
Question no. 9 Which of the following values is/are valid for the align attribute of a tag?
a.left
b.right
c.center
d. offset
Ans: a,b,c
Question no. 10 What do you infer from the following code? <a href = "http://www.expertrating.com"> Expert Rating
a.This href is using absolute path for linking.
b. This href is an example of relative path linking.
Ans: a
Question no. 11 Which of the following statements is correct for the tag?
a. The text under block quote must be enclosed in a block level element in a strict DTD document.
b. The attribute named cite must be specified.
c. Closing the tag is optional.
d. It places an empty line after the text.
Ans: ()

Question no. 12 Which of the following is/are not true for a paragraph tag in HTML 4.01?
a. The text must be enclosed in <p> and </p> tags.
b. It creates an empty line above its starting line.
c. It cannot be used within a <td> tag.
d. It creates an empty line after its ending line.
 Ans: b,c

Question no. 13 A piece of text contains many blank spaces within it. Which of the following tags would be suitable to display the text as it was originally formatted?
a. td
b. p
c. ls
d. pre
 Ans: d

Question no. 14 You are creating several web pages for a website that contain several rather large data tables, many of which are somewhat similar in the number of columns, rows, and in other common table formatting. In addition, CSS will be employed for formatting the tables. Which one of the following types of CSS has the highest priority over the others and typically requires the greatest total amount of code space for the entire website for formatting the various <td> table cells?
a. External style sheet
b. Inline style
c. Internal style sheet
d. Browser default
 Ans: a

Question no. 15 Which of the following attributes is/are related to the <img> tag?
a. height
b. alt
c. src
d. All of the above
 Ans: d


Question no. 16 The following link is placed on an HTML webpage.
<a href="http://msdn.com/" target="_blank"> MSDN </a>
What do you infer from it?
a. It will open the site msdn.com in the same window.
b. It will open the site msdn.com in a new window.
c. It will open the site msdn.com in a frame below.
d. It will not be clickable as it is not formed correctly.
 Ans: b


Question no. 17 Is the following code valid in HTML 4.01 Strict?
<ul><li><ol><li>A</li><li>B</li><ul><li>Item1</li><li>Item 2</li></ul><li>C</li></ol></li></ul>
a. Perfectly valid.
b. Invalid because you should not have three levels of nesting in the lists.
c. Invalid because you should not have an unordered list within an ordered list.
d. Invalid because a <ul> tag should not conflict with an <ol> tag at the same list level.
Ans: a

Question no. 18 Which of the following values for the scrolling attribute for the frame tag is not valid?
a. yes
b. default
c. auto
d. no
Ans: ()

Question no. 19 Which of the following is/are not correct for a <meta> tag in HTML 4.01?
a. It is more useful if it is placed in a head element.
b. It can be used to specify the keywords for the search engines.
c. It can be used to redirect users to other URLs.
d. It is mandatory to specify its name or scheme attributes.
 Ans: d


Question no. 20 The tag that is used to pass the parameters to an applet is:
a. appletpar
b. applet
c. param
d. val
Ans: c

Question no. 21 Which of the following attributes is/are valid for a select tag contained within a form tag?
a. name
b. size
c. multiple
d. All of the above
Ans: d

Question no. 22 For the following items of a <select> list:
<option value="89">Item 1</option>
<option value="90">Item 2</option>
Which of the following values would be passed on by clicking the submit button on selecting Item 2 from the list?
a. 89
b. 90
c. Item 1
d. Item 2
Ans: b

Question no. 23 You have to add a list of products in a drop-down list. What will you use to group the identical products under a category name?
a. optgroup
b. option
c. menu
d. var
e. There is no way to do this
Ans: a

Question no. 24 Which of the following shows the basic tag structure of an HTML document?
a. <html><head><body></body></html>
b. <html><body></body></html>
c. <html><head></head><body></body></html>
d. <html><head></head></html>
Ans:c

Question no. 25 You want to provide a form field to the users for writing lengthy comments on the quality of the services provided by you. Which of the following tags will you use?
a. <textarea rows="8" cols="20"> Your Comments.... </textarea>
b. <textarea row="8" col="20"> Your Comments.... </textarea>
c. <textarea rowcount="8" colcount="20"> Your Comments.... </textarea>
d. <input type="text" maxlength="100"/>
Ans: d

Question no. 26 Which of the following set of coordinate values refers to an image defined by the area tag with the value of poly for its shape attribute?
a. coords="150,217,190,257,150,297,110,257"
b. coords="150,190,150,110"
c. coords="150,217,190,257,150"
d. coords="150,110,190,220,150,150,120"
Ans: b

Question no. 27 What is meant by the cellspacing attribute?
a. It makes the cell span more than one column.
b. It specifies the space between the cell wall and the contents of the cell.
c. It specifies the space between two cells.
d. It makes the cell span more than one row.
Ans: c

Question no. 28 Which of the following attributes comes in handy when borders have to be put between groups of columns instead of every column?
a. col
b. colgroup
c. rowspan
d. row
Ans: b

Question no. 29 A few lines in an HTML paragraph are to be formatted differently from the rest of the lines. Which tag will assist in this?
a. div
b. p
c. span
d. format
Ans: b

Question no. 30 How will you specify a comment in an HTML document?
a. <!!- Here is a comment... -!>
b. <-Here is a comment.. ->
c. <!-- Here is a comment.. -->
d. <! Here is a comment... -!>
 Ans: c

Question no. 31 Which of the following is correct regarding the frame attribute in the <table> tag?
a. It is used to add a frame to the table.b. A hsides value for the frame attribute will show the border lines for horizontal sides only.
c. A hsides value for the frame attribute will not show the border lines for horizontal sides only.
d. A hsides value for the frame attribute will add a scrollable frame on the horizontal sides.
Ans: b

 Question no. 32 What is meant by cellpadding?
a. It makes the cell span more than one column.b. It specifies the space between the cell wall and the contents of the cell.
c. It specifies the space between two cells.
d. It makes the cell span more than one row.
Ans:  b

Question no. 33 Within a table cell <td>:
a. <p></p> tags cannot be used.
b. <ol></ol> tags cannot be used
c. <table></table> tags cannot be used.
d. <form></form> tags cannot be used.e. All the above tags could be used.
Ans: e

Question no. 34 A developer wrote this image tag:
<img src ="states.gif" width ="330" height ="406" alt="States"
usemap ="#statemap" />
What code should follow this?
a. <map id ="statemap" name="statemap">
<area shape ="rect" coords ="0,0,82,126" href="state1.htm"
alt="State1" />
</map>
b. <map id ="statemap" name="statemap"> </map>
<area shape ="rect" coords ="0,0,82,126" href="state1.htm"
alt="State1" />
c. <map id ="statemap" name="statemap">
<img area shape ="rect" coords ="0,0,82,126" href="state1.htm"
alt="State1" /> </map>
d. <map id ="statemap" name="statemap">
<img area shape ="rect" coords ="0,0,82,126" href="state1.htm"
alt="State1" /> </map>
Ans: ()


Question no. 35 You want to display a table listing out customer names and their contact information. The heading of the table is shown in the figure. What is the code for creating the first line of the table heading?
a. <tr>
<th>Customer Name</th>
<th colspan=3>Contact</th>
</tr>
b. <tr>
<th>Customer Name</th>
<th cellpadding=3>Contact</th>
</tr>
c. <tr>
<th>Customer Name</th>
<th rowspan=3>Contact</th>
</tr>
d. <tr>
<th>Customer Name</th>
<th cellspacing=3>Contact</th>
</tr>
<tr> <th>Customer Name</th> <th cellpadding=3>Contact</th> </tr>   Ans:




Question no. 36 What would you infer from the following code in an HTML 4.01 Web site? <body topmargin=2 leftmargin=2>
a. The top margin and left margin of the webpage is 2 pixels.
b. The bottom margin and right margin of the web page is 2 pixels.
c. Both of the above.
d. None of the above. The topmargin and leftmargin attributes are not valid HTML 4.01 body attributes.
Ans: a

Question no. 37 You specified a base tag and anchors as follows:
1. <base target="_blank">
2. <a href="http://www.yahoo.com">Yahoo</a>
3. <a href="http://www.google.com" target="_top">Google</a>
Which of the following is true for the above code?
a. Only the Yahoo link will open in a new window.
b. Only the Google link will open in a new window.
c. Both links will open in a new window.
d. Both links will open in the same window.
 Ans: c


Question no. 38 On one of your Web pages named Listing.html, you specified a target like this:
<a name="target4">Old Listing</a>
How will you make a link to the above target?
a. <a url="#target4">Check Old Listing as well</a>
b. <a href="#target4">Check Old Listing as well</a>
c. <link url="target4">Check Old Listing as well</link>
d. <a href="Listing.target4">Check Old Listing as well</a>
 Ans: b


Question no. 39 Which attribute specifies the submit URL in a form tag?
a. method
b. action
c. name
d. id
Ans: b

Question no. 40 The tag which is used to show monospaced text is:
a. <td>
b. <th>
c. <tt>
d. <b>
Ans: b
                                       power by www.bdbookfair.tk

Read More

oDesk Css test Answer for web designer by Bdbookfair

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named oDesk Css test  Answer for web designer .ok let's  start

Question 1:Which of the following is true for a class selector?

a.            It uses a hash as the separator symbol
b.            It applies the style to only the first element defined with that style
c.            It applies the style to only the last element defined with that style
d.            It applies the style to all the elements defined with that style
Ans:D


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

a.            Clean separation of design & content
b.            Minimal code duplication
c.            Highest priority
d.            Reduces page download time
Ans: C

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?

a.            Image bar.gif will be tiled vertically in the background in the center of the page.
b.            Image bar.gif will be tiled horizontally in the background in the center of the page
c.            Image bar.gif will be displayed in the center of the page
d.            Image bar.gif will be stretched in the center of the page
Ans: A

Question 4: Which of the following is not a valid text-decoration option?

a.            Text-decoration :line-through
b.            Text-decoration :in-line
c.            Text-decoration :overline
d.            Text-decoration :underline
e.            Text-decoration :none
Ans: B

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?

a.            Green
b.            Blue
c.            Red
d.            Black
Ans: B

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•
Ans: B

Question 7: Which of the following is not a valid property of an aural style sheet?
a.            Cue
b.            Voice-family
c.            Load
d.            Speak
Ans: C
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:

a.            Code{margin:1cm}
b.            Code{margin-top:1cm; margin-bottom:1cm}
c.            P{margin:1cm}
d.            P{margin-top:1cm; margin-bottom:1cm}
Ans: B
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?

a.            Outline
b.            Display
c.            Float
d.            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?

a.            Text-mode
b.            Text-transform
c.            Text-decoration
d.            Text-shadow
e.            Text-case
Ans: B
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?

a.            This will display a red border with thin top and bottom
b.            This will display a red border with thick top and bottom
c.            This will display a red border with thick left and right
d.            This will not display any border

Question 12: Which of the following are correct values of the overflow property?
a.            Visible
b.            Hidden
c.            Scroll
d.            Auto
Ans: A,B,C,D

Question 13: Which of the following is correct?

a.            Blockquote{text-padding:2em 4em 5em}
b.            Blockquote{padding-x:2em 4em 5em}
c.            Blockquote{padding-y:2em 4em 5em}
d.            Blockquote{padding:2em 4em 5em}

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

a.            Class
b.            Style
c.            span
d.            link
Ans: B

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

a.            Snap
b.            Clip
c.            Scroll
d.            Visible

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

a.            A style sheet defines how an html element will be displayed
b.            Internal and external style sheets can not be used together
c.            Multiple style definitions will cascade into one
d.            The same style sheet can be used by many html pages
Ans: A


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?

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

a.            Image will have zero width and height so it will be hidden.
b.            Image will be positioned at the upper left corner.
c.            Image will be positioned at the lower right corner
d.            None of the above

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

a.            P{width:1cm}
b.            P{height: 1cm}
c.            P{line-height:1cm}
d.            P{line-width:1cm}
Ans: C

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

a.            Scroll
b.            Visible
c.            Hidden
d.            Auto
Ans: C*

Question 22:
Which of the following will set the page size to 8.5 inches x 11 inches with 2cm margin al all sides?
a.            @page {width:8.5in;Height:11in; margin:2cm}
b.            @page {width:8.5in x 11in; margin:2cm}
c.            @page {size:8.5in 11in; margin:2cm}
d.            @page {size:8.5in 11in; margin:2cm}


Question 23: Which of the following is not a valid list property?
a.            List-style-type
b.            List-style-position
c.            List-style-image
d.            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?

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

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

a.            The dimensions of the page area are the dimensions of the page box minus the margin area
b.            The dimensions of the page area are the dimensions of the page box plus the margin area
c.            The dimensions of the page area are the dimensions of the page box and margin area does not affect it.
d.            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?

a.            Orphans
b.            Widows
c.            Bottom
d.            Overflow
e.            None of the above

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

a.            Comments can appear outside the style definition only
b.            Comments start with//
c.            Comments end with */
d.            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?

a.            Vertical-align: super
b.            Vertical-align: superscript
c.            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?
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 supports the id attribute.

Question 35 Which of the following is true for an ID selector?

a.            It uses a dot as the separator symbol
b.            It applies the style to only the first element defined with that selector
c.            It applies the style to only the last elements defined with that selector
d.            It applies the style to all the elements defined with that selector

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

a.            Normal, wider, narrower
b.            Normal , italic, oblique
c.            Normal, bold, lighter
d.            Small , medium , large


                                              power by www.bdbookfair.tk

Read More

Microsoft Excel 2010 Test answer by bdbookfair

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named oDesk Microsoft Excel 2010 Test answers .ok let's  start,

 Question: If you want to create a citation and fill in the source information later, you should:
a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
Ans: a

Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Ans: b

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?
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.
 Ans: c

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?

a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Ans: c

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?

a. Through
b. Square
c. In Font of Text
d. In Line with Text
 Ans: b

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?

a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.
 Ans: b

Question: A particular chart layout can be applied to a chart only if:
a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.
 Ans: c

Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.
 Ans: a

Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
 Ans: a

Question: With which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above
Ans: b

Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Ans: c

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?
a. BMP
b. PDF
c. XLS
d. JPG
 Ans: c

Question: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Ans: b

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?

a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.
Ans: c

Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
Ans: d

 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.

a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Ans: c

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?

a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas
Ans: b

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.

a. True
b. False
Ans: b

 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.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table
Ans: a
                                         power by www.bdbookfair.tk

Read More

oDesk MS Word 2007 test answers

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named oDesk MS Word 2007 .ok let's  start,

 1.  Which among the following methods would you select when you want to add protection to parts of a template?
Ans:  Go to the Developer tab, click on Properties in the Controls group and then click any of the Locking options in the Content Control Properties dialog box.

2. Which of the following is/are true about phishing?
Ans: All if the above

3. This question is based upon the figure shown below

In some cases, when lists are combined into one "List," the formatting is not updated. Refer to the picture given above. Which among the following options should be used to update this formatting?
Ans: D

4. Which among the following charts do not have axes?
Ans: Doughnut charts

5. Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: Linked

6. This question is based upon the figure shown below

 Ans: It ensures that the text is not obscured by binding.

7. With the help of which view will the Watermark not be seen?
Ans: Web Layout view

8. This question is based upon the figure shown below

How will the Message Bar alerts be enabled as shown in the given picture?
Ans: Select Word Options from the Microsoft Office Button. Click on Trust Center, then click Trust Center Settings, and then click Message Bar.
9. Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author

10.  This question is based upon the figure shown below

 Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: This option allows you to remove the Page Number from the first page.

11. State whether true or false:
Once a bullet is removed from the "Bullet Library" and it is no longer available in the "Document Bullets" area, the bullet cannot be added back to the Bullet Library.
Ans: False

12.  This question is based upon the figure shown below

Which of the following types of charts are not supported by either Lines or Bars, as shown in the picture?
Ans: Area charts

13. Which among the following features could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive

14. Edit tracking changes are typically formatted in the following manner: (1) deletions—red strikethroughs, (2) additions—green and underlined, and (3) formatting changes are made bold in almost any other desired color. Where in Word 2007 could you set your own custom formatting options for tracking changes?
Ans: Select the Review ribbon and then select the triangle by Track Changes. In the drop-down menu, select "Change Tracking Options" and then set your formatting options in the Track Changes Options dialog box.

15. How will you insert text boxes for a printed form?
Ans: Select the Insert tab, in the Text group, click on Text Box and then select Draw Text Box.

16. To enter a symbol or special character into your document (to where the cursor is located), which of the following methods could you employ in Word 2007?
Ans: Open the Insert ribbon. Click Symbol in the Symbols group. A menu will appear with a small selection of symbols. If you don't see the symbol or character you'd like to insert, click More Symbols. Choose the special character (or symbol) that you want and then click Insert and click Close.

17. You are editing a figure using the Drawing Tools > Format options. Which among the following Shape Fill options in the Shape Styles group adds a solid color and transparency to a shape?
Ans: More Fill Colors...

18. State whether true or false:
When you save a document as a Web page, the textures and gradients are saved as JPEG files and the patterns are saved as GIF files.
Ans: True

19. Which among the following options is the reason of text deletion at the insertion point when you type a document?
Ans: The "overtype mode" is turned on in Word options.

20. What is meant by Enhanced ScreenTips?


Ans:  Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic.

21. This question is based upon the figure shown below

Refer to the given picture. Which of the following Line Numbers should be used when each page has to begin with the number 1?
Ans: Restart Each Page

22. Which keyboard shortcut could be used to switch to Draft View?
Ans: ALT+CTRL+N

23. State whether true or false:

The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
Ans: True

24. Which view(s) could be used to view the Equation placeholders in the Document Views group?
Ans: All of the above

25. State whether true or false:
Any changes that are saved to "Normal.dotm" will be applied to the documents that you create in the future.
Ans: True

26. State whether true or false:
Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.
Ans: True

27. How will you set the default font so that every time you open Microsoft Word it will use the settings that you had selected?
Ans: Select the Home tab, and then click the Font Dialog Box Launcher. Select the font style and size. Click on Default... and then click Yes.

28. Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Doubled

29. How will you change the author name in an existing document?
Ans: All of the above

30. State whether true or false:
Microsoft Office programs store some additional information within the digital signature automatically that might not be visible in the current view document.
Ans: True

31. Which among the following options could be used to turn off the Office Clipboard?
Ans: All of the above

32. What does the command "Winword.exe /f MyDocument.docx" mean?
Ans: This command instructs Word to start and immediately open a file named MyDocument.docx.

33. Which among the following is an invalid character to include in a file name?
Ans: All of the above

34. State whether true or false:
Gridlines do not print when a document is printed.
Ans: True

35. Which keyboard shortcut inserts a hyperlink?
Ans: CTRL+K

36. Which among the following wildcards should be used to select any single character?
Ans: ?

37.  This question is based upon the figure shown below

 Refer to the given image. Which option should be selected to convert a professionally formatted equation into an equation on one line?

Ans: C

38. Which of the following is not a Content Control?
Ans: Chart

39. This question is based upon the figure shown below

Ans: Numbering

40. Which among the following is a correct way to make your file "Read-only?"
Ans: Click "Save As" from the Microsoft Office Button. Click on Tools and then click General Options. Select the Read-only recommended check box. Click OK. Click on Save.

41.  Which among the following options should be used to start a bulleted list automatically?
Ans: Type * (asterisk) and then press spacebar or the Tab key.

 42.

Which of the following can be the reason for the appearance of the red X, as shown in the picture?
Ans: All of the above

43. State whether true or false:
ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
Ans: True

44.  State whether true or false:
New text animation effects can be applied in Microsoft Word 2007.
Ans: False

45. Which among the following options should be used to number the cells in a table?
Ans: Select the table cells that need to be numbered. On the Home tab, in the Paragraph group, click on Numbering.


46. Which of the following options repeats a table heading on subsequent pages?
Ans: Repeat Header Rows

47. Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

48. Which among the following is not true regarding the use of a pie chart?
Ans: A pie chart should be used when there are more than seven categories.

49. This question is based upon the figure shown below

Refer to the given picture. Which of the following options turns off Enhanced ScreenTips but keeps the ScreenTips still visible?
Ans: B

50. Unlike the other types of styles (paragraph, character, linked, and table), predefined list styles are available when you first create a document in Word 2007.
Ans: False

51. This question is based upon the figure shown below

What is the maximum number of columns that can be created in the Columns dialog box as shown in the picture?
Ans: 13

52.  This question is based upon the figure shown below

Refer to the given image. In Picture1, axes appear on the left side. Which setting should you use to make them appear on the right side, as shown in Picture2?
Ans: Select the Axis Options tab in the Format Axis dialog box. Set the Axis labels: field to High.

53.  Which of the following two paragraphs is/are true for Word 2007?
(1)To show or hide formatting marks in your editing markup — on the Home ribbon, in the Paragraph group, click the Show/Hide button.
(2) The Show/Hide button will not hide all the formatting marks in the document if you selected those marks that are to be displayed at all times (such as paragraph marks, tab characters, hidden text, optional hyphens, object anchors, or spaces). To turn off any or all of these selected formatting marks, follow this procedure: Click the Microsoft Office Button and then click Word Options. Then Click Display. Under "Always show these formatting marks on the screen," clear the check boxes for any formatting marks that you do not want to show at all times in your documents.
Ans: Both (1) and (2)

54. This question is based upon the figure shown below

 In the given picture, the "Washout" option has been selected. What purpose does it serve?
Ans: It lightens the picture so that it does not interfere with the text.

55. The default installation of Word 2007 includes several built-in character styles. Which of the following is NOT one of the default, built-in character styles:
Ans: Special Emphasis

56. What steps should be followed to replace a shape with other shape?
Ans: Select the shape to be changed. Select the Format tab; use the "Change Shape" button in the Shape Styles group.

57. Just as in Word 2003 or prior Word versions, the default standard view for Word 2007 is the Draft view (and is still also called the Normal view in Word 2007):
Ans: False

58. This question is based upon the figure shown below

 What is the purpose of the "Demote" button as shown in the diagram?
Ans: It increases the level of a selected bullet or a shape.

59. Which feature(s) should be selected in order to find and remove hidden data and personal information in Office documents?
Ans: Document Inspector

60. Which keyboard shortcut is used to make the text size smaller?
Ans: CTRL+SHIFT+<

61.  Which among the following options will you use to add a command to the Quick Access Toolbar?
Ans: All of the above

62. Which option(s) should you select to remove a chart or axis title from a chart?
Ans: To remove an axis title, select the Layout tab. In the Labels group, click on Axis Titles, click the type of axis title, and then click None.

63.  Which among the following macro settings is meant for developers only?
Ans: Trust access to the VBA project object model.

64. State whether true or false:
A building block can be added to as many galleries as you want.
Ans: True

65. Which of the following is/are true about phishing?
Ans: It is an online fraud technique used by criminals to lure users into disclosing their personal in


                                               power by www.bdbookfair.tk

Read More

oDesk Microsoft Execl 2000/2003 test answers

Thanks for visit BD BOOK FAIR. Today I share odesk skill test answer named oDesk Microsoft Execl 2000/2003 test answers .ok let's  start,



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:

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




Visit every day to get latest things. bdbookfair now www.bdbookfair.tk

Read More