Microsoft Excel Test P6

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

Understanding Microsoft Excel Test P6

• Question 1. While working with Microsoft Excel, to enter a calculation formula for a cell, we must first type:
  • Question mark (?)
  • Equal sign (=)
  • A colon (:)
  • Dollar sign ($)
• Question 2. In Microsoft Excel, the statement = MAX (7, 5, 2, 9, 3, 1, -7) results in:
  • -7
  • 7
  • 9
  • first
• Question 3. In Microsoft Excel, the statement = SQRT (196) results in:
  • 13
  • 14
  • 15
  • 16
• Question 4. In Microsoft Excel, the = MIN statement (6, 5, - 1, 2, 10, -4, 3, 1, -8) results in:
  • first
  • -first
  • -8
  • ten
• Question 5. In Microsoft Excel, in cell D5, the formula = $ B2 + C $3, when copied to cell D6, cell D6 has the formula:
  • = $ B2 + C $3
  • = $ B3 + C $3
  • = $ B3 + C $4
  • = $ B3 + D $3
• Question 6. In Microsoft Excel, in cell A2, the value of TINHOC is valid. In cell B2, the formula = LEFT (A2.3) gets the result:
  • Tinhoc
  • 3
  • BELIEVE
  • HOC
• Question 7. Microsoft Excel to save the content we make:
  • File -> New
  • File -> Close
  • File -> Save
  • File -> Open
• Question 8. In Microsoft Excel, the statement = SUM (7, 5, -3, 2, 9, -4) results in:
  • 15
  • 16
  • 17
  • 18
• Question 9. In the Microsoft Excel spreadsheet, in cell D2 there is a formula = B2 * C2/100. If the formula is copied to cell G6, the formula is:
  • E7 * F7/100
  • B6 * C6/100
  • E6 * F6/100
  • E2 * C2/100
• Question 10. In Microsoft Excel the following types of addresses, which address is the absolute address?
  • $ B1: $ D10
  • B $1: D $10
  • B $1 $: D $10 $
  • $ B $1: $ D $10