How to format your pen drive?

When you try to simply  format to your pen drive but you can’t give format to your pen drive. Who can’t give format to your pen drive? They follow this tips.

First you go to your computer desktop and then you right click over “My Computer” option. After click over my computer you will click manage option then you see this interface.

How to secure to your internet browser ?

Now a days every man and women see adult video. Some times can be problem for it. When you come out from your home keep your computer then your parents or brother can open your pc and check your history? When your browser history then they have understand that you use porn site and see adult video. So, when you will end your internet brows then you clear your internet history. If you keep clear your brower history then you have not face this problem. How to solve this problem? See below:

Some shortcut tips of internet.

New tab = ctrl+t

New Window = ctrl+n

New incognito window = ctrl+shift+n

Show bookmark bar = ctrl+shift+b

How to turn off automatic update windows to your computer?

Firstly you go my computer option and click right button over my computer option

then you click properties option. After click properties option you select automatic update option.

Search Engine Optimization oDesk Test Answers 2013-part-2

Question:   Which of the following search engines or directories provides the directory search results for Yahoo?
a.Windows Live
b.Yahoo Directory
c.Google
d. Wikipedia
e.DMOZ
Ans: B

Question:   Which of the following statements regarding website content are correct?
a. If you have two versions of a document on your website, Google recommends that you only allow
the indexing of the better version
b. Linking to a page inconsistently does not affect the way Google views the page/s. Examples
of
inconsistent linking could be http://www.expertrating.com/page/ and
http://www.expertrating.com/page and http://www.expertrating.com/page/index.htm
c.Syndicating your content could lead to Google viewing the material as duplicate
d.Placeholders for pages which do not have content are never viewed as duplicate content by
Google
Ans:C

Question:   Which of the following statements about Google's technical and quality guidelines is true?
a. It is advantageous if your web server supports the If-Modified-Since HTTP heade
b. If using dynamic pages, it helps to keep the parameters short and the number of them few
c. Avoid using robots.txt to prevent crawling of search results pages or other auto-generated pages,
even if they don't add much value for users coming from search engines
d. Submitting new pages of your website at http://www.google.com/addurl.html as soon as they are
online, helps to speed up indexing
Ans: B

search engine optimization oDesk test answer 2013

Question: 1
Which of the following search engines or directories provides the directory search results for Yahoo?
a.Windows Live
b.Yahoo Directory
c.Google
d.Wikipedia
e.DMOZ
Ans: B

Question: 2
Which of the following statements regarding website content are correct?
a.If you have two versions of a document on your website, Google recommends that you only allow the indexing of the better version
b.Linking to a page inconsistently does not affect the way Google views the page/s. Examples of inconsistent linking could be http://www.expertrating.com/page/ and http://www.expertrating.com/page and http://www.expertrating.com/page/index.htm
c.Syndicating your content could lead to Google viewing the material as duplicate
d.Placeholders for pages which do not have content are never viewed as duplicate content by Google
ans A
 
Question: 3
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 (MULTIPLIED 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: D

Question: 4
Which of the following statements about the Google Sitemap are correct:
a.Repeated submission of the Sitemap to Google could be penalized
b.It is possible to create and submit specialized Sitemaps to Google for Video and Mobile content
c.The Sitemap acceptable to Google follows an XML format
Ans: A

Wordpress 2.8 oDesk Test Answers 2013

Question:   Which of the following options are true regarding Plug-ins in WorpPress?
A) Plug-ins can be used to eliminate spam  
B) Plug-ins can be used to integrate a WordPress blog with a forum  
C) Plug-ins can be used to integrate Twitter with a WordPress blog
D) Plug-ins can be used to embed javascript in a WordPress blog
E) All of the above   (Answer)



Question: A possible way to collect real-time statistics about traffic to a WordPress site is to  
a) use a built-in tool
b) use a plug-in  (Answer)
c) use a widget
d) None of the above

Question: In order to to display a widget, the user must _____
a) Set he “Show Property” of the desired widget to “true”
b) Drag the desired widget of the side bar  (answer)
c) Add the Desired widget to the post
d) Change the source code

Question: Image size can be set __________
a) Directly in the post's
b) in the wp-imageresize plug-in
c) in the admin settings (Answer)
d) a and b

Question: Which of the following blog site can be imported into wordpress?
a) Joomla (Answer)
B) Yahoo Blog (Answer)
c) Drupal (Answer)
d) Blogspot
e) All of the above

Question: Which of the following methods can be used to display the time in every post?
A) Changing the config file
B) Setting the feature in the admin settings
C) Changing the index.php file (answer)
D) Updating the database

Question: Where can Google Adsense be integrated into a WordPress blog?
A) Only in the sidebar (Answer)
B) Only in the header
C) Anywhere
d) Only in the content

Question: Which of the following are true about Template Tags?
A) The template tag comprises of the three tag (PHP code tag, WordPress function, optional Parameters)
B) A template tag is code that instruct WordPress to do or get somethings (Answer)
C) There are only two types of parameters that are supported by wordpress template tag (String, Boolean)
D) All of the above

Question: Which of the following files are mandatory for a WordPress theme?
A) Index.php (Answer)
B) Style.css (Answer)
C) functions.php
D) page.php

Question: Contributor may change the timestamp on a post?
A) True
B) False (Answer)

Question: “Shortcodes” can be defined in WordPress.
A) True (Ture)
B) False

