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:
- 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
-
4 ★ | 1 Vote
You should read it
- Microsoft Excel Test P15
- Microsoft Excel Test P7
- Test of CSS knowledge - Part 9
- eQuiz - Test of knowledge about the browser
- Microsoft Excel Test P14
- Microsoft Excel P8 test
- Test of CSS knowledge - Part 6
- Microsoft Excel P12 test
- Microsoft Excel Test P9
- Test of CSS knowledge - Part 7
- Microsoft Excel test - Part 4
- Test common knowledge about social culture P1
Maybe you are interested
Learn about Phind: The app that answers questions about coding with the power of AI
24 basic level C++ programming interview questions and answers
20 intermediate level C++ programming interview questions and answers
15 expert-level C++ programming interview questions and answers
Answering questions about the reasons for using a keyboard wrist rest
How to add branches or nested questions in Google Forms