HomeTech infoQuiz technologyExcel computer test - Part 3

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
4.5 ★ | 2 Vote
quizzesinformatics testssoftwareexcelbasic knowledge

You should read it

May be interested

  • Test about C programmingPhoto of Test about C programming
    if you are a fan of this programming language, you can try your knowledge through our multiple-choice questions.
  • Test Linnux operating systemPhoto of Test Linnux operating system
    in this article, join the network administrator to answer some multiple choice questions around this topic to try your knowledge.
  • Test your knowledge about computersPhoto of Test your knowledge about computers
    the multiple choice questions below are extremely simple and interesting to help you gain more useful knowledge about this issue. let's start.
  • Check your understanding of GooglePhoto of Check your understanding of Google
    below, network administrator will send you some multiple choice questions to help you understand more about this famous company.
  • Multiple choice questions on the InternetPhoto of Multiple choice questions on the Internet
    next in the article below, invite your readers to understand your topic with this topic to see how well you understand the internet, they will definitely make you excited.
  • eQuiz - Multiple choice test on SQLPhoto of eQuiz - Multiple choice test on SQL
    this is a small test of the sql database administration system, there will be 10 questions in total with no time for answering each sentence.

Quiz technology