Question: Which of the following statements are true regarding widgets and plug-in in WordPress?
A) Plug-in is a software used to add function to blog (Answer)
B) Widget is an object derived from a plug-in and can be added to the sidebar (Answer)
C) Widgets are alwasy plugins (Answer)
D) All of the above

Question: A plug-in must be used in order to allow users to post flast or multimedia files.
A) True (Answer)
B) Flase

Question: The “function_exist()” function can be used to check whether a plug-in activated or not?
A) True (Answer)
B) False
Question: To manually make the sidebar widget ready, the user must___
A) modify the sidebar.php file (Or this)
B) Enable it in the admin settings (Answer)
C) Change the index.php

Question: A theme's source code must be changed manually in order to customize the admin login page
A) True
B) False (Answer)
 
Question : Which of the following methods can be used to make permalinksSEO friendly?
A) Updating the database
B) Changing the source code
C) Configuring the features in the config file
D) Configuring the features in the admin settings (Answer)  

Question: Which of the following tasks must be performed to add a favicon icon to your site?
A) Upload a favicon icon to your side
B) Add a favicon link to the theme's header file or update the exising favicon icon link to the new one (Answer)
C) Change the favicon icon in admin settings
D) The favicon icon can not be changed

Question: How can a WordPress blog theme be used to display content in two coloumns?
A) By changing the theme options to two columns in admin settings
B) By changing the layout in the config file (Answer)
C) WordPress theme cannot be customized to display posts in two columns
D) By using two-columns theme (Answer)
 
Question: Which of the following are true regarding Pages in WordPress?
A) Pages are listed in reverse chronological order
B) Pages can be static
C) Pages can be found in Categories
D) Page are not associated with a date/time like post  

Question: How can a logo be placed on a WordPress header?
A) Manually add the logo to the source code (answer)
B) Upload a new logo in admin settings
C) Update the logo path in the config file

Question: Which of the following is a good reason to delete the admin account?
A) Because other users know this admin name (Answer)
B) Because it is not necessary
C) To enhance performance
D) TO enhance security (Answer)

Question: Which of the following keywords can be defined as “Those useful ‘one-click‘ buttons that insert code for you?
A) Quicktags (Answer)
B) Shotcodes
C) Permalinks
D) Excerpts

Question: Which of the following methods can be used to add Pagination to a WordPress site?
A) Using a widget
B) Setting the feature in the admin settings
C) Using a plug-in (Answer)
D) Pagination cannot be added to WordPress site
 
Question: Which of the following methods can be used to eliminate spam?
A) Using the “wp-captcha-free” plug-in
B) Using the “askimet” plug-in (Answer)
C) Using a widget
D) None of the above  

Question: Which of the following methods can be used to enable posting via e-mail?
A) Installing the wp-emailpost plug-in
B) Configuring the feature in admin settings (Answer)
C) Using a widget
D) This feature is not available in WordPress

Question: State whether True or False
Wordpress supports all the following:
1. Create new posts
2. Edit Posts
3. Schedule post for future publishing
A) True
B) False
 
Question: Which of the following role level has the highest privilege?
A) Level_0
B) Level_10 (Answer)
C) Depends on your settings
D) Every role has the same privilege

Question: A possible way to add additional information to a wordpress blog post is to ____
A) Use the wp-addinfor plug-in
B) Use custom fields
C) Use a widget

Question: Which of the following actions performed before upgrading WordPress?
A) Back up the site (Answer)
B) Disable plugins (Answer)
C) Enable FTP on the site
D) All of the above
 
Question: You want to schedule a backup of your site database but do not have enough permission to access your host. of the following choices can help you perform this task?
a)se phpMyAdmin
b)Install “wp database backup” plug-in(Answer)
3)Use cron job to schedule.
4)Cannot schedule  

Question: Which of the following needs to be edited in order to creat the function for the shortcode?
A) Index.php
B) functions.php (Answer)
C) post.php
D) page.php

Question: Which of the following arguments are accepted in shortcodes handler function while using shortcode API?
A) $atts
B) $Content
C) $code
D) All of the above (Answer)

Question:A plug-in must be used in order to allow users to post flash of multimedia files.
a)True(Answer)
b)False

Question: Using ——— is a good way to ensure that a WordPress site is indexed by search engines.
a)a sitemap
b)robot.txt
c)a widge

Windows XP oDesk Test Answers 2013

Question 1:There is a better method to enable or disable services on your computer than using msconfig and hardware profiles. When using msconfig, you might disable some services that are necessary to boot the system. Which of the following should be used to enable or disable
services.
a.     Device Manager
b.     Event Viewer
c.     Microsoft Management Console (MMC)
d.     Local Security Policy

The answer is : C. Microsoft Management Console (MMC)


Question2:  What is the key combination to Quit a program through Task Manager that is not responding?    
  a.     Alt + Del      
 b.     Ctrl + Alt + Del      
 c.     Ctrl + Del       
d.     Shift + Alt + Del  
the answer is : D. Shift + Alt + Del
Question3:   Windows XP tracks whatever files that load during every boot and application launches, and the operating system uses that information to prefetch files into RAM. These prefetch data are parsed into a file named __________ located in the Windows\Prefetch folder on the boot drive. Every three days, a limited defragmentation operation automatically occurs in the background during idle for only those files in that file to further speed up the computer's file   access.      
a.     Defrag.sys      
b.     Prefetch.sys     
 c.     Defrag.ini      
d.     Layout.ini  
the answer is :     c.     Defrag.ini

Question4:
Accelerator (hot) keys: Several menu commands, such as File, Edit, Table, or Tools, have one underlined letter as shown. The command associated with the underlined character can be Quickly executed if that character is entered on the keyboard immediately after the _____ key is pressed.

