oDesk MS Excel 2007 Test Answers: 2

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

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.

SET 1: SL NO. 01 TO 25 

SET 2: SL NO. 26 TO 50 Running

SET 3: 51 TO 75 

SET 4: 76 TO100

SET 5: 101 TO 125 

SET 6: 126 TO 150

SET 7: 151 TO 176

Question 26: 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?
a.         Scoping by selection
Ans: b.         Scoping by corresponding field
Ans: c.         Scoping by value field
d.         All of the above

Question 27: Which Consolidate option would you choose when you want to arrange the data in all the worksheets  in identical order and location?
Ans;  a. Consolidate by position
b.         Consolidate by category
c.         Consolidate by formula
d.         None of the above

Question 28: Which method will you use to update table data from a Sharepoint list?
a.         On the Data tab, in the Data Tools group, click Refresh
b.         On the View tab, in the Show/Hide group, click Refresh
Ans: c. On the Design tab, in the External Data group, click Refresh
Ans: d. In the Design tab, On the External Data Tools group, Click Refresh
e.         None of the above

Question 29: To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Ans: False

Question 30: Which of the given methods would you follow to add an alternative text to a picture?
Ans: a.        Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
Ans: b.        Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
c.        Both a and b
d.        None of the above

Question 31: Which of the following is not true about an offline cube file?
a.         It stores data in the form of an OLAP cube
Ans: b. The file format for an offline cube file is .CUE
c.         It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable

Question 32: Which among the following is not true regarding a calculated column?
a.         It uses a single formula that adjusts for each row
b.         It automatically expands to include additional rows
c.         A formula is required to be entered only once in a calculated column
Ans: d. Additional formulae cannot be entered in a calculated column as exceptions

Question 33: Which of the following is not true regarding column width?
a.         If the column width is set to 0, the column is hidden
Ans: b. A column width between 0 to 255 can be specified
c.         The default column width is 8.43 characters
Ans: d. All of the above are true

Question 34: Which of the following is not true regarding naming a cell?
Ans: a. Names are case sensitive
b.         A name can contain up to 255 characters
c.         Names can contain uppercase and lowercase letters
Ans: d. Some keyboard characters can cause unexpected results if used in cell names

Question 35: Which of the following methods would you follow to remove subtotals?
Ans: a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
b. On the Data tab, in the Data Tools, select Remove Subtotals
Ans: c.  Both a and b
d.     None of the above

Question 36: Deleting the PivotChart report automatically deletes the associated PivotTable report.
a.         True
Ans: b. False

Question 37: If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
Ans: a.         True.
Ans: b.         False.

Question 38: Which of the following is not a tab on the Chart Options dialog box?
Ans: Patterns

Question 39: No data is deleted when an outline is hidden or removed.
Ans: a.         True
Ans: b.         False

Question 40: When a part of a formula is replaced with its calculated value, it cannot be restored.
Ans: a. True.
b.        false.

Question 41: When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
Ans: a. True
b.         False

Question 42: Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells
Ans: False

Question 43: When does the triangle appear in the top-left corner of the cell, as shown in the picture?
a.         When the cell contains hidden information
Ans: b.         When the cell contains the Time function
Ans: c.         When there is an error in the formula
d.         None of the above

Question 44: When does the error, as shown in the picture, occur?
a.         It occurs when a column is not wide enough
b.         It occurs when a negative date is used
Ans: c. It occurs when a negative time is used     
Ans: d. All of the above

Question 45: Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
a.     A
Ans: b. B
c.        C
d.         D

Question 46: 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

Question 47: Refer to the given image. Which formula should be written on the given table to display “Nancy Davolio”?
a.         =UPPER(A2)
b.         =LOWER(A2)
Ans: c.         =PROPER(A2)
d.         None of the above

Question 48: What would be the result, when =T(A4) is applied on the given table?
Ans: a. The text True is returned
b.         The text Rainfall is returned
c.         Empty text is returned
d.         None of the above

Question 49: You can double-click a chart element to display the appropriate formatting dialog box.
Ans: True

Question 50: Refer to the given image. What will be the result if the formula =B3&", "&A3 is applied on the given table?
a.     It will display Nancy Davolio
Ans: b.     It will display Fuller Andrew
c.     It will display Fuller, Andrew
Ans; d.     Both b and c

Please Comments, Love and follow me.