Odesk Test Answers Excel 2003 part 2

Odesk Test Answers Excel 2003 part 2

Odesk Test Questions41: 

When the AutoSum button is clicked, Excel first looks for a range of numbers above the active cell.
Questions Ans is:   True

Odesk Test Questions42: 

A relative cell reference changes when a formula is copied or moved to other locations.
Questions Ans is:   True

Odesk Test Questions43:

 If cell entries are changed, the formula will automatically recalculate the values and insert the result in the cell containing the formula.
Questions Ans is:   True

Odesk Test Questions44: 

The Merge button on the Formatting toolbar will merge selected cells and right align data within the cells.
Questions Ans is:   False

Odesk Test Questions45:

To make the image taller or shorter, use the middle sizing handle at the left or right side of the image.
Questions Ans is:   False

Odesk Test Questions46: 

Which of the following is not a tab on the Chart Options dialog box?
Questions Ans is:   Patterns

Odesk Test Questions47: 

This chart is the default chart
Questions Ans is:   Column Chart


Odesk Test Questions48:

 Which of the following displays the contents of the active cell?
Questions Ans is:   Formula bar

Odesk Test Questions49: 

A worksheet is an individual page or tab in the workbook.
Questions Ans is:   True

Odesk Test Questions50: 

You can copy cell formats from one cell to another by using the
Questions Ans is:   Format Painter

Odesk Test Questions50: 

Donelp you do this?
Questions Ans is:   Select the cells, open the Window menu and click on Hide

Odesk Test Questions51: 

The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter Y
Questions Ans is:   It adds up the values in the selected cells

Odesk Test Questions52: 

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->Print What->Selection. What will happen?
Questions Ans is:   The selected area will be printed

Odesk Test Questions53:

By default, how is text horizontally aligned inside a cell in Excel?
Questions Ans is:   Left aligned

Odesk Test Questions54: 

When using the AutoFill handle to quickly fill a range of cells with the same or consecutive data, the cells need not be adjacent as long as they are within the same sheet.
Questions Ans is:   False

Odesk Test Questions55: 

This question is based upon the figure shown bellow
The figure shows an Excel worksheet. What does the read triangle in C2 signify?
Questions Ans is:   There is a comment associated with the cell

Odesk Test Questions56: 

You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Questions Ans is:   3 new rows will be inserted after row 9

Odesk Test Questions57:   

A smart tag will be removed from a cell when……………….
Questions Ans is:   The data in the cell is changed or deleted

Odesk Test Questions58: 

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

Odesk Test Questions59: 

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? 
Questions Ans is:   Select the cells, open the Window menu and click on Hide

Odesk Test Questions60: 

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

Odesk Test Questions61: 

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

Odesk Test Questions62: 

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

The multiplication arithmetic operator is represented by which of the following symbols
Questions Ans is:   *

Odesk Test Questions64: 

To apply page numbering to a worksheet page, which option in the Page Setup dialog box should you choose
Questions Ans is:   Header/Footer

Odesk Test Questions65: 

If a function is included in an argument within a function, it is called a
Questions Ans is:   Nested Function

Odesk Test Questions66:

 If you want row and column headings to print, which tab do you click from the Page Setup dialog box?
Questions Ans is:   Header/Footer

Odesk Test Questions67: 

A new workbook initially contains this many sheets
Questions Ans is:   Three

Odesk Test Questions68: 

You can change the size of an image by using the white sizing handles.
Questions Ans is:   True

Odesk Test Questions69: 

The question is based upon the figure shown
The figure shows a view of the standard Toolbar. What function is performed by the button Marked by the letter Y?
Questions Ans is:    Its adds up the values in the selected cells

Odesk Test Questions70: 

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?
Questions Ans is:    Use the wrap txt option in the Format->Cells>Alignment Menu

Odesk Test Questions71: 

Which of the following errors appears when an invalid argument is passed while converting a number from one number system to another system?
Questions Ans is:    #N/A

Odesk Test Questions72: 

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?
Questions Ans is:    = A1&”_”&B1

Odesk Test Questions73: 

The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter A
Questions Ans is:   It is used to add a hyperlink

Odesk Test Questions74: 

Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Questions Ans is:   Apply the Text Format to empty cells, and then type the numbers

Odesk Test Questions75: 

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

Odesk Test Questions76: 

You can select the current row by pressing  
Questions Ans is:   Shift + Spacebar

Odesk Test Questions77: 

A column is inserted immediately to the left of the column containing the active cell unless you choose otherwise
Questions Ans is:   True

Odesk Test Questions78: 

To delete a specific cell as well as the text within it, make the cell active and then
Questions Ans is:   click Edit and then Delete

Odesk Test Questions79: 

Which of the following is an absolute cell reference
Questions Ans is:   $B3

Odesk Test Questions80: 

How can you select all the blank cells in your worksheet?
Questions Ans is:   Choose blank in the Edit->Go to->special Menu option

Odesk Test Questions81: 

State whether true or false.
Questions Ans is:   True

Odesk Test Questions82: 

This question is based upon the figure bellow
what does the purple triangle at the bottom right corner of the cell signify?
Questions Ans is:   Smart Tag

Odesk Test Questions83: 

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?
Questions Ans is:   Select the cells, open the Window menu and click on Hide

Odesk Test Questions84: 

A document created in Excel is referred to as a
Questions Ans is:   workbook

Odesk Test Questions85: 

Use this handle to automatically insert the next month in the series, January:
Questions Ans is:   Fill

Odesk Test Questions86: 

Which of these operators are in the correct order of operations?
Questions Ans is:   ^,*,-

Odesk Test Questions87: 

To move the insertion point down to the next cell, press:
Questions Ans is:   Enter

Odesk Test Questions88: 

The cell range A3 through G3 should be keyed in as:
Questions Ans is:   A3:G3

Hey I hope you will pass the test.