a.     Shift
b.     Alt
c.     Ctrl
d.     Windows
the answer is :     b.     Alt

Question5:
An icon with an arrow in its lower-left corner, which can be clicked for quick access to the object it represents, is a(n):

a.     Application icon
b.     Folder (directory) icon
c.     Document icon
d.     Shortcut icon
the answer is :     b.     Folder (directory) icon

Question6:
A common name given to the bitmapped desktop image (usually a picture) that serves as a background for the entire desktop is:


a.     Wallpaper
b.     Theme
c.     Texture
d.     Mosaic
the answer is :     a.     Wallpaper

Question7:
Which of the following statements about Windows XP features is/are correct?


a.     Windows XP can automatically download updates.
b.     Windows XP offline files allows you to synchronize your files with your file server.
c.     If Fast User Switching is enabled, you cannot use offline files.
d.     There is a "System Restore" functionality within Windows XP.
the answer is :     b.     Windows XP offline files allows you to synchronize your files with your file server.

Question8:
Which of the following is/are valid Window's file names?


a.     expert-rating
b.     expert rating
c.     expert*rating
d.     643764736
e.     expert rating certifications!
the answer is :     a.     expert-rating

Question9:
Which statement(s) about the Recycle Bin is/are correct?

a.     All deleted files except media files are sent to the Recycle Bin.
b.     You can restore any selected files from the Recycle Bin folder by right clicking and then selecting Restore.
c.     The Recycle Bin stores files for one month before permanently deleting them.
d.     More than one file at a time cannot be restored from the Recycle Bin.
the answer is :     c.     The Recycle Bin stores files for one month before permanently deleting them.

Question10:
Which of the following statements about the file security levels while browsing is/are correct?


a.     Low is designed with the minimum safeguards.
b.     Under Low security, active content such as scripting, runs without prompting.
c.     Medium-low is the same as Medium but with less frequent prompts.
d.     Medium is the default security level for the Internet.
e.     All of the above
the answer is :     e.     All of the above

Question11:
Which of the following would be a System Restore feature in Windows XP?


a.     It allows you to take a quick backup of your important data.
b.     It helps you recover data that has been lost due to a hard disk crash.
c.     It allows you to quickly clean up unwanted files, folders, and desktop icons.
d.     It allows you to restore your computer to a previous state in case of a system problem.
e.     It allows you to quickly reinstall Windows XP in case of need.
the answer is :     d.     It allows you to restore your computer to a previous state in case of a system problem.


Question12:
How can you customize Advanced Start menu options in windows XP operating system.


a.     Right click on the Taskbar and click the Customize button.
b.     Right click on the Taskbar, choose Properties, click on Start Menu, and click the Customize button.
c.     Right click on the Taskbar and choose open all users.
d.     Left click on the Taskbar; choose Properties.
the answer is :     b.     Right click on the Taskbar, choose Properties, click on Start Menu, and click the Customize button.

Question13:
You can create and edit files using the Windows Notepad. What are the extensions of a file that has been created using Notepad?

a.     .doc
b.     .text
c.     .txt
d.     .html
the answer is :     b.     .text

Question14:
What happens when you hold down the Windows button key and press the E key?

a.     It opens the Windows Explorer.
b.     It opens the Internet Explorer.
c.     It opens the default search engine.
d.     It opens the color settings.
the answer is :     a.     It opens the Windows Explorer.

Question15:
You are logged in as an administrator to the computers on your small local network and you want to change the names of those computers and the workgroup so that their names are more informative. One way to change the names would be to:
a.     Open the System control panel. Select the System tab and then click Change. Enter the desired name for the computer and click OK.
b.     Open the System control panel. Select Change Name from the Edit menu and then click Change Name. Enter the desired name for the computer and click OK.
c.     Right click the Desktop and select Personalize. Select the Computer Name tab and then click Change. Enter the desired name for the computer and click OK
d.     Open the Performance and Maintenance control panel. Select the Computer Name tab and then click Change. Enter the desired name for the computer and click OK.
e.     Right Click on My Computer icon, choose properties and select tab 'Computer Name' or(use run command and put sysdm.cpl) and click on the Change button. Enter the desired   name for computer and click OK.

the answer is :      d.     Open the Performance and Maintenance control panel. Select the Computer Name tab and then click Change. Enter the desired name for the computer and click OK.

Question16:
The _____________ is a large hidden file where Windows XP finds information about all of the hardware, software, and various settings and user options.

a.     Windows Registry
b.     Finder
c.     Preferences
d.     Windows SysOps
the answer is :     c.     Preferences

Question17:
Which of the following activities can you accomplish with the Remote Desktop feature in Windows XP?

a.     You can get a miniature view of your desktop by clicking on the Desktop icon.
b.     You can automatically clear up unwanted Desktop icons.
c.     You can view files and documents on your computer's desktop from a coworker's computer.
d.     You can view files and documents on any computer's desktop from your computer.
the answer is :     c.     You can view files and documents on your computer's desktop from a coworker's computer.

Question18:
The hard-drive utility tool in Windows XP for automatically fixing file system errors or for searching for and attempted recovery of bad sectors is:

a.     CheckDisk (CHKDSK)
b.     SystemCheck (SYSCHK)
c.     DiskFix (DSKFX)
d.     DiskScan (DSKSCN)
the answer is :     a.     CheckDisk (CHKDSK)

Question19:
By hovering the mouse pointer over the clock, what happens?

