MS Excel 2003 Test Answers (part 1)

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

Answers: • It displays custom properties of the current document

• It displays whether the current document is up to date or not

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

Answers: • #ERROR

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

Answers: • Alt+Enter

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.

Answers: • True

When using the VLOOKUP function, the error #REF! will appear in a cell if ________________.

Answers: • the col_index_num argument is greater than the number of columns in table_array

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

Answers: • Enclose the number is brackets e.g. (77889867810070809)

State whether True or False:

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

Answers: • False

A smart tag will be removed from a cell when ________________ .

Answers: • the cell is moved

You have entered text 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?

Answers: • Use the Wrap Text option in the Format -> Cells -> Alignment menu

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

Answers: • Smart tag

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

Answers: • round(8.4999,0)

What function does the 'Compare Side by Side With' command on the Window menu perform?

Answers: • It allows you to scroll through two or more workbooks simultaneously

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

Answers: • If quart is not an integer, it is truncated.

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

Answers: • It is used to add a hyperlink

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

Answers: • Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet

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

Answers: • It is used to rotate the picture in the worksheet to the desired angle

What should you add before a fraction to avoid entering it as a date, e.g. 1/3, in Excel?

Answers: • zero space

There is a workbook named Sales.xls which has a worksheet named Quarterly. This worksheet contains the quarterly sales figures for the company in cells A3 to A6. Now you want to create a formula in a different workbook that reads the quarterly sales figures and adds them up while the Sales workbook is closed. Which of the following is the correct formula to do this?

Answers: • =SUM(C:\MyFiles\Sales.xls,Quarterly!A3:A6)

State whether True or False.

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

Answers: • True

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

Answers: • MAX(B1:B3)

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

Answers: • 120

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

Answers: • It copies the formatting properties from one cell to another

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

Answers: • 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

There is a workbook named Sales.xls which has a worksheet named Quarterly. This worksheet contains the quarterly sales figures for the company in cells A3 to a6. Now you want to create a formula in a different workbook that reads the quarterly sales figures and adds them up while the Sales workbook is open. Which of the following is the correct formula to do this?

Answers: • =SUM([Sales.xls]Quarterly!A3:A6)

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?

Answers: • =A1&"_"&B1

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 a specified number of months?

Answers: • EDATE

Which of the following statement is true if the author has created the content with restricted permission using IRM?

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

What does the NOW() function return?

Answers: • None of the above

How does the AutoComplete feature in Excel help you save time?

Answers: • It completes text and numeric entries that match an existing entry in the same column

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?

Answers: • None of the above

Is the following statement true or false?

If a workbook is placed in the XLSTART folder, then the same workbook will open each time Excel is launched.

Answers: • False

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?

Answers: • The print area will be printed

The given figure shows the 'Compare Side by Side' toolbar. What function is performed by the button marked with letter 'A'?

Answers: • It allows you to open a new workbook for comparison

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?

B1:27
B2:22
B3:28
B4:21

Answers: • 0

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

Answers: • It automatically resizes the column width to the minimum necessary to fit the contents of the selected cell

State whether True or False.

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

Answers: • True

The figure shows the Calculation tab under the Tools->Options menu. The option under Calculation has been checked as Automatic. What does this mean?

Answers: • Excel will automatically calculate the values for all formulas as you change the values within cells

The figure shows the Text to Column menu option. What function does it perform?

Answers: • It allows you to add comma separated text into various cells automatically

How can you select all the blank cells in your worksheet?

Answers: • This must be done manually as it is not automated through any built-in feature