oDesk MS Excel 2007 Test Answers: 5

Microsoft Excel 2003 or 2007 Test
Read the Online Testing Policies and the instructions below prior to taking the test.
This test will cover the following topics:
Excel Fundamentals
Entering Data into Worksheets
Formatting Excel Worksheets
Excel In-built Features
Formulas and Calculations using Excel

SET 1: SL NO. 01 TO 25 

SET 2: SL NO. 26 TO 50

SET 3: 51 TO 75

SET 4: 76 TO 100  

SET 5: 101 TO 125 RUNNING

SET 6: 126 TO 150

SET 7: 151 TO 176

Hello Friends, How to pass in the oDesk MS Excel 2007 Test Answers.
This is an effective common test you should take for you to bid at the oDesk Job market places.
Below are list of questions and answers shown easily.
This is your likely site.
Its all are oDesk Success Guides, Tips and Totally oDesk solution of all Freelance Jobs Success Info.

Question 101: Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
a.     By selection
Ans: b. By corresponding field
Ans: c. By value field
d.        By number field

Question 102: 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
Ans: b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas

Question 103: Which of the following is not a valid file extension in which an Excel file can be saved?
a.     XLSB
b.     XLSM
Ans: c. PXL
Ans: d. All of the above are valid

Question 104: Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
Ans: a.     A (No fill)
Ans b.     B
Ans: c.     C
d.     D

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

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

Question 107: Which tab is required to work with Macros?
Ans: b. Developer tab. e. View tab

Question 108: State whether true or false:
Case-sensitive sorting of text in Excel2007 can be performed.
Ans: a. True
b. False

Question 109: State whether true or false:
A Macro project can be digitally signed.
Ans: a.     True
Ans: b.     False

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

Question 111: Deleting the PivotChart report automatically deletes the associated  PivotTable report.
Ans: b. False

Question 112: Which of the following is a default method of a PivotTable report for scoping the conditional format of a fields in the values area?
Ans: a. By selection.
Ans: b. By corresponding field.
c. By value field.
d. By number field.

Question 113: Which of the given Document properties includes both file system properties and statistics that are maintained by Office programs for the user?
Ans: a. Automatically updated properties
b. Standard properties
c. Custom properties
d. Properties for the organization

Question 114: 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 115: How will you reverse the direction of a SmartArt graphic?
Ans: -Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to

Question 116: 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'
b.     On the Options tab, in the Actions group, click on Clear, and then click??'Clear All'
c.     Both a and b
Ans: d.     None of the above

Question 117: For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
Ans: a. True
b. False

Question 118: 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?
Ans: 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

Question 119: How can a chart be modified?
a.         By modifying a legend
b.         By modifying the display of chart axes
Ans: c. By modifying titles and data labels
Ans: d. All of the above

Question 120: When would the data validation command be unavailable on the data tab?
a.         When an Excel table is linked to a SharePoint site
b.         When data in a cell is entered
Ans: c. When the workbook is shared or protected
Ans: d. All of the above

Question 121: Which option would you choose to display a list of formula used in the current PivotTable report?
a. On the Options tab, in the Tools group, click on Formula, and then click ‘Solve Order’”
b. On the Formula tab, in the Function library, click ‘Show Formula’
Ans: c. On the Options tab, in the Tools group, click on Formula, and then click ‘List Formula’
d. None of the above

Question 122: Which type of additional information is stored within the digital signature?
a. Date information
b. Time information
c. The Office version number of the program in which the file was created
Ans: d. All of the above

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

Question 124: Which database function estimates variance based on a sample from selected database entries?
a. DSTDEV
b. DSUM
Ans: c. DVAR
d. DVARP

Question 125: Which of the following options is not available on the Status bar?
a. Cell mode
Ans: b. Selection mode
d. End mode
Ans e. Start mode

Please Comments, Love and follow me.