TipsMake

Microsoft Excel test - Part 4

In this article, go with Microsoft Network Administrator to learn about Microsoft Excel through multiple choice questions.

★ Microsoft Excel Test P15
★ Microsoft Excel Test P14
  • Question 1. In Microsoft Excel, in cell C5, the formula = $ A $ 2 * $ B $ 3, when copying to cell D6, the D6 formula has the formula:
    • = $ A $ 2 * $ B $ 3
    • = $ A $ 3 * $ B $ 4
    • = $ B $ 2 * $ C $ 3
    • = $ B $ 3 * $ C $ 4
  • Question 2. In Microsoft Excel, in cell E7, the formula = C $ 3- $ D4, when copied to cell H11, the cell H11 has the formula:
    • = F $ 8 - $ G8
    • = F $ 3 - $ D8
    • = C $ 8- $ G4
    • = C $ 3- $ D4
  • Question 3. To select contiguous areas in the worksheet, which key do you need to use the mouse with?
    • Ctrl and Shift
    • Alt
    • Ctrl
    • Shift
  • Question 4. In Microsoft Excel spreadsheet, to filter the data automatically, after selecting the block to be filtered, we do:
    • Format -> Filter -> AutoFilter
    • Insert -> Filter -> AutoFilter
    • Data -> Filter -> AutoFilter
    • View -> Filter -> AutoFilter
  • Question 5. In Microsoft Excel, suppose that cell A1 has data: 3> 5. The statement in cell B5 is: = A1 has the result:

    • 3> 5
    • False
    • True
    • False
  • Question 6. In Microsoft Excel, cell D2 has the formula "= B1 + C1", when copied to cell E2, cell E2 has the formula:
    • = C2 + D2
    • = C1 + C2
    • = B1 + D1
    • = C1 + D1
  • Question 7. In Excel, which COUNTIF function syntax is correct?
    • COUNTIF (range, criteria, col_index_num)
    • COUNTIF (range, criteria)
    • COUNTIF (criteria, range, col_index_num)
    • COUNTIF (criteria, range)
  • Question 8. In Microsoft Excel, the statement = MAX (7,5,2,9,3,1, -7) has the result:
    • first
    • -7
    • 9
    • 19
  • Question 9. To sum the cells from A1 to A7, which of the following is correct?
    • = SUM (A1): SUM (A7)
    • = SUM (A1 - A7)
    • = SUM (A1: A7)
    • = SUM (A1); SUM (A7)
  • Question 10. In Excel, what type of text can you display in a cell?
    • Tilting
    • Horizontal
    • Vertical
    • All 3 types above

Discover more

quizzes informatics tests software excel basic knowledge
Lesley Montoya

Share by

Lesley Montoya
Update 24 May 2019

You should read it