Microsoft Excel Test P15

Tests on excel help you test your basic knowledge. Please try your knowledge with the following questions that the Network Administrator has edited.

Question 1. In Excel worksheet, In cell A2 type in formula = MA30,10,65.5, then get the result in cell A2:
1. 5
2. 30
3. 65
4. 110
Question 2. In Excel, in cell A2 the value is "Tinhoc"; In cell C2, type in formula = A2, the result in C2 is:
1. #Value
2. TINHOC
3. News
4. Tinhoc
Question 3. In Excel spreadsheet, to filter the data automatically, after selecting the block to be filtered, we do:
1. Format - Filter - AutoFilter
2. Insert - Filter- Auto Filter
3. Data- Filter- AutoFilter
4. View - Filter - AutoFilter
Question 4. In the Excel spreadsheet, which of the following functions allows the sum of numerical values to satisfy a given condition?
1. SUM
2. COUNTIF
3. COUNT
4. SUMIF
Question 5. In Excel spreadsheet, to insert a column into the worksheet, we execute:
1. Table - Insert Columns
2. Format- Cells- Insert Columns
3. Table- Inser Cells
4. Insert - Column
Question 6. When working with Excel, it is possible to move from one sheet to another using the keys or key combinations:
1. Page Up; Page Down
2. Ctrl - Page Up; Ctrl - Page Down
3. Both sentences are true
4. Both sentences are wrong
Question 7. In Excel, which of the SUMIF function syntax is correct?
1. SumIf (range, criteria, [sum_range])
2. SumIf (criteria, range, [sum_range])
3. SumIf (range)
4. SumIf (range, criteria)
Question 8. In Excel, assume that cell A1 of the worksheet is capped on October 15, 1970. What is the function result = MONTH (A1)?
1. VALUE #?
2. 15
3. ten
4. 20
Question 9. In Excel, which COUNTIF function syntax is correct?
1. COUNTIF (ranger, criteria)
2. COUNTIF (criteria, range)
3. COUNTIF (criteria, range, col_index_num)
4. COUNTIF (range, criteria, col_index_num)
Question 10. Excel window is of type:
1. Application window
2. Document window
3. Folder window
4. All answers above