oDesk MS Execl 2000/2003 Test Answers- 3

How to 100% Pass Excel 2003 oDesk Test Following below..............

It is running wise to revise for any oDesk test before trying it out. Try to understand apply them in your daily office life and any freelancing test.

It’s writing on experience of what you are dealing with and gives a better position to enable you answer questions even when they are twisted.

I wish you all the best and best luck.................

Listed to important information about the current time MS Execl 2000/2003 Test Answers on oDesk. The following information is below --------

SET 1: SL. 1 TO 33

SET 2: SL. 34 TO 66

SET 3: SL. 67 TO 97 RUNNINGPAGE

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

Ans: #N/A

Question 68: 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. =A1&","&B1

Ans: b. =A1&"_"&B1

c. =A11&"."&B1

d. =A1&""&B1

Ans: Ans: A_B

Question 69: Which of the following date and time function will you use to return the serial number of the last day of the month before or after specified number of months?

Ans: EOMONTH

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

a. Ctrl+Enter

b. Enter

Ans: c. Alt+Enter

d. Ctrl+L

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

Ans: MAX(B1:B3)

Question 72: State Whether True or false.

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: a. True

Ans: b. False

Question 73: The multiplication arithmetic operator is represented by which of the following symbols

Ans: *

Question 74: What does the purple triangle at the bottom right corner of the cell signify?

a. Formatted cell

b. Text

Ans: c. Smart tag

d. Hidden data

Question 75: You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?

a. Select the cells, the data of which you want to hide. Click Cells on the Format menu and choose the Hide option

Ans: b. Select the cells, open the Window menu and click on Hide

c. Select the cells, open the Data menu and click on Filter

Ans: d. select the cells, the data of which you want to hide. Click cells on the Format menu and then the Number tab. In the category list click Custom, type three semicolons(;;;) in the Type box.

Question 76: You can select the current row by pressing

Ans: Shift + Spacebar

Question 77: This question is based upon the figure shown bellow

The figure shows an Excel worksheet. What does the read triangle in C2 signify?

Ans: There is a comment associated with the cell

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

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

Question 79: You start Microsoft Excel and you do not want it to automatically run a a macro upon starting. What will you do?

Ans: a. Hold down the SHIFT key during startup

b. Hold down the CTRL key during startup

c.Hold down the ESC key during startup

d.Hold down the ESC + CTRL key during startup

Question 80: Question: The figure shows the AutoFit Selection menu option. What function does it perform?

Answer: It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell

Question 81: This question is based upon the figure shown below

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?

a. Select the cells A2 to A6 and cells B1 to F1 and click on freeze Panes under the menu Windows->Freeze panes

Ans: b. Select the cell B2 and click on Freeze Panes under the menu Window->Freeze panes

Ans: c. Select the cell A1 and click on Freeze panes under the menu windows->Freeze panes

d. Select the cells F1 and F

6 and click on Freeze Panes under the menu Window->Freeze Panes

e. None of the above

Question 82: Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?

a. place  the character T before the number e.g. T77889867810070809

b. Place the characters TX before the number e.g. TX 77889867810070809

c.Enclose the number is brackets e.g. (77889867810070809)

Ans: d. apply the Test Format to empty cells, and then type the numbers

Question 83: 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 months?

Ans: a. DATEVALUE

Ans: b. EOMONTH

d. TIMEVALUE

d. EDATE

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

a.The value of cell B1contains the same number of characters as the value of cell B2

Ans: b.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

c. There is a relative reference to cell A1 so the formula will change each time it is copied to other cells

d. The value of cell B1 is copies only once, further changes in value of A1 will not effect the value of B1

Question 85: AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Ans: a. True

b. False

Question 86: This question is based upon the figure shown below

The figure shows an Excel worksheet. What does the red triangle in cell C2 signify?

a. The cell is locked

b. The data entered in the cell will be validated to see if it matches the criteria set

c. The cell has been marked so that it can be referred to in case of need

Ans: d. There is a comment associated with the cell

Question 87: Which of the following statement is true if the author has created the content with restricted permissions using IRM

Ans: a. Prevent an unauthorized recipient from accessing e-mail content, including attachments.

Ans: b. Prevent restricted e-mail content from being copied by using the Print Screen feature in Microsoft Windows 

c. Restricted e-mail content from being copied by using third-party screen-capture programs

d. None of the above

Question 88: What does the NOW() function returns?

Ans: Returns the serial number of the current date and time

Question 89: This question is based upon the figure shown below

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

a. It displays custom properties of the current document

Ans: b. It displays whether the current document is up to date or not

Ans: c. It displays when the current document was last modified

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

Ans: e. It displays your Information Rights Management permissions

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

a.fraction

Ans: b.Date

c.Number

d.Text

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

a. By using the Find and Replace option in the Edit menu

b. By clicking on the Refresh button in the Macro toolbar

c. It cannot be edited, the macro will have to record again without the unwanted actions

Ans: d. by opening the macro in the Visual Basic Editor and then removing the actions which are not required

Question 92: State whether True of False

With the help of the Research task pane you can conduct research on Topics using an encyclopedia, Web search and also by accessing their-party content

Ans:a. True

b. False

Question 93: A smart tag will be removed from a cell when___________.

a. The cell is hidden

b. the cell is moved

Ans: c. The data in the cell is changed or deleted

d. The formatting of the cell is changed

Question 94: This question is based upon the figure shown below

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

Ans: 120

Question 95: 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: a. The Settings tab under the menu Data->Validation

b. The Settings tab under the menu Data->Filter->Advanced Filter

c. The Setting tab under the menu Format ->Cells

d. The Settings tab under the menu Format->Conditional Formatting

Question 96: What does the NOW( )function return?

Ans: a. Returns the serial number of the current data and time

b. Returns the serial number of the current date

c. Returns the serial number of the current time

d. None of the above

Question 97: What is the quickest way to select all the columns on a worksheet?

a. Click on the column heading of the first column, press Shift, and then click on the column heading of the last column

b. Click on the column heading of the first column, press Ctrl, and then click on the column heading of the last column

c. Choose Edit-> Select all from the main menu

Ans: d. Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet.

Your comments are very much needed. If you like this blog please be a follower so that you can be getting updates as soon as they come through you email.

Thanks.