a.     It displays the time in a bigger font.
b.     It will speak out the time through the speaker connected to the computer.
c.     It will show the time in analog format.
d.     It will display the current day of the week and the date.
the answer is :     b.     It will speak out the time through the speaker connected to the computer.

Question20:
The left side of the Start menu contains two parts, separated by a thin horizontal line. The Windows XP term for manually inserting a shortcut to one of your chosen applications into the top part of the left side (by using the right-context menu of the application in Windows Explorer) is called:

a.     Attaching an application to the Start menu.
b.     Pinning an application to the Start menu.
c.     Placing an application into the Start menu.
d.     Porting an application to the Start menu.
the answer is :     d.     Porting an application to the Start menu.

Question21:
Which of the following statements about Windows XP Internet Connection Sharing (ICS) is/are true?

a.     Using ICS, you can connect different computers to the Internet using just one dial-up connection, however you require at least two modems.
b.     You require a router for using ICS.
c.     Using ICS, a single computer can connect to more than one dial-up connection.
d.     Using ICS, a single computer can connect to a dial-up and DSL connection simultaneously.
e.     Using ICS, multiple computers can connect to the Internet through only one dial-up connection.
the answer is :     c.     Using ICS, a single computer can connect to more than one dial-up connection.

Question22:
The older version of the Windows XP Desktop is called the "Windows Classic" look. One way to get the Windows Classic Desktop from the new default Windows XP Desktop is to:

a.     In the System control panel, select Properties from the View menu. Select the Desktop tab and click on the Desktop pull-down list and select Windows Classic. Click OK.
b.     Right-click on the desktop and choose Properties. Select the Themes tab and click on the Theme pull-down list and select Windows Classic. Click OK.
c.     In the Display control panel, select Properties. Select the Desktop tab and click on the Theme pull-down list and select Windows Classic. Click OK.
d.     Right-click on the desktop and choose Themes. Select the Desktops tab and click on the Desktop pull-down list and select Windows Classic. Click OK.
the answer is :     a.     In the System control panel, select Properties from the View menu. Select the Desktop tab and click on the Desktop pull-down list and select Windows Classic. Click OK.

Question23: Starting with Windows 95, the File Manager tool for organizing and controlling the files and folders of the computer's storage systems, such as the hard drive(s) and disk drive(s) has been called:

a.     Windows Manager
b.     Internet Explorer
c.     Windows Explorer
d.     Windows Task Manager
the answer is :     c.     Windows Explorer

Question24:
Windows XP includes a new type of view for folders that contain graphics files. This folder view is called _________ and displays small images of all the graphics in the folder in the bottom right-hand pane of Windows Explorer and a large image of a selected picture in the top right-hand pane.

a.     Gallery
b.     Images
c.     Pictures
d.     Filmstrip
the answer is :     d.     Filmstrip

Question25:
What happens when you choose ClearType for your screen fonts in Windows XP?

a.     Only the black and white text will be visible.
b.     Only the text in primary colors will be visible.
c.     The font resolution is improved.
d.     The font size will automatically adjust to the screen area of the monitor.
the answer is :     b.     Only the text in primary colors will be visible.

Question26:
Which of the following statements regarding Windows XP user access is/are correct?

a.     Multiple users cannot switch between accounts without restarting the computer.
b.     Multiple users can switch between accounts without restarting the computer.
c.     Windows XP does not support multiple user access.
d.     None of the above
the answer is :     d.     None of the above

Question27:
With Windows XP, the default display resolution is 800x600 in 32-bit true color. With some computers 32-bit video tends to slow down screen redraws. How could you drop the screen depth to 16 bits instead of 32 bits in order to speed up the display in older PCs, especially laptops?


a.     In the Colors control panel, set the Colors option to Medium (16 bits).
b.     In the Color Management control panel, set the Color depth to Medium (16 bits).
c.     In the System control panel, set the Monitor depth to 16 bits.
d.     In the Display Properties dialog box, on the Settings page, set the Color quality option to Medium (16 bits).
the answer is :     d.     In the Display Properties dialog box, on the Settings page, set the Color quality option to Medium (16 bits).

Question28:
A new function of Windows XP that allows two or more users in a local network to use only one Internet connection by routing all the Internet traffic through one computer is called __________________.

a.     Internet Routing
b.     Windows Internet Sharing (WIS)
c.     Internet Connection Sharing (ICS)
d.     Windows Connection Sharing (WCS)
the answer is :     b.     Windows Internet Sharing (WIS)

Question29:
Which of the following statements is/are correct regarding the grouping of Windows tabs?

a.     Only Windows of the same program can be grouped into one tab.
b.     You can group windows of all open programs into one tab.
c.     You can group windows of only two programs at a time.
d.     There is no option to group tabs in Windows XP.
the answer is :     d.     There is no option to group tabs in Windows XP.

Question30:
Microsoft makes available a tool called the _____________________ for checking computers with a Windows operating system. This tool helps remove infections left by third-party software installed on the computer and displays a report describing the outcome in a log file named mrt.log in the %WINDIR%\debug folder.

a.     Microsoft Reliability Tool
b.     Microsoft Windows Malicious Software Removal Tool
c.     Microsoft Windows Antivirus Tool
d.     Microsoft Recovery Tool
the answer is :

Question31: Windows XP usually retains copies of old drivers when newer versions of them are installed or upated. If the new drivers have problems, the user can return to the previous version. Does this new Windows XP feature work with printer drivers?

a.     Yes
b.     No
the answer is :     a.     Yes

