Microsoft Excel Test P10

Microsoft Excel is a great software or application program, but when you run this application, it creates a spreadsheet and spreadsheet that makes it easier to perform calculations or tabulate. .. Below, invite readers to test their knowledge with the multiple choice questions below on this topic.

Question 1. In MS Excel 2010, to select the entire content, what key combination?
1. Ctrl -Alt-A
2. Shift -A
3. Ctrl-A
4. Shift - Ctrl -A
Question 2. On the Riboon's Home tab in MS Excel 2010, the Increase Decimal icon is meaningful . for the selected data area
1. Increase the decimal fraction and round the number
2. Reduce decimal numbers and round the numbers
3. Round the number and take 2 decimal places
4. Number format in a subclass style
Question 3. When the data on a cell turns into a sequence of sign symbols ##### tell us what?
1. The function name in the formula is wrong
2. An error occurred when referencing data
3. The width of the column is not wide enough to display
4. The reference address is not real
Question 4. In MS Excel 2010, suppose the range of values from B4 to B20 contains the column of Student's name and surname. With the "Calculate the total number of students listed" problem, what is the formula?
1. = COUNTA (B4: B20)
2. = COUNT (B4: B20)
3. = SUM (B4: B20)
4. All is wrong
Question 5. In MS Excel 2010, what is the third component in VLOOKUP?
1. Table detector
2. Table of detectors
3. Reference column for retrieving results
4. Reference line to get results
Question 6. When entering the value on August 21, 2009, but MS Excel does NOT automatically align the content, what does this mean?
1. The computer establishes how to enter the date by type of month / day / year
2. Automatic left cultivation as it is a numeric type
3. This is an invalid date value
4. Use wrong date separator symbols
Question 7. Which of the following statements is wrong?
1. In MS Excel 2010, to program the calculation formula, you must enter the = sign at the beginning
2. All functions in MS Excel 2010 have arguments
3. The parameters in the function are separated by commas or semicolons according to the setting
4. In a formula can use multiple functions
Question 8. In MS Excel 2010, the function . is used to sum the values in a certain area when the values in a corresponding area satisfy the condition.
1. COUNT
2. SUM
3. SUMIF
4. COUNTIF
Question 9. In MS Excel 2010, what is the result of the LEFT (A3; 3) formula, knowing that cell A3 contains the "IT" content?
1. "Information Technology"
2. "BELIEVE"
3. "LEARN"
4. All is wrong
Question 10. In MS Excel 2010, which of the following formulas will result in TRUE values?
1. = OR (3 + 2 = 6; 5> 3 ^ 2)
2. = IF (6> 5; FALSE; TRUE)
3. = AND (MOD (4; 2) = 0; 5> = 3)
4. All three formulas above give TRUE values

« PREV POST