TipsMake

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.

★ Test Microsoft Excel P16
★ Microsoft Excel Test P11
  • Question 1. In Excel worksheet, In cell A2 type in formula = MA30,10,65.5, then get the result in cell A2:
    • 5
    • 30
    • 65
    • 110
  • Question 2. In Excel, in cell A2 the value is "Tinhoc"; In cell C2, type in formula = A2, the result in C2 is:
    • #Value
    • TINHOC
    • News
    • Tinhoc
  • Question 3. In Excel spreadsheet, to filter the data automatically, after selecting the block to be filtered, we do:
    • Format - Filter - AutoFilter
    • Insert - Filter- Auto Filter
    • Data- Filter- AutoFilter
    • 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?
    • SUM
    • COUNTIF
    • COUNT
    • SUMIF
  • Question 5. In Excel spreadsheet, to insert a column into the worksheet, we execute:
    • Table - Insert Columns
    • Format- Cells- Insert Columns
    • Table- Inser Cells
    • Insert - Column
  • Question 6. When working with Excel, it is possible to move from one sheet to another using the keys or key combinations:
    • Page Up; Page Down
    • Ctrl - Page Up; Ctrl - Page Down
    • Both sentences are true
    • Both sentences are wrong
  • Question 7. In Excel, which of the SUMIF function syntax is correct?
    • SumIf (range, criteria, [sum_range])
    • SumIf (criteria, range, [sum_range])
    • SumIf (range)
    • 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)?
    • VALUE #?
    • 15
    • ten
    • 20
  • Question 9. In Excel, which COUNTIF function syntax is correct?
    • COUNTIF (ranger, criteria)
    • COUNTIF (criteria, range)
    • COUNTIF (criteria, range, col_index_num)
    • COUNTIF (range, criteria, col_index_num)
  • Question 10. Excel window is of type:
    • Application window
    • Document window
    • Folder window
    • All answers above

Discover more

quizzes excel basic knowledge fun tests informatics quizzes excel learning applying excel for work calculating on excel excel 2010
Marvin Fry

Share by

Marvin Fry
Update 24 May 2019

You should read it