Microsoft Excel 2010 Test Answers (oDesk+Elance)

Odesk \ Elance Ms Excel 2007 Test Answer

01. 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

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

03. 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

04. 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

05. 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

06. 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

07. 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

08. 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

09. 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

10. 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

Posted in: oDesk Test Answer