Test: Excel 2003
01. What Function does the ‘Compare Side by Side With’ command on the window menu perform?
(a) It allows you to compare two worksheets simultaneously in a single workbook
(b) It allows you to scroll through two or more workbooks simultaneously
(c) It allows you to scroll through only two workbooks simultaneously to identify the difference between them
(d) It only allows you to scroll through more than two worksheet in a single workbook simultaneously
Ans: (b)
02. Which of the following functions would return a value of 8?
(a) Roundup(8.4999,0)
(b) rounddown(8.4999,0)
(c) round(8.4999,0)
(d) a and c
(e) b and c
Ans: (c)
03. 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?
B1:27
B2:22
B3:28
B4:21
(a) #N/A
(b) 27
(c) 0
(d) Error
04. How can you select all the blank cells in your worksheet?
(a) This must be done manually as it is not automated through any built in feature
(b) Choose Edit->Select->Blank Under the main menu
(c) Choose blank in the Edit->Go to->special Menu option
(d) Choose blank in the View->Go to->Special Menu option
The question is based upon the figure shown
05. The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
(a) Its calculate the mean deviation of the numbers in the selected cells
(b) Its calculates the average values in the selected numbers
(c) Its adds up the values in the selected cells(ans.)
(d) It merges the selected cells
06. You have entered test in a cell which is too big for the cell. You want the text to appear in multiple lines inside the same cell. What will you do?
(a) Start Typing in the cell and press the enter key when you want to start another line
(b) Use the wrap txt option in the Format->Cells>Alignment Menu(ans.)
(c) Use the Shrink to Fit option in the Format->Cells->alignment menu
07. Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
(a) #N/A(ans.)
(b) Blank Cell appears
(c) #ERROR
(d) #NUM
08. Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get John_Smith in Cell C1?
(a) =A1&”,”&B1
(b) = A1&”_”&B1(ans.)
(c) = A1&”.”&B1
(d) = A1&” ”&B1
09. 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?
(a) DATEVALUE
(b) EOMONTH(ans.)
(c) TIMEVALUE
(d) EDATE
10. Which of the following shortcuts can be used to insert a new line in the same cell?
(a) Ctrl+Enter
(b) Enter
(c) Alt+Enter
(d) Ctrl+L
11. Which of the following function you will use to find the highest number in a series of numbers?
(a) MAX(B1:B3)(ans.)
(b) MIN(B1:B3)
(c) AVERAGE(B1:B3)
(d) SUM(B1;B3)
12. State Whether True or false.
With the help of the research task pan you can conduct research on Topics using an encyclopedia, Web search and also by accessing third party content.
(a) True(ans.)da
(b) False
13. This question is based upon the figure bellow
What does the purple triangle at the bottom right corner of the cell signify?
(a) Formatted cell
(b) Text
(c) Smart Tag
(d) Hidden data
14. You have created a worksheet which consists a 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
(b) Select the cells, open the Window menu and click on Hide
(c) Select the cells, open the Data menu and click on Filter
(d) Select the cells, the data of which you want to hide. Slick cells on the Format menu and then the umber tab. In the category list click Custom, type three semicolons (;;;) in the Type box
15. This question is based upon the figure shown bellow
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
(a) The cell in 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
(d) There is a comment associated with the cell
16. You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
(a) 3 new rows will be inserted after row 12
(b) 1 New row will be inserted after row 12
(c) 3 new rows will be inserted after row 9
(d) 1 new row will be inserted after row 9
17. The figure shows the calculation tab under the Tools->options menu. The option under Calculation has been checked as Automatic. What does this mean?
(a) Excel will calculate the values for all formulas entered into cells when you click Calc Now on the calculation Tab
(b) Excel will automatically calculate the values for all formulas before saving
(c) Excel will automatically calculate the values for all formulas as you change the values within cells
18. Which of the following statements regarding the QUARTILE function is not true?
(a) If array is empty, QUARTILE returns the #NUM! error value.
(b) If quart is not an integer, it is truncated.
(c) If quart<0 or if quart>4, QUARTILE returns the #NUM! error value.
(d) The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.
19. 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
(b) Date
(c) Number
(d) Text
20. 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?
(a) 63
(b) 91
(c) 120
(d) 92
21. 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) Chose Edit->Select all from the mail menu
(d) Click on the grey rectangle on the upper left corner of the worksheet where the column headings and row headings meet
22. What does the NOW() function returns?
(a) Returns the serial number of the current date and time
(b) Return the serial number of the current date
(c) Return the serial number of the current time
(d) None of the above.
23. A smart tag will be removed from a cell when……………….
(a) The cell is hidden
(b) The cell is moved
(c) The data in the cell is changed or deleted
(d) The formatting of the cell is changed
24. 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?
(a) The setting tab under the menu Data->Validation
(b) The settings tab under the menu Data->Filter->advance filter
(c) The settings tab under the menu Format>Conditional Formatting
25. What should you add before a fraction to avoid it as a date, e.g.1/3, in Excel?
(a) F
(b) //
(c) Zero
(d) FR
(e) Zero space
Than you for your question contribution. It is very useful for me. I am a new odesk contractor. I found many common question from your question, when i completed the odesk Excel 2003 test. Please publish odesk MS-Word 2003 test question.
ReplyDelete