HomeTech infoQuiz technology

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.
  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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)
  8. 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
  9. 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)
  10. Question 10. Excel window is of type:
    1. Application window
    2. Document window
    3. Folder window
    4. All answers above
5 ★ | 1 Vote
quizzesexcelbasic knowledgefun testsinformatics quizzesexcel learningapplying excel for workcalculating on excelexcel 2010

You should read it

Maybe you are interested

Quiz technology