Question32:
Windows XP has a new user system. Its new user system:

a.     Was inherited from Windows 98.
b.     Was inherited from Windows 3.x.
c.     Was inherited from Windows NT/2000.
d.     Was not inherited from any prior Windows O/S.
the answer is : a,c,d

Question33:
A new feature introduced in Windows XP that allows another user to log in and use the system without having to log out the previous user and Quit any running applications is known in Windows XP as:

a.     Multiple user login
b.     Simulcasting
c.     Fast user switching
d.     Multiprocessing
the answer is :     c.     Fast user switching

Question34:
The Windows XP installs its search function that, by default, has an animated dog character, Rover. Which of the following is/are true?

a.     Rover could be replaced with another animated character or with no character at all.
b.     Rover cannot be replaced by another character. It is a permanent feature.
c.     Rover could be replaced by another character, but another animated character must be used (instead of having no character at all).
the answer is :     b.     Rover cannot be replaced by another character. It is a permanent feature.

Question35:
What does the Desktop Cleanup Wizard do?

a.     It removes suspected virus shortcuts from the desktop.
b.     It removes the desktop wallpaper.
c.     It removes the desktop shortcuts that have never been used.
d.     It sends all the desktop icons to the Recycle Bin.
the answer is :     b.     It removes the desktop wallpaper.

Question36:
Windows XP has several command-line utility tools for troubleshooting the computer. Suppose that your computer seems to have a problem with connecting to the Internet. Before reporting your connectivity problems to your ISP, which tool could you use to display the current TCP/IP network configuration values and to refresh the Dynamic Host Configuration Protocol (DHCP) and Domain Name System (DNS) settings?

a.     Ping
b.     Ipconfig
c.     Tracert
d.     Msconfig
the answer is :     b.     Ipconfig

Question37:
Which key combination would you use to flip between open windows?

a.     Alt + Shift
b.     Alt + Tab
c.     Ctrl + Tab
d.     Ctrl + Alt
the answer is :     a.     Alt + Shift

Question38:
What type of icons are displayed in the system tray?

a.     Icons of media-related programs.
b.     Icons of programs developed by Microsoft.
c.     Icons of programs that are loaded into memory.
d.     All of the above
the answer is :     b.     Icons of programs developed by Microsoft.

Question39:
Which of the following statements about icons on the desktop is correct?
a.     You can rename an icon by left-clicking the mouse button and selecting Rename.
b.     You can rename an icon by right-clicking the mouse button and selecting Rename.
c.     You can delete an icon by left-clicking and selecting Delete.
d.     You cannot rename an icon.
the answer is :     b.     You can rename an icon by right-clicking the mouse button and selecting Rename.

Question40:
State whether the following statement is true or false.
With Windows XP, you cannot specify that files with certain file name extensions should always open in the same program.

a.     True
b.     False
The answer is :     a.     True

US English Basic Skill oDesk Test Answers 2013

Question 1:   Choose the series of prepositions that best completes the following sentence.
Charlotte knew________the secret investigation_________her past, but she closed her eyes to it and pretended it wasn't happening.
Answer:   a. of, about

Question 2:   Choose the series of adjectives and adverbs that best completes the following sentence.
I think Pamela deserves to be punished for her________stupid and________behavior.
Answer: b. totally, irresponsible

Question 3:

Which of the following sentences punctuated correctly?
a. Tracy bought three suits; seven scarves; and ten pairs of shoes.

Answer: b. We are expecting a hurricane this afternoon, therefore we have closed the school early.


Question 4:

Choose the series of adjectives and adverbs that best completes the following sentence.
While_________of our relatives live on the__________hill in the county, _________of our friends live in the _________areas of the valley.

Answer: c. many, windiest, most, more, protected


Question 5:

Complete the following sentence by choosing the phrase with the best word order from the options given.
Those who are not wise_____________.

Answer: d. does not need to be necessarily stupid.


Question 6:

Choose the series of pronouns that best completes the following sentence.
Don't _________think Larry should call__________wife if______________is going to be late for dinner?

Answer: a. you, his, he


Question 7:

Rearrange the following words to create most logical and grammatically correct sentence.
days for last has good weather few The been the not

Answer:d. The weather has not been good for the last few days


Question 8:

Choose the series of adjectives and adverbs that best completes the following sentence.
Knowing that February was the___________month of the year, Cheryl planned her vacation____________.

Answer: b. shortest, accordingly

Question 9:

Rearrange the following words to create most logical and grammatically correct sentence.

Answer: e. Whenever I can't spend time with my friend, I always speak to him on the phone.

Question 10:

Read the following question and choose the response that uses the correct corresponding verb tense.
Does Jack wear that furry hat often?

Answer: d. No, he only wears it when his ears are cold.

Question 11:

Which of the following sentence illustrates correct pronoun usage?
a. is those the set of plates the bride wanted, or did she want this set?
d.Whose book is that-his or our?

Answer: e. None of the above

Question 12:

Which of the sentence illustrates proper sentence structure?
a. Everyone knows that a mango is much sweeter to an orange

Answer: d. The queen had hardly finished her speech when the people began to disperse.

Question 13:

Change the following sentence from a quotation to indirect speech.
“It may snow tomorrow.” he said.

Answer: d. He said it might snow tomorrow.

Question 14:

Which of the following sentence punctuated correctly?

Answer: d. “Come here.” she said, “and let me get a good look at you.”

Question 15:

Change the following sentence from a quotation to indirect speech.
“ Sharon must go to the bank today.” said Albert.

