Home Tech infoQuiz technology

Microsoft Excel Test P6

Continuing the series of articles on this topic will be the multiple choice questions that apply to the use of the software, hopefully it will be useful for you.

  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
quizzes excel basic knowledge fun tests computer tests
« PREV
NEXT »
Read more
Maybe you are interested