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)