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.

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 ($)
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
Question 3. In Microsoft Excel, the statement = SQRT (196) results in:
1. 13
2. 14
3. 15
4. 16
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
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
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
Question 7. Microsoft Excel to save the content we make:
1. File -> New
2. File -> Close
3. File -> Save
4. File -> Open
Question 8. In Microsoft Excel, the statement = SUM (7, 5, -3, 2, 9, -4) results in:
1. 15
2. 16
3. 17
4. 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:
1. E7 * F7 / 100
2. B6 * C6 / 100
3. E6 * F6 / 100
4. E2 * C2 / 100
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

Jessica Tanner

Update 24 May 2019

« PREV : Test about...

Tests have answers... : NEXT »