oDesk MS Excel 2007 Test Answers: 3

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

SET 3: 51 TO 75  Running

SET 4: 76 TO100

SET 5: 101 TO 125 

SET 6: 126 TO 150

SET 7: 151 TO 176

Question 51: What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
a.         It signifies that the cell contains a formula
Ans: b. It signifies that the cell contains a comment
Ans: c. It signifies that the cell contains a macro
d.         All of the above

Question 52: What is the purpose of using the Keep text flat option, as shown in the picture?
Ans; a. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
Ans: b.   It prevents the text from blurring
c.         It moves the WordArt or text backward
Ans: d.  Both b and c

Question 53: Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
a.         A
Ans: b.  B
Ans: c.  C
d.         D

Question 54: 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?
a.         A
Ans: b.         B (total row)
c.      C
d.     D

Question 55: Which among the following options displays Legend entries in the given picture?
a.         A
ans: b. B
ans: c. C
d.    None of the above

Question 56: Which Chart type is displayed in the given picture?
a. A stock chart
Ans: b. A surface chart
Ans: c. An XY (Scatter) chart
d. None of the above

Question 57: How to easy pass the oDesk MS Excel 2007 Test 2012 Today Part-1 Blow following:

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

Question 59: How does the AutoComplete feature in Excel help you save time?
Ans: It automatically completes abbreviated words

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

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

Questions 62: 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

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

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

Question 65: A new workbook initially contains this many sheets
Ans: Three

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

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

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

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

Question 70: 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
Ans: Choose blank in the Edit->Go to->special Menu option

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

Question 72: Which of the following functions would return a value of 8?
Ans: round (8.4999,0)
Ans: b and c

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

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

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

Please Comments, Love and follow me.