Microsoft Excel Test - Part 4

This article presents Microsoft Excel Test - Part 4 in a clear, structured format. It helps readers review key concepts, test their understanding, and learn from the material.

Understanding Microsoft Excel Test

• 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