HomeTech infoQuiz technology

Microsoft Excel Test P15

  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

Quiz technology