oDesk MS Excel 2007 Test Questions & Answers 2013-14_Step: 4
oDesk MS Excel 2007 Test & Answers 2013 (Step: 4)
This is an effective advance test you should take for you to bid at the oDesk Job Market. If you follow this answers you will 100% pass in this exam. Below are list of questions and answers. This site is for oDesk Success Guides and Tips, oDesk Sample Tests and Answers and Freelance Jobs Success Info. Here is also available all kinds of results & services of Bangladesh.This is an effective advance test you should take for you to bid at the oDesk Job market. Below are list of questions and answers Please read be familiar with sample questions.
If you follow this oDeks Microsoft Excel test's answers and take part in this test, you can earn 100% of the test in the first place. The answers to all these questions is 100% true.
Thank you for visit this site. Don't forget to give me a like or comment on Facebook.
Answers are Highlighted by :::::::::::::: yellow color.
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: You Can Also Choose Best & Latest Answers For This:
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
How can a chart be modified?
-By modifying a legend
-By modifying the display of chart axes
-By modifying titles and data labels
-All of the above
This question is based upon the figure shown belowWhen does the triangle appear in the top-left corner of the cell, as shown in the picture?
-When the cell contains hidden information
-When the cell contains the Time function
-When there is an error in the formula
-None of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
Which chart displays axes but cannot display axis titles?
-Radar chart
-Doughnut chart
-Pie chart
-All of the above
How will you reverse the direction of a SmartArt graphic?
-Right-click on the SmartArt graphic, select Reverse
-Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
-Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
-All of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
How would you locate the last cell on a worksheet?
-Click anywhere in the worksheet, and then press CTRL+HOME
-Click anywhere in the worksheet, and then press CTRL+INSERT
-Click anywhere in the worksheet, and then press CTRL+END
-None of the above
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
-Consolidate by position
-Consolidate by category
-Consolidate by formula
-None of the above
Which of the following options is not available on the Status bar?
-Cell mode
-Selection mode
-End mode
-Start mode
-By modifying a legend
-By modifying the display of chart axes
-By modifying titles and data labels
-All of the above
This question is based upon the figure shown belowWhen does the triangle appear in the top-left corner of the cell, as shown in the picture?
-When the cell contains hidden information
-When the cell contains the Time function
-When there is an error in the formula
-None of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
Which chart displays axes but cannot display axis titles?
-Radar chart
-Doughnut chart
-Pie chart
-All of the above
How will you reverse the direction of a SmartArt graphic?
-Right-click on the SmartArt graphic, select Reverse
-Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
-Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
-All of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
How would you locate the last cell on a worksheet?
-Click anywhere in the worksheet, and then press CTRL+HOME
-Click anywhere in the worksheet, and then press CTRL+INSERT
-Click anywhere in the worksheet, and then press CTRL+END
-None of the above
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
-Consolidate by position
-Consolidate by category
-Consolidate by formula
-None of the above
Which of the following options is not available on the Status bar?
-Cell mode
-Selection mode
-End mode
-Start mode
Comments
Post a Comment