Excel computer test - Part 3

After the second part of the Excel test, the network administrator will continue to send you the 3rd part of the quiz series on this topic. Let's work together to test your knowledge.

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

See more:

1. Guidance on how to align Excel correctly
2. Instructions on how to copy formulas in Excel
3. Instructions on how to insert the current date in Excel
4. Instructions on how to use the Dmax function in Excel