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:

Guidance on how to align Excel correctly
Instructions on how to copy formulas in Excel
Instructions on how to insert the current date in Excel
Instructions on how to use the Dmax function in Excel

Jessica Tanner

Update 24 May 2019

You should read it

May be interested

Testing computer science knowledge, doing a bit of fun (part 7)
after part 6, network administrator continues to introduce part 7. let's try to see how many answers you can answer?
F.TEST function - The function returns the result of the F - test in Excel
f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
Testing computer science knowledge, doing little for fun (part 10)
after part 9, network administrators continue to introduce part 10 of the series of computer science knowledge tests.
Testing computer science knowledge, doing little for fun (part 4)
after the previous sections, network administrator continues to introduce part 4.
Testing computer science knowledge, doing little for fun (part 9)
after section 8, network administrators continue to introduce part 9 of the series of computer science knowledge tests.
Microsoft Excel Test P7
proficiency in using excel and mastering excel tips will greatly help your promotion or study. in the article below, network administrator will help you add knowledge about this topic through multiple choice questions.
Test with Word answer - Part 5
the network administrator will continue to send you the 5th part of the word quiz series so you can try your knowledge. let's try to see how much questions you can answer with knowledge inherent?
eQuiz - Multiple choice test on programming language C - part 1
this is part 1 of a series of tests on knowledge of c programming language, in total there will be 15 questions with no time for answering each sentence.
Z.TEST function - The function returns one-sided value of the z test in Excel
z.test: the function returns the one-sided p value of the z test. support functions from excel 2010 onwards. syntax: z.test (array, x, [sigma])
Microsoft Excel test - Part 4
in this article, go with microsoft network administrator to learn about microsoft excel through multiple choice questions.

Excel computer test - Part 3

You should read it

May be interested

Quiz technology