Odesk Test Answers Excel 2003 part 1

 Odesk Test Questions1

 An Excel workbook saved in HTML format allows Internet or intranet users to have access to workbook data even if they do not have Excel installed
Questions Ans is:   True

Odesk Test Questions2: 

Once the chart is created, data can only be changed in a chart located in the same worksheet as the changed cells

Questions Ans is:   False

Odesk Test Questions3: 

Certain chart elements automatically inserted in a chart created by Chart Wizard include a chart legend, labels for the x-axis and y-axis, and a chart title

Questions Ans is:   False

Odesk Test Questions4:

 You can double-click a chart element to display the appropriate formatting dialog box.

Questions Ans is:   True

Odesk Test Questions5: 

Time in a cell in Excel is stored as a decimal fraction representing a portion of the day

Questions Ans is:  True

Odesk Test Questions6: 

The PMT function is used to calculate a loan payment based on a variable interest rate, payment, and the time period.

Questions Ans is:   False

Odesk Test Questions7:

The gridlines that appear on your worksheet will print as displayed.

Questions Ans is:   False

Odesk Test Questions8:

The FV function is used to calculate the future value of an investment based on a periodic constant payment and interest rate

Questions Ans is:   True

Odesk Test Questions9:

 If the text you entered into a cell does not fit, Excel will display ##### to indicate that the text is too long

Questions Ans is:   True

Odesk Test Questions10:

 By default, data in a cell is centered

Questions Ans is:   False

Odesk Test Questions11:

 When a new row is added into an Excel worksheet, by default, this row will be inserted just below the active cell.

Questions Ans is:   True

Odesk Test Questions12:

 To insert a row, click Insert and then Rows

Questions Ans is:   True

Odesk Test Questions13:

The Split option causes the worksheet to be split into two window panes.

Questions Ans is:   False

Odesk Test Questions14:

To select nonadjacent cells, columns, or rows, you must
Questions Ans is:   hold down the Ctrl key while clicking column, row header, or specific cells

Odesk Test Questions15:

 When copying selected cells to a new location, you must position the mouse pointer on any border around the selected cells until it turns into a(n)
Questions Ans is:   arrow pointer

Odesk Test Questions16:

When data is linked, a change made in a linked cell is automatically made to other cells in the link.
Questions Ans is:   True

Odesk Test Questions17:

Selected cells and cell contents can be moved or copied within a worksheet but not between worksheets.
Questions Ans is:   False

Odesk Test Questions18:

What Function does the ‘Compare Side by Side With’ command on the window menu perform?
Questions Ans is:   It allows you to scroll through two or more workbooks simultaneously

Odesk Test Questions19:

Which of the following functions would return a value of 8?
Questions Ans is:   round(8.4999,0)

Odesk Test Questions20:

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?
Questions Ans is:   0

Odesk Test Questions21:

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?
Questions Ans is:   EOMONTH

Odesk Test Questions22:

Which of the following shortcuts can be used to insert a new line in the same cell?
Questions Ans is:   Alt+Enter

Odesk Test Questions23:

Which of the following function you will use to find the highest number in a series of numbers?
Questions Ans is:   MAX(B1:B3)

Odesk Test Questions24:

Which of the following statements regarding the QUARTILE function is not true?
Questions Ans is:   The function MEDIAN(array) and QUARTILEarray,2) will return different values when applied to the same array.

Odesk Test Questions25:

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:
Questions Ans is:   Date

Odesk Test Questions26:

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?
Questions Ans is:   120

Odesk Test Questions27:

What is the quickest way to select all the columns on a worksheet?
Questions Ans is:   Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

Odesk Test Questions28:

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

Odesk Test Questions29:

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?
Questions Ans is:   The setting tab under the menu Data->Validation

Odesk Test Questions30:

You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Questions Ans is:   Hold down the CTRL key during startup

Odesk Test Questions31:

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

Odesk Test Questions32:

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

Odesk Test Questions33:

How can you select all the blank cells in your worksheet?
Questions Ans is:   This must be done manually as it is not automated through any built-in feature

Odesk Test Questions34: 

The figure shows an Excel worksheet. If you want to F the row showing the months (row 1) and the column showing the products (column A), what should you do?
Questions Ans is:   Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes

Odesk Test Questions35: 

The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter X ?
Questions Ans is:   It inserts a Diagram or Organization Chart in the worksheet

Odesk Test Questions36: 

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.
Questions Ans is:   TRUE

Odesk Test Questions37: 

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 below?
Questions Ans is:   #N/A

Odesk Test Questions38: 

AutoFilter drop-downs are automatically added in the header row of a list when the list is created.
Questions Ans is:   TRUE

Odesk Test Questions39: 

Which toolbar is shown in the figure?
Questions Ans is:   Forms toolbar

Odesk Test Questions40: 

When you clear the contents from a cell, the formatting of the cell is also lost.
Questions Ans is:   FALSE