Answer: d. Albert said Sharon had to go to the bank today.

Question 16:

Choose the option that correctly changes original sentence from active to passive.
ORIGINAL SENTENCE:
That tall man is carrying a lot of lumber.
REWRITTEN SENTENCES:

Answer: d. A lot of lumber is being carried by that tall man.

Question 17:

Choose the series of prepositions that best completes the following sentence.
I placed my notes__________my desk and referred to them____________ the meeting.

Answer: b. beside, during

Question 18:

Rearrange the following words to create most logical and grammatically correct sentence.
Sleeping likes the . midday Katie until on weekends

Answers: Katie likes sleeping until midday on the weekends.

Question 19:

Choose the series of verbs that best completes  the following sentence.
Everyone ____________too busy cooking and __________ the campsite ____________ the family _________ from the woods.

Answers: d. was, setting up, to notice, watching

Question 20:

Choose the series of verbs that best completes  the following sentence.
I find it very hard to remember ______________ letters that are entrusted to me. In fact, I remember_____________to do so dozens of times!

Answer: d. mailing, forgetting

Question 21:

Choose the series of articles and conjunctions that best completes  the following sentence.
Lilacs ___________ violets are usually purple, I have seen some _________ are white.

Answer: c. and, although, that

Questions 22:

Complete the following sentence by choosing the phrase with the best word order from the options given.
Only after they had an exhaustive study__________ how to adapt the technology to the needs of our company.

Answer: c. they did begin to understand

Question 23:

Which of the following sentence illustrates proper use of comma?
a. Randy wanted to end the meeting, but Amy wanted to prolong it.

answer: e. a and b

Question 24:

Which of the following sentence does NOT illustrates correct verb and tense usage?

Answer: b. Clarabelle's mother absolutely hated nicknames and always calls her daughter by her full name.

Question 25:

Choose the series of prepositions that best completes the following sentence.
Victor, who stole ____________ ideas and used them  to make _________ a millionaire, never once offered ______________ a world of thanks.

Answer: d. our, himself, us

Question 26:

Choose the series of prepositions that best completes the following sentence.
______________ is the name of the opera, and ___________ role did you say Maria would play?

Answer: c. What, which

Question 27:

Choose the verbs and phrases that best completes the following sentence.
This dish _____________ too spicy. Why ___________ so pepper?

Answer: e. a and c

Question 28:

Change the following sentence from a quotation to indirect speech.
Carol has said, “I am responsible for this project.”

Answer: a. Carol has said that she is responsible for this.

Question 29:

Choose the series of prepositions that best completes the following sentence.
Although Marvin said he had the keys___________ the flower pot, we were unable to find them___________ the dark. In the end, we waited for him at the coffee shop ____________ the corner.

Answer: a. under, in. around

Question 30:

Complete the following sentence by choosing the phrase with the best word order from the options given.
The excited children who had run toward the loud _______________.

Answer:d. music, told the others about the ice cream truck outside.

Question 31:

Rearrange the following words to create most logical and grammatically correct sentence.
your company name? of what the is

Answer: c. What is the name of your company?

Question 32:

Which of the following sentences NOT punctuated correctly?
a. All of the apple's at the grocers were rotten so I bought oranges instead.

Answer: b. “Seven canteens full of water should enough for the hike,” said Tabitha.

Question 33:

Choose the series of prepositions that best completes the following sentence.
After realizing that our hosts hadn't actually invested _________ to ____________ party. ____________ excused ____________ from the table and slipped out the back door.

Answer: a. us, their, we, ourselves.

Question 34:

Which of the following sentences illustrates the proper use of parallel construction?

Answer: b. We painted the conference room yellow, hung a poster on the wall, and are rearranging the chairs.

Question 35:

Which of the following sentence uses correct pronoun usage?
a. to whom are your employees going to report while you're gone?

Answer: e. All of the above

Question 36:

Choose the series of adjectives and adverbs that best completes the following sentence.
The archeologists were_____________ to discover such a __________ and__________ ____________ artifact at that mostly uncovered site.

Answer: b. amazed, rare, incredibly, beautiful

Question 37:

Change the following sentence from a quotation to indirect speech.
“I'm not feeling well,” Agatha said.

Answer: a. Agatha has said that she doesn't feel well.


Question 38:  

Choose the series of adjectives and adverbs that best completes the following sentence.
The helium _______ balloon rose ________ into the air; the villagers knew then their _______ leader was off on another mission.

Answer: powered, powerfully, powerful.

Question 39:  

Rearrange the following words to create the most logical and grammatically correct sentences.
Would I have it anything if had, I you known said would not bother


Answer: b I would not have said anything if I had known it would bother you


Question 40:  

Rearrange the following words to create the most logical and grammatically correct sentences.
Last what ! It's did you night, over After

Answer: b After what you did last night, it's over!

Question 41:  

Which of the following sentences does not illustrates correct pronoun usage?

Answer: e all are correct

Question 42:

Which of the following sentences illustrates correct verb and verb tense usage?

Answer: b and d  We think the judge will have noticed something strange in her behavior , Somehow, all of the newspapers gotten hold the story.

Question 43:


Change the following sentence from a quotation to indirect speech.
Rhonda says, “I get to work early every day.”

Answer: c Rhonda has said that she got to work early every day.

MS Word 2007 oDesk Test Answers 2013

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.

Microsoft Office Excel 2007 oDesk Test Answer 2013

SET 01 
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: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

Q: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: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:How does the AutoComplete feature in Excel help you save time?
Ans:   It automatically completes abbreviated words  

Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans:   Apply the Text Format to empty cells, and then type the numbers

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

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  

