oDesk MS Excel 2003 Test Latest Answers 2014

To Find Answers Simply Press Ctrl+F,,,,,,,,,,,,,,

Lets Start:::::::::::::::::

Question:

Which of the following shortcuts can be used to insert a new line in the same cell?

ANS: Alt+Enter

Question:

Which of the following errors appear when an invalid argument is passed while converting a number from one number system to another system?

ANS: #N/A

Question:

Auto Filter drop-downs are automatically added in the header row of list when the list is created.

ANS: TRUE

Question:

Which of the following statements regarding the QUARTILE function is not true?

ANS: The function MEDIAN(array) and QUARTILEarray,2) will different values when applied to the same array.

Question:

You would like to restrict the values that can be entered into a cell so that only whole numbers between 1 and 100 can be entered. Which option in the menu allows you to accomplish this?

ANS: The setting tab under the menu Data->Validation

Question:

Which of the following function will you use to find the highest in a series of numbers?

ANS: MAX(B1:B3)

Question:

You define a print area in your worksheet, but later you select a smaller range of cells to print and then click Selection under the menu File->Print->Selection. What will happen?

ANS: b

Question:

The figure shows an excel worksheet. If you want to freeze the row showing the month (row 1) and the column showing the product (column A), What should you do?

ANS: Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes.

Question:

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

Question:
Which keyboard shortcut should be used to enter the current time?
ANS:  CTRL+SHIFT+

Question:

As shown in the figure what information will be enlisted by the tab marked as "B" about the current document?

ANS:  It displays whether the current document is in conflict with another member's copy.

Question:

The figure shows a view of the drawing Toolbar. What function is performed by the button marked by the letter 'X'?

ANS: It insets a Diagram or Organizational Chart In the Worksheet.

Question:

Which of the following functions would return a value of 8?

ANS: b and c

Question:

What does the purple triangle at the bottom right corner of the cell signify?
ANS: Smart Tag

Question:

The figure shows a view of the standard Toolbar. What function is performed by the button marked by the letter 'A'?

ANS: It is use to add a hyperlink

Question:

Which file format is typically used to remove printer corruption?
ANS: SYLK format

Question:

The figure the AutoFit Selection menu option. What function does it performed?
ANS: It automatically resizes the column height and width to minimum necessary to fit the contents of the selected cell.

Question:

Which toolbar is shown in this figure?
ANS: Forms toolbar

Question:

If a workbook is place in the XLSTART folder, then the same workbook will open each time Excel is launched.
ANS: True

Question:
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
ANS: There is a comment associated with the cell

Question:

When you clear the contents from a cell, the formatting of the cell also lost.

ANS: FALSE

Question:

You have entered 4/6 as data in a cell without applying any formats to it. By default, Excel will treat this data entry as a:
ANS: Date

Question:
What function does the 'Compare Side by Side with' command on the window menu perform?
ANS:  It allows you to scroll through two or more workbook simultaneously

Question:

You select the row headline 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:

The figure shows a view of Standard Toolbar. What function is performed by the bottom marked by the letter 'Z'?
ANS: It copies the formatting properties from one cell to another

Question:

Which of the following statements is true if the cell B1 contains the formula =$A$1?

ANS: There is an absolute reference to cell A1 so that the formula =$A$1 can be copied to other cells without changing the reference to A1

Question:

What will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it is applied to the data series given bellow?

ANS: #N/A

Question:

What does the NOW() function returns?
ANS: Returns the serial number of the current date and time

Question:

You have created a worksheet which consist of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cell containing this data should appear blank in the worksheet. Which method will help you do this?
ANS: Select the cells, open the window menu and click on Hide

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

The smart tag will be removed from a cell when_________________.
ANS: The data in the cell is changed or deleted

Question:

You are making a sales performance report in Excel which you would like to present to the top management. Some of the column headings are too large and look out of place in their cells. You decide to display the headings as slanted text to save space. How can this be achieved?

ANS: By altering the Text Orientation on the Format->Cells->alignment tab

Question:

Which of the following Date and Time function You will use to return the serial number of the last day of the month before or after a specified number of the months?
ANS: DATEVALUE

Question:
You have entered test in a cell which is too big for the cell. You want text to appear in multiples lines inside the same cell. What will you do?
ANS: Use the wrap txt option in the Format->Cells>Alignment menu

Question:
Which of the following statement is true if the author has created the content with restricted permission using IRM?
ANS: Prevent restricted e-mail content from being copied by using the Print Screen feature

Question:
You have recorded a macro. By mistake you recorded an action in it which you do not want. How will you remove the unwanted action without having to record the whole macro again?
ANS: By opening the macro in the visual Basic Editor and removing the actions which are not required

Question:
What will be value in the cell C2 as shown in the figure when we use formula = A2+B2?
ANS: 120

Question:
Which of the following would be used if you need to start a 77889867810070809 number in a cell?
ANS: Apply the Text Format to empty cell, and then type the numbers

Question:
When using the VLOOKUP function the error #REF! will appear in a cell if________________.
ANS: The col_index_num argument is greater than the number of columns in table_array

Question:
Which Lookup function should be used when the comparison values are located in the column to the left of the data that is to be found?
ANS: VLOOKUP

Question:
You can not select the current row by pressing.
ANS: Shift+Spacebar

Question:
Which of these operators are in the correct order of operations?
ANS: ^,*,-

Question:
Referring to the given image, point out which option should be selected to automatically save a backup copy of a wordbook.
ANS: B




I Share A Excellent Answers Sheet. You Must Pass The Test.........  Cast a comment  ......