Excel Computer Test - Part 3

This article presents Excel Computer Test - Part 3 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Excel Computer Test

Question 1 . In the Excel spreadsheet, in cell A2 the TINHOC string value is available; In cell B2 type in formula = VALUE (A2), then get the result:

A. #VALUE! B. Tinhoc C. TINHOC D. 6

Question 2 . The common data types of Excel are:

A. String type, text type, date type. B. String type, numeric type, logical type, date type, formula type. C. Number type, logic type, date type. D. Formula type, function type, number type, date type.

Question 3 . In the Excel spreadsheet, when the data length of numeric type is larger than the width of the cell, it will be displayed in the characters box:

A. & B. # C. $ D. *

Question 4 . In the Excel spreadsheet, if you want to delete a row from the worksheet, mark this row and do it:

A. Table - Delete Rows B. Press the Delete key C. Edit - Delete D. Tools - Delete

Question 5 . In Excel, when writing the wrong function name in the calculation, the program reports an error?

A. #NAME! B. #VALUE! C. # N/A! D. # DIV/0!

Question 6 . In Excel spreadsheet, you want to sort the list of data in increasing (decreasing) order, we do:

A. Tools - Sort B. File - Sort C. Data - Sort D. Format - Sort

Question 7. In the Excel worksheet, the block is a collection of adjacent cells that form a rectangle, is the block address shown as follows?

A. B1. H15 B. B1: H15 C. B1-H15 D. B1. H15

Question 8 . In Excel, in cell A2, the value is 2008. In cell B2, enter the formula = LEN (A2) and get the result?

A. #Value 0 C. 4 D. 2008

Question 9 . In the Excel spreadsheet, the Chart Wizard dialog box allows you to specify the following information for the chart?

A. Title. B. Whether grid lines or not. C. Annotations for axes. D. All 3 sentences are correct.

Question 10 . In the Excel worksheet, in cell A2, the value of 2008 is available; In cell B2 type in formula = VALUE (A2), then get the result:

A. #NAME! B. #VALUE! C. String value 2008 D. Number value type 2008

Answer:

1. A

2. B

3. B

4. A

5. A 6. C

7. B

8. C

9. D

10. D