SET 2
 
Q9: Which among the following is not true regarding a calculated column?
d. Additional formulae cannot be entered in a calculated column as exceptions
Q1: when a part of a formula is replaced with its calculated value, it cannot be restored.
a. True.

Q2: When you sign the stamp signature line in an office document, you add both a visible stamp and a document signature.
a. True
Q3: Refer to the given image, what will be the result if the formula =B3&”, ”&A3 is applied to the given table?
d. Both b and c

Q4: How will you reverse the direction of a Smart art graphics?
c. Under SmartArt tools, on the Design tab, in the Create Graphic group, click on Right to Left

Q5: Which of the following chart have no axes?                     
c. C-both a and b

Q6: Which of the following is not true regarding column width?
d. all of the above are true

Q7: Which chart type is displayed in the given picture?
b.A surface chart

Q8:What does the red icon indicate as shown in the given picture?
b.  it tells the user that the document contains signatures

Q10: What does the screen tip displaying “Showing all” mean?
a. It means that a filter has been applied.

Q11: Which chart displays axes but can not display axis titles?
a. Radar chart

Q12: Which file format is typically used to remove printer corruption?
c. SYLK format

Q13: Which of the following methods would you follow to remove subtotals?
a. On the Data tab, in the Outline group, click on Subtotal. The subtotal dialog box is displayed. Click Remove all

Q14: When does triangle appear in the Top-left corner of the cell, as shown in the picture?
c. When there is an error in the formula
 
Q15: Which lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?
b. VLOOKUP

Q16: Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?
c. Scoping by value field

Q17: Where can the “Show all comments” command be found?
c. On the Review tab

Q18: Which of the following is not true about an offline cube file
b. The file format for an offline cube file is .CUE

Q19: What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
b. It signifies that the cell contains a comment.

Q20: Which of the following is not true regarding naming a cell?
a. Names are case sensitive.

Q21: Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?
a. A    (MAP NETWORK DRIVE)

Q22: Which of the following charts shows numerical values on the vertical (value) axis and textual groupings (or categories) on the horizontal axis?
c. Area charts

Q23: Which of the following options would you choose to clear a PivotChart report?
a. On the Analyze tab, in the Data group, click on Clear and then click “Clear All”.

Q24: Which of the following wildcard characters can be used as comparison criteria for Text Filters?
d. All of the above.

Q25: Which tab should be used to display or hide axes?
b. Layout tab

Q26: When would you use smart graphic?
a. List information b. create a matrix illustration c. Show a relationship between parts, such as overlapping concepts

Q27: Which tab is required to work with Macros?
b. Developer tab. e. View tab

Q28: Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
b. B General options

Q29: Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have change3d since the last time?
d. None of above.

Q30: Refer to the given image Which line style option should be used to specify the style used for the end  of the line?
c. C

Q31: Which of the following is not true about the Watch Window?
c. There can be two Watch windows per cell.

Q32: How would you select an entire PivotalTable report?
b.  On the Options tab, in the Actions group, click Select, and then click Entire PivotTable.

Q33: A Macro can be digitally signed.
a. True

Q34: What would be the result, when =T(A4) is applied on the given table?
a. The text TRUE is returned

Q35: When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
a. True

Q36: Which among the following options displays Legend entries in the given picture?
c. C

Q37: What is the purpose of using the Keep text flat option, as shown in the picture?
a. It prevents the text inside the wordart from rotating when rotate wordArt is rotated.

Q38: Which of the given methods would you follow to add an alternative text to a picture?  
a. Right-click the picture, click Size and Properties.Click the Alt Text tab, and then in the Alternative text box, enter your text.

Q39: Some data is to be refreshed in an imported XML file. Where can the command on the Ribbon be found?
c. On the Developer tab

Q40: Refer to the given image Which of the following password options uses an encryption method?
c. Both a and b

SET 3
 
Q2: Refer to the given picture, which option causes the last row in the table to appear and displays the word Total in the leftmost cell?
b. B  (total row)

Q3: What is the option on the Document Inspector that finds the content type information?
c.  Document Properties and Personal Information

Q7: How will you find cells with data validation?
a. On the Home tab, in the Editing group, click the arrow next to Find & Select,, then click Go -To Special. Click on Data Validation, and then click All

Q8: For XY (scatter) and bubble charts, error bars for the x values, the y values , or both can be displayed.  
a. true

Q9: How should blank cells be inserted on a Worksheet?
c. Both a and b

Q11: Case-sensitive sorting of text in Excel2007 can be performed.
a. True

Q12: Which of the following is true about a freeform shape?
d. All of the above is true

Q13: Which keyboard shortcut should be used to enter the current time?
b. CTRL+SHIFT+:

Q:20 Deleting the PivotChart report automatically deletes the associated  PivotTable report.
b. False

Q21: Which of the following is a default method of a PivotTable report for scoping the conditional format of a fields in the values area?
a. By selection

Q22: Which method will you use to update table data from a Sharepoint list?
c. In the Design tab, On the External Data Tools group, Click Refresh

Q23: How will you display the Go To dialog box?
b. You will press F5

Q25 Which part of the formula displays references in the given picture?
b. B

Q27: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
a. Automatically updated properties

Q29: Which keyboard shortcut should be used to minimize or restore the ribbon?
c. CTRL+F1

Q32: When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
a. True

Q33: If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic
a. True

Q34: Which of the following operators is not a type of calculation operator?
d. equation

