odesktestsguide: How To Pass Odesk Excel 2007 Test Part 1

How to pass Odesk Excel 2007

Today I have compiled Excel 2007 oDesk test questions and answers. These are first twenty questions. Please watch out for the rest twenty questions tomorrow (i.e. Part 2). Let your comments keep flowing.

The syllabus of Odesk Excel 2007 Test comprises of:Charts, working with graphics, file format and handling, worksheet, excel tables and functions, formula, working with filters and keyboard shortcuts, working with data, PivotTable an PivotChart reports and lastly working with security macro.

This test comprises of forty questions which must completed in forty minutes. As you do the test, make snapshots of each question using paintbrush program, for the answers you give so that you can later on be able to know where you went wrong. This test is not like Odesk Readiness Test, whereby you are given a list of questions that you answered wrongly. You have to figure this out by doing more research online and practically trying things out in Excel 2007.

If you are looking for administrative job or a writing job in Odesk, this is a very very important test to sit for. If you are registered both in Odesk and Elance, be informed that the questions on these tests are usually the same. Therefore, instead of doing one test, plan to sit for the same test, both in Elance and Odesk when your mind is still fresh.

I wish you all the best. I believe that where there is a will there is a way. Your willpower will make a way for you. Build up you willpower and you will see how easy things that you saw as hard becomes easy. It is all in the mind. Reprogram your mind, tell your mind that you will make it and then step out of your comfort area and try it. Though things might seem to be hard at first, eventually you will become a professional. We are created to overcome hurdles, not to go around them trying to avoid them, but instead to face the challenges that life have to offer.

Excel 2007 Odesk Test Questions and Answers:

Question one:

when a part of a formula is replaced with its calculated value, it cannot be restored.
a. True.

b. false.

Question two:

Which file format is typically used to remove printer corruption?
a. XLS format.

b. HTML format.

c. SYLK format (Symbolic Link format).

d. All of the above.

Question three:

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

b. False.

Question Four :

Which of the following is not true about an offline cube file?

a. it stores data in the form of an OLAP cube.

b. The file format fro 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 Five:

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

a. True.

b. False .

Question Six:

This question is based upon the figure below.

Odesk Excel 2007 Formulas

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.
    b.     It will display Fuller Andrew.
    c.     It will display Fuller, Andrew.
    d.     Both b and c.

Question seven:

How would you select an entire PivotTable report?

a. On the Home tab, in the Editing group, select the 'Entire PivotTable' option.

b. On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'".

c. On the Analyze tab, in the Data group, click on 'Select Entire PivotTable' option.

d. None of the above.

Question eight:

Which keyboard shortcut should be used to enter the current time?
a. CTRL+SHIFT+"(inserts row/column/cell).

b. CTRL+SHIFT+: (INSERTS CURRENT TIME).

c. CTRL+;(INSERTS CURRENT DATE).

d. None of the above.

Question nine:

When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?

a. it displays the prompt box an asks the user to type 'a' or 'p'.

b. it displays an error message.

c. It enters the time as PM.

d. It enters the time as AM.

e. None of the above.

Question ten:

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 ShowHide group, click Refresh.

c. On the Design tab, in the External Data group, click Refresh.

d. None of the above.

Question eleven:

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.
    c.     When the workbook is shared or protected.
    d.     All of the above .

Question twelve:

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.

d. Additional formulae cannot be entered in a calculated column as exceptions.

Question thirteen:

This question is based upon the figure shown below.

Odesk Excel 2007 References Formula

Which part of the formula displays references in the given picture?

a. A.

b. B.

c. C.

d. D.

Question fourteen:

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.

b. By corresponding field.

c. By value field.

d. By number field.

Question fifteen:

This question is based upon the figure below.

Odesk Excel 2007 Consolidate

As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
    a.     This option does not let you change the consolidation.
    b.     This option does not let you create the consolidation.
    c.     Both a and b.
    d.     None of the above.

Question sixteen:

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 .

b. On the Data tab, in the Data Tools, select Remove Subtotals.

c. Both a and b.

d. None of the above.

Question seventeen:

How will you reverse the direction of a SmartArt graphic?

a. Right-click on the SmartArt graphic, select Reverse.

b. Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse.

c. Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left.

d. All of the above.

Question eighteen:

Which tab should be used to display or hide axes?
a. Data tab.

b. Layout tab.

c. Insert tab.

d. View tab.

Question nineteen:

This question is based upon the figure below.

Odesk Excel 2007 Column Chart Legends

Which among the following options displays Legend entries in the given picture?

a. A.

b. B.

c. C.

d. none of the above.

Question twenty:

What does the screen tip displaying “Showing all” mean?

a. On the Page Layout tab.

b. On the View tab.

c. On the review tab.

d. all of the above .

Good luck as you sit for your oDesk Execl 2007 Test! Watch out for Part II of this tomorrow.

To access Part 2, click this link; How To Pass Odesk Excel 2007 Test Part 2 Odesk Excel 2007 Part 2.