MS Excel 2003 Skills Online Test-1

Question-1.

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

#N/A

Blank cell appears

#ERROR

#NUM

Question-2.

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

Ctrl+Enter

Enter

Alt+Enter

Ctrl+L

Question-3.

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.

True

False

Question-4.

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

the lookup_value is not found in the first column of the table_array

the col_index_num argument is greater than the number of columns in table_array

the table_array argument includes empty columns on the left of the table_array

Question-5.

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

Place the character T before the number e.g. T 77889867810070809

Place the characters TX before the number e.g. TX 77889867810070809

Enclose the number is brackets e.g. (77889867810070809)

Apply the Text Format to empty cells, and then type the numbers

EXAMRADAR.COM

For Solo Learner Computer science

MS Excel 2003 Skills Objective MCQs Based Online Test-1

Test-summary

Information

Results

Categories