Q36: Which Consolidate option would you choose when you want to arrange data in all the worksheets in identical order and location?
a. Consolidate by position

Q38: Which option would you choose to display a list of formula used in the current PivotTable report?
c. On the Options tab, in the Tools group, click on Formula, and then click “List Formula”

Q39: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
-Automatically updated properties  

Q40: When does the error, as shown in the picture, occur?  
d. All of the above.

Q41: Refer to the given, What is the purpose of the cell denoted as 'A' in the worksheet?
a. It selects all the cells in the worksheet.

Q42. Refer to the given image, which formula should be written on the given table to display "Nancy Davolio"?
c. =PROPER(A2)   

Q43: How would you assign a Macro to a graphic
c.  On the worksheet, right-click on the graphic, then click "Assign Macro" on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

Q44: No data is deleted when an outline is hidden or removed.  
a. True.

Q45: Refer to the given image, which of the following Fill options should be used to add color and transparency to a shape?  
a. A    (No fill)

Q46: Which among the following settings is the default macro setting?
c. Disable all macros with notification.

Q47: Which type of additional information is stored within the digital signature?
d. All of the above.

Q48: When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?      
d. It enters the time as AM.

Q46: Which of the following is not a valid file extension in which an Excel file can be saved?
c. PXL

Q47: When would the data validation command be unavailable on the data tab?   
d. All of the above.

Joomla 1.5 oDesk Test Answer 2013

1) The index.php file is a combination of HTML and PHP code.
Odesk test answer: True

2) What is the default super administrator account for Joomla called?
Odesk test answer: Administrator


3) Which of the following PHP directives are important to Joomla execution to define an alternate compression library if the standard library is not available?
Odesk test answer: extension_dir

4) Which of the following files is archive and contains the actual CB component that you must install into Joomla while downloading CB?
Odesk test answer: com_comprofiler

5) Which option will you choose to set the site metadata for the installed website?
Odesk test answer: Global Configuration

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

7) The core editor events apply to plug-ins that provide editor functionality such as TinyMCE or XStandard Lite.
Odesk test answer: True

8) Which PHP file does the index.php file load to provide the menu bar to the administrator interface?
Odesk test answer: Toolbar.php

9) Which of the given database systems is supported by Joomla?
Odesk test answer: Mysql
10) Which of the following is the default editor of Joomla?
Odesk test answer: TinyMCE
11) Joomla provides an abstracted method called getEscaped() that returns the escaped string regardless of the target database.
Odesk test answer: False

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

13) What is not true about JoomlaXplorer?
Odesk test answer: None of the above

14) Which of the following is a system event?
Odesk test answer: OnDisplay

15) Which Joomla file provides the central logic of the template, including any module and component display?
Odesk test answer: Index.php

16) When will you use SMTP authentication mail settings?
Odesk test answer: When you want to use an internal mail server

17) What do you understand by the type of error?
Odesk test answer: It means that STRICT_ALL_TABLES is enabled

18) Which path variable holds the path of the currently executing application?
Odesk test answer: All of the above

19) Which user events occur with plug-ins that are installed for the front end of the system?
Odesk test answer: Both a and b

20) Which type of positioning elements define a concrete area such as a p, td, div or table in a CSS file?
Odesk test answer: Block elements

21) Which of the following files does the "/includes" directory not contain?
Odesk test answer: None of the above

22) Which option will you select to install or to add the module to your website?
Odesk test answer: C

23) Why does Joomla use templateDetails.xml files?
Odesk test answer: All of the above

24) Which of the following events is activated after content rendering is complete for content type plug-ins?
Odesk test answer: OnAfterDisplayContent

25) All the Joomla settings are contained within a PHP class called JConfig.
Odesk test answer: True

26) In which PHP file is the central configuration data for Joomla contained?
Odesk test answer: configuration.php

27) What is not true about the MD5 hash value?
Odesk test answer: Each password in Joomla is stored as a MD5 hash value

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

28) Which option will you select to find unpublished articles?
Odesk test answer: Article manager

29) What do you understand from the following code?
Odesk test answer: SQL statement is executed against the Joomla database to find empty data fields

30) Which SEO settings will you activate to make Joomla article URL shown in picture A appear as shown in picture B?
Odesk test answer: B

31) In which option are errors, warnings and references logged?
Odesk test answer: None of the above

32) Which type of files can media manager not upload?
Odesk test answer: None of the above

33) Which among the following switches display the current version of PHP?
Odesk test answer: v

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

35) Which type of server technology is used by Joomla?
Odesk test answer: All of the above

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

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

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

39) What is the role of the template metadata file in the system?
Odesk test answer: It contains the basic authorship information

CSS oDesk Test Answers 2013

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

Ans: A 

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

Ans: D 

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

Ans: C

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

Ans: C

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

Ans: B 

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

Ans: D 

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} 

Ans:B

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 

Ans:A

Question 24: Which of the following is not a pseudo class? 

       a.    Link 

       b.    Active 

       c.     Lang 

       d.    Ins 

Ans:D

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 

Ans:B

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 

Ans:A

Question 27: The font-family property is used to specify a: 

a.            Family name 

b.            Generic Family 

c.            Family name and /or generic Family 

Ans:A

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 

Ans:D

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 

Ans:D

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 

Ans:E

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 

Ans:C

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 

Ans:A

Question 33: How will you display text as a superscript? 

a.            Vertical-align: super 

b.            Vertical-align: superscript 

c.            Vertical-align : top 

Ans:A

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. 

Ans:C

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 

Ans:B

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 

Ans:D