HomeTech infoQuiz technology

Microsoft Excel Test P6

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

You should read it